Re: Is Autovacuum running? - Mailing list pgsql-general

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