The Autovacuum Disabled Tables alert notifies you when its configured condition is met on PostgreSQL instances so you can investigate and respond.
Mini DBA describes this alert as: User tables where autovacuum is disabled through table storage options. Disabled autovacuum can allow bloat and transaction ID wraparound risk to build unnoticed. Mini DBA evaluates this alert once a minute so changes are detected quickly.
This alert highlights PostgreSQL maintenance pressure. It helps identify tables or transaction patterns that can increase bloat, weaken planner statistics, or allow transaction ID age to approach an unsafe level.
Enable it on PostgreSQL systems where delayed maintenance, table bloat, stale statistics, or transaction ID age would require investigation. Use table and workload baselines to avoid treating short maintenance bursts as incidents.
Threshold meaning: Tables. Major threshold: 0 tables. Comparison direction: over. For an over-threshold alert, decreasing a threshold makes that severity fire sooner; increasing it tolerates more load or pressure. Set the minor threshold as an early-warning level and the major threshold at the highest acceptable value for the service.
Review the affected tables, autovacuum and analyze history, dead tuples, transaction age, and long-running transactions. Tune table-level maintenance settings or run controlled maintenance, then confirm that cleanup and statistics collection keep pace with the workload.
Use duration and table-count thresholds to avoid paging on a short maintenance cycle. Keep the alert sensitive enough to catch tables that remain overdue, transaction age that keeps rising, or maintenance that repeatedly fails to catch up.