Re: Is Autovacuum running?

[Brad White <b55white@xxxxxxxxx>]

On Mon, Feb 20, 2023 at 1:42 PM Brad White <b55white@xxxxxxxxx> 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

Any suggestions on how to proceed?

Thanks,
Brad.