From: | Darron Harrison <darron(at)realtyserver(dot)com> |
---|---|
To: | "Rui DeSousa" <rui(at)crazybean(dot)net> |
Cc: | "pgsql-admin" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Vacuum Issues |
Date: | 2020-03-26 19:01:36 |
Message-ID: | 1711838a1a0.b8776dce198656.4553889266632620330@realtyserver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)crazybean(dot)net> wrote ----
On Mar 26, 2020, at 2:10 PM, Darron Harrison <mailto:darron(at)realtyserver(dot)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;
From | Date | Subject | |
---|---|---|---|
Next Message | Rui DeSousa | 2020-03-26 19:22:57 | Re: Vacuum Issues |
Previous Message | Rui DeSousa | 2020-03-26 18:50:10 | Re: Vacuum Issues |