Tables are the core of your database. PG Pilot monitors table health to
help you optimize storage, detect performance issues, and plan capacity.
Every table is tracked with:
- Current size and row estimates
- Write activity (inserts, updates, deletes)
- Scan patterns (sequential vs index)
- Bloat metrics (live vs dead tuples)
What it monitors
- Table size and growth trends
- Row estimates and tuple counts
- Insert, update, delete activity
- Sequential scan vs index scan ratio
- Live and dead tuple counts
- Last vacuum and analyze times
- Autovacuum status per table
How to use
Navigate to the Tables section from the main navigation.
Table List
See all tables with key metrics:
- Size (data + indexes)
- Row estimate
- Recent write activity
Health Issues
The Issues tab shows tables with problems:
- High bloat (many dead tuples)
- High sequential scan ratio
- Autovacuum disabled
- Unlogged tables
Table Details
Click any table to see:
- Column information
- Associated indexes
- Write activity over time
- Related sequences
Schema View
Group tables by schema:
- Total size per schema
- Table counts
- Health summary