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;