get_vacuum_effectiveness_analysis
Analyze PostgreSQL VACUUM effectiveness to identify suboptimal maintenance patterns, compare manual vs autovacuum performance, and calculate maintenance efficiency ratios without performance impact.
Instructions
[Tool Purpose]: Analyze VACUUM effectiveness and maintenance patterns using existing statistics
[Exact Functionality]:
Compare manual VACUUM vs autovacuum effectiveness patterns
Analyze VACUUM frequency vs table activity (DML operations)
Identify tables with suboptimal VACUUM patterns
Calculate maintenance efficiency ratios without performance impact
Show VACUUM coverage analysis across all tables
[Required Use Cases]:
When user requests "VACUUM effectiveness", "maintenance efficiency", "VACUUM analysis", etc.
When planning manual VACUUM schedules or autovacuum tuning
When identifying tables with poor maintenance patterns
When analyzing overall database maintenance health
[Strictly Prohibited Use Cases]:
Requests for VACUUM execution or scheduling
Requests for autovacuum configuration changes
Requests for maintenance operation control
Args: database_name: Target database name (uses default database from POSTGRES_DB env var if omitted) schema_name: Schema to analyze (analyzes all user schemas if omitted) limit: Maximum number of tables to analyze (1-100, default: 30)
Returns: VACUUM effectiveness analysis with maintenance patterns and recommendations
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_name | No | ||
| schema_name | No | ||
| limit | No |