Table Bloat Report
pg_bloat_reportIdentify tables with high dead-tuple ratios that require VACUUM or AUTOVACUUM to improve query performance and reduce storage waste.
Instructions
Identify tables with high dead-tuple ratios that need VACUUM or AUTOVACUUM attention.
Dead rows accumulate from UPDATE and DELETE operations. High dead% degrades query performance and wastes storage. Tables over ~20% dead tuples should be vacuumed.
Args:
schema: Filter to a specific schema (optional)
min_dead_pct: Minimum dead tuple % to include (default: 5)
min_dead_rows: Minimum absolute dead row count (default: 1000)
response_format: Output format
Returns: JSON: { tables: BloatInfo[], count: number } Markdown: table sorted by dead% descending, with last vacuum dates
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Filter to schema (optional) | |
| min_dead_pct | No | Minimum dead row % threshold | |
| min_dead_rows | No | Minimum dead row count threshold | |
| response_format | No | Output format: 'markdown' for human-readable, 'json' for machine-readable | markdown |