bloat_and_vacuum_analysis
Rank tables needing vacuum by dead-tuple ratio and autovacuum recency. Accepts injected table-bloat rows for offline analysis or pulls live worst tables, with metrics cited for each recommendation.
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 |