analyze_table_bloat
Detect database bloat by analyzing dead tuple ratios or InnoDB fragmentation, vacuum history, and table sizes to identify performance bottlenecks.
Instructions
Analyze table bloat by checking dead tuple ratios (PostgreSQL) or InnoDB fragmentation (MySQL), vacuum history, and table sizes.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Database schema to analyze (default: public) | public |
| timeout_ms | No | Connection timeout in milliseconds (default: 30000). Increase for slow or remote databases. |