09/29/2022 12:28 | Category: databases

Tags: postgresmaintenance

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;