From: | Rui DeSousa <rui(at)crazybean(dot)net> |
---|---|
To: | Darron Harrison <darron(at)realtyserver(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Vacuum Issues |
Date: | 2020-03-26 19:22:57 |
Message-ID: | EB0BC3D5-EE49-4863-963F-932A5D148A2B@crazybean.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
> On Mar 26, 2020, at 3:01 PM, Darron Harrison <darron(at)realtyserver(dot)com> wrote:
>
> Unable to run the first query and third query. I believe it's a version issue, as we are running 9.2.4.
>
Looks like backend_xmin was added in 9.4; shoot
Replication slots was added in 9.4, too; no slots to worry about.
Since you don’t have access to backend_xmin; you have check the master and all the replicas as you have feedback enabled.
I would look at all non “idle” sessions — i.e. “idle in tran” could be holding on to an old xmin.
select pid
, usename
, client_addr
, client_port
, state
, age(now(), state_change) as state_time
, age(now(), xact_start) as xact_time
from pg_stat_activity
where state != 'idle'
order by xact_time desc
;
From | Date | Subject | |
---|---|---|---|
Next Message | Darron Harrison | 2020-03-26 20:18:36 | Re: Vacuum Issues |
Previous Message | Darron Harrison | 2020-03-26 19:01:36 | Re: Vacuum Issues |