get_autovacuum_status
Analyze PostgreSQL autovacuum configuration and maintenance status to identify tables needing attention, calculate dead tuple ratios, and estimate next vacuum execution likelihood.
Instructions
[Tool Purpose]: Analyze autovacuum configuration and current maintenance status for tables
[Exact Functionality]:
Analyze autovacuum trigger conditions based on dead tuple thresholds
Calculate current dead tuple ratios vs autovacuum trigger points
Show autovacuum configuration settings per table
Identify tables requiring immediate autovacuum attention
Estimate next autovacuum execution likelihood
[Required Use Cases]:
When user requests "autovacuum status", "autovacuum configuration", "vacuum trigger analysis", etc.
When planning autovacuum optimization and tuning
When troubleshooting autovacuum performance issues
When identifying tables with autovacuum problems
[Strictly Prohibited Use Cases]:
Requests for autovacuum configuration changes
Requests for manual VACUUM execution
Requests for autovacuum process restart or 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) table_pattern: Table name pattern to filter (SQL LIKE pattern, e.g., 'user%', '%log%', 'temp_*') limit: Maximum number of tables to analyze (1-100, default: 50)
Returns: Autovacuum configuration status with trigger analysis and maintenance recommendations
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_name | No | ||
| schema_name | No | ||
| table_pattern | No | ||
| limit | No |