bloat_blockers
Identify Postgres VACUUM blockers from a read-only timeline: get blocker PID, query, xmin age, and replication slot, prioritized by cause, then end the session and vacuum the table.
Instructions
Who is pinning VACUUM: blocker pid + query + xmin age + slot.
Read-only on the local timeline file. Priority: prepared-xact > stale-slot
idle-in-transaction. Fix: end the named session, then VACUUM the table. Args: db: Path to the SQLite timeline file (default: BLOAT_DB env). Returns: {blockers: [{ts, kind, pid, age, query, slot}] — newest first, max 20. Use pid with SELECT pg_terminate_backend(pid) after verification.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| db | No |