RE: [EXT] Re: pg_stat_activity.backend_xmin

2022-09-21 Thread Dirschel, Steve
On Wed, 2022-09-21 at 14:11 +, Dirschel, Steve wrote: >> We are troubleshooting an issue where autovacuum is not cleaning up a table. >> The application using this database runs with autocommit turned off. >> We can see in pg_stat_activity lots of sessions “idle in transaction” >> even though

Re: pg_stat_activity.backend_xmin

2022-09-21 Thread Laurenz Albe
On Wed, 2022-09-21 at 14:11 +, Dirschel, Steve wrote: > We are troubleshooting an issue where autovacuum is not cleaning up a table. > The application using this database runs with autocommit turned off. > We can see in pg_stat_activity lots of sessions “idle in transaction” even > though those