Re: Is Autovacuum running?

On Tue, Feb 21, 2023 at 2:56 PM David Rowley <dgrowleyml(at)gmail(dot)com> wrote:

> On Tue, 21 Feb 2023 at 08:42, Brad White <b55white(at)gmail(dot)com> wrote:
> >
> > I'm concerned that Autovacuum may not be running based on the results of
> this query.
> >
> > SELECT relname, last_vacuum, last_autovacuum FROM pg_stat_user_tables;
> > gives 211 rows like this...
> > relname | last_vacuum | last_autovacuum
> > BusinessIncidentCategories | null | null
> > Valid Use | null | null
> > Serial Pool Part Types | null | null
> > BusinessIncidentLog | null | null
> > Rate Categories | null | null
>
> It's probably worth having a look at:
>
> select datname,stats_reset,now() from pg_stat_database where datname =
> current_database();
>
> while you're connected to the database with those tables. If you're
> resetting the stats, then that resets the counters used by autovacuum
> and also the columns you mention above. That can lead to autovacuum
> not doing any vacuuming or analyzing.
>
> Well that explains a lot.

datname | stats_reset | now
DB | 2023-02-17 14:28:27-06 | 2023-02-21 16:16:34-06

I heard that the system was running slowly on Friday. They may have cycled
the service in an attempt to resolve that.

I went ahead and ran ANALIZE. We'll see if that affects anything.

Thanks,
Brad.