Autovacuum "queue" and progress
Monitor and manage autovacuum queue, understand worker activity and vacuum progress
10 docs tagged with "maintenance"
View All TagsHow to deal with bloat
Detect, measure, and eliminate table and index bloat to maintain database health
How to find redundant indexes
How to find unused indexes
How to monitor transaction ID wraparound risks
How to monitor xmin horizon to prevent XID/MultiXID wraparound and high bloat
How to rebuild many indexes using many backends avoiding deadlocks
How to run ANALYZE (to collect statistics)
Learn how to how to run analyze (to collect statistics)