pg_bloat_estimate
Estimate table and index bloat in PostgreSQL by analyzing dead to live tuple ratios, identifying tables exceeding a configurable dead tuple threshold.
Instructions
Estimate table and index bloat using pg_stat_user_tables statistics (dead tuples vs live tuples ratio). Returns tables where dead tuple ratio exceeds a threshold.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Schema to filter by. Defaults to the connection's defaultSchema (or 'public'). | |
| connectionId | No | Id of the postgres connection to use, from databases.config.yml. Optional when only one postgres connection is configured. | |
| min_dead_ratio_pct | No | Minimum dead tuple percentage to include (default: 10%). |