Autovacuum falling behind on tables causes bloat accumulation
warningResource ContentionUpdated Feb 15, 2026
Technologies:
How to detect:
Autovacuum processes cannot keep up with table update rates, allowing dead tuples to accumulate. pgwatch monitors autovacuum activity to detect this condition.
Recommended action:
Check pgwatch autovacuum activity dashboards or query pg_stat_user_tables for last_autovacuum timestamps and n_dead_tup counts. Increase autovacuum_max_workers, adjust autovacuum thresholds (autovacuum_vacuum_threshold, autovacuum_vacuum_scale_factor), or schedule manual VACUUM during maintenance windows.