bloat_and_vacuum_analysis
Rank PostgreSQL tables needing vacuum by dead-tuple ratio and autovacuum recency, using injected bloat rows or live data, with cited recommendations.
Instructions
[READ] Rank tables needing vacuum from dead-tuple ratio + autovacuum recency.
Pass 'tables' (as from table_bloat) for pure/offline analysis, or omit to
pull the worst dead-tuple tables live. Each recommendation cites its numbers.
Args:
tables: Injected table-bloat rows; if omitted, pulled live.
limit: How many tables to pull when not injected (default 50).
target: Target name from config; omit for the default.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| tables | No | ||
| target | No |