analyze_vacuum
Identify tables needing manual VACUUM by analyzing dead tuple ratios, vacuum staleness, and autovacuum configuration in PostgreSQL databases.
Instructions
Analyze PostgreSQL VACUUM maintenance status. Checks dead tuple ratios, vacuum staleness, autovacuum configuration, and identifies tables needing manual VACUUM. PostgreSQL only.
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. |