Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuum Issues - Mailing list pgsql-admin

From Rui DeSousa
Subject Re: Vacuum Issues
Date
Msg-id 8612E7A0-95FE-45DD-92BF-99FF68757BCF@crazybean.net
Whole thread Raw
In response to Vacuum Issues  (Darron Harrison <darron@realtyserver.com>)
Responses Re: Vacuum Issues  (Darron Harrison <darron@realtyserver.com>)
List pgsql-admin
Tree view


On Mar 26, 2020, at 2:10 PM, Darron Harrison <darron@realtyserver.com> 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;

pgsql-admin by date:

Previous
From: Darron Harrison
Date:
Subject: Vacuum Issues
Next
From: Darron Harrison
Date:
Subject: Re: Vacuum Issues