Re: Vacuum Issues

[Darron Harrison <darron@xxxxxxxxxxxxxxxx>]

Unable to run the first query and third query. I believe it's a version issue, as we are running 9.2.4.

No results from select * from pg_prepared_xacts on any of the servers.

Darron

---- On Thu, 26 Mar 2020 11:50:10 -0700 Rui DeSousa <rui@xxxxxxxxxxxxx> wrote ----

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;