08. Aggregated table analysis
Compare all tables in your database by size, growth rate, dead tuples, and vacuum status. Use this dashboard to find tables that need attention.
When to use
- Checkup reports bloat or growth issues
- Identifying the largest tables and their growth trends
- Finding tables with high dead tuple ratios
- Planning maintenance, archiving, or partitioning
Key panels
- Largest tables by total size — tables ranked by total relation size (including TOAST and indexes)
- Table size over time — growth trends for the largest tables
- Dead tuple ratio — tables ranked by ratio of dead to live tuples
- Sequential scan frequency — tables with high sequential scan counts (may need indexes)
- Vacuum and analyze activity — when each table was last vacuumed and analyzed
- HOT update ratio — tables benefiting from HOT (Heap-Only Tuple) updates
What good looks like
- Growth aligns with expected application workload
- Dead tuple ratios are low (< 10%) for large tables
- Tables are regularly vacuumed and analyzed
- No unexpectedly large tables
What to investigate
| Signal | Next step |
|---|---|
| High dead tuple ratio | Drill into Single table analysis for vacuum history |
| Unexpected table growth | Check for missing archival, data retention policies, or bulk insert patterns |
| Many sequential scans | Table may need indexes — check Query performance for related queries |
| Table never vacuumed | Check Autovacuum and bloat for worker availability |
Related Checkup checks
- F001 — autovacuum current settings (CLI)
- F004 — heap bloat estimated (monitoring stack)