From: Rui DeSousa <rui@crazybean.net>
To: Darron Harrison <darron@realtyserver.com>
Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Vacuum Issues
Date: Thu, 26 Mar 2020 15:22:57 -0400
Message-ID: <EB0BC3D5-EE49-4863-963F-932A5D148A2B@crazybean.net> (raw)
In-Reply-To: <1711838a1a0.b8776dce198656.4553889266632620330@realtyserver.com>
References: <171180a0730.f301716f192269.5929166075824764633@realtyserver.com>
<8612E7A0-95FE-45DD-92BF-99FF68757BCF@crazybean.net>
<1711838a1a0.b8776dce198656.4553889266632620330@realtyserver.com>
> On Mar 26, 2020, at 3:01 PM, Darron Harrison <darron@realtyserver.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
;=
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: rui@crazybean.net, darron@realtyserver.com, pgsql-admin@lists.postgresql.org
Subject: Re: Vacuum Issues
In-Reply-To: <EB0BC3D5-EE49-4863-963F-932A5D148A2B@crazybean.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox