Re: Vacuum Issues

[Rui DeSousa <rui@xxxxxxxxxxxxx>]

On Mar 26, 2020, at 2:10 PM, Darron Harrison <darron@xxxxxxxxxxxxxxxx> wrote:

Anyone have any thoughts on what we should be checking next?

Check the backend_xmin in pg_stat_activity; is the holdup in one of replicas or on the master? 

select pid

 , usename

 , client_addr

 , state

 , backend_type

 , backend_xid

 , backend_xmin

from pg_stat_activity

where backend_xmin is not null

order by age(backend_xmin) desc

limit 10

;

Two-phase transactions:

select * from pg_prepared_xacts;

Replication slots: 

select * from pg_replication_slots;