VACUUM is PostgreSQL's essential maintenance operation that:
- Reclaims space from deleted/updated rows (dead tuples)
- Freezes old transaction IDs to prevent wraparound
- Updates table statistics for the query planner
PG Pilot provides visibility into all vacuum operations, helping you:
- Ensure autovacuum is keeping up with write activity
- Identify tables at risk of XID wraparound
- Track vacuum progress on long-running operations
- Tune autovacuum settings per table
What it monitors
- Running vacuum operations with progress
- Tables needing vacuum (dead tuple ratio)
- Freeze age for all tables
- Autovacuum activity history
- Tables with autovacuum disabled
- XID age towards wraparound
How to use
Navigate to the Vacuum section from the main navigation.
Running Vacuums
See all currently running vacuum and autovacuum operations:
- Table being vacuumed
- Phase (scanning heap, vacuuming indexes, etc.)
- Progress percentage
- Dead tuples found
Tables Needing Vacuum
Tables sorted by urgency based on:
- Dead tuple count and ratio
- Time since last vacuum
- Freeze age approaching limits
Freeze Age Monitoring
Tables approaching autovacuum_freeze_max_age:
- Current freeze age
- Percentage towards emergency vacuum
- Time until wraparound risk
Autovacuum Disabled
Tables with autovacuum manually disabled.
These tables won't be vacuumed automatically and require manual maintenance.