bloat_check
Diagnose PostgreSQL bloat from a read-only timeline file, returning per-table and per-index verdicts with evidence and actionable fixes.
Instructions
Diagnose PostgreSQL bloat from a collected timeline.
Read-only: only reads the local SQLite timeline file, never touches Postgres. Args: db: Path to the SQLite timeline file (default: BLOAT_DB env, 'timeline.db'). Collect one first with bloat_collect, or pass any timeline.db path. Returns: findings: list of {table, verdict, evidence, action} — verdict is one of normal | vacuum-starved | blocked-by-idle-xact | blocked-by-slot | blocked-by-prepared | blocked-by-active-xact | needs-rewrite | index-bloated | index-unused. Evidence carries dead/live counts, pgstattuple approx %, pgstatindex %, blocker pid+query.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| db | No |