monitoring postgres autovacuum executions
Recently when working with Postgres I had been tweaking some autovacuum settings to better assist in table maintenance. To monitor the changes in tables (how often they were autovacuumed) I ran the following query.
For more information on autovacuum check the following reference.
SELECT
relname,
last_vacuum,
last_autovacuum,
last_analyze,
last_autoanalyze
FROM
pg_stat_user_tables;