PrefectPostgreSQL

Table bloat exceeds 50% requiring manual VACUUM

warning
performanceUpdated Mar 24, 2026
How to detect:

Table bloat percentage exceeds 50%, indicating dead tuples are accumulating faster than autovacuum can reclaim them. Calculated as (dead_tuples / live_tuples) * 100.

Recommended action:

Run manual VACUUM ANALYZE on affected tables (flow_run, task_run, log). Monitor bloat with pg_stat_user_tables query filtering for n_dead_tup > 1000. Schedule VACUUM during low-traffic periods. Consider tuning autovacuum parameters to prevent future accumulation.