Re: [EXT] pg_stat_activity.backend_xmin

2022-09-22 Thread Laurenz Albe
On Wed, 2022-09-21 at 16:22 +, 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

RE: [EXT] pg_stat_activity.backend_xmin

2022-09-21 Thread Dirschel, Steve
>> On Sep 21, 2022, at 9:32 AM, Dirschel, Steve >> wrote: >> >> 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

Re: [EXT] pg_stat_activity.backend_xmin

2022-09-21 Thread Rob Sargent
> On Sep 21, 2022, at 9:32 AM, Dirschel, Steve > wrote: > > 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_