bloat_collect
Captures a read-only Postgres bloat snapshot into timeline history, then returns fresh per-table and per-index verdicts with recommended actions for safe production diagnosis.
Instructions
Take a read-only Postgres snapshot into the timeline, then return fresh verdicts.
Safe on prod: read-only transaction, 5s statement timeout, needs only pg_stat_* views + optional pgstattuple extension. No writes, no agents. Args: dsn: Postgres DSN, e.g. 'dbname=app user=readonly host=db.internal'. Default: BLOAT_DSN env. Never logs the password. Returns: {snapshot: 'saved', db: path, findings: [...with action per table/index]}.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dsn | No |