On Thu, 2022-12-08 at 21:01 +0530, Satalabaha Postgres wrote:
> I would like to understand the possible causes for backend_xmin getting
> populated in pg_stat_activity. Can someone throw some light on this?
"backend_xid" is set when the session has an open transaction that has
modified data and therefore got a transaction ID.
"backend_xmin" is set if there is an active snapshot held by the session:
- there is a running query
- there is an open transaction with an open cursor
- there is an open transaction with isolation level REPEATABLE READ or higher
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com