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_xminfrom pg_stat_activitywhere backend_xmin is not nullorder by age(backend_xmin) desclimit 10;Two-phase transactions:select * from pg_prepared_xacts;Replication slots: select * from pg_replication_slots;
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?
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных