get_autovacuum_activity
Monitor recent autovacuum and autoanalyze activity patterns to analyze execution history, frequency, timing intervals, and identify tables with irregular vacuum patterns in PostgreSQL databases.
Instructions
[Tool Purpose]: Monitor recent autovacuum and autoanalyze activity patterns and execution history
[Exact Functionality]:
Track recent autovacuum and autoanalyze execution patterns
Analyze autovacuum frequency and timing intervals
Show tables with most/least autovacuum activity
Calculate average time between autovacuum executions
Identify tables with irregular autovacuum patterns
[Required Use Cases]:
When user requests "autovacuum activity", "autovacuum history", "vacuum patterns", etc.
When monitoring autovacuum performance and effectiveness
When troubleshooting autovacuum scheduling issues
When analyzing autovacuum workload distribution
[Strictly Prohibited Use Cases]:
Requests for autovacuum process control or restart
Requests for autovacuum configuration modifications
Requests for manual vacuum scheduling
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) hours_back: Time period to analyze in hours (default: 24, max: 168 for 7 days) limit: Maximum number of tables to show (1-100, default: 50)
Returns: Recent autovacuum activity analysis with patterns and timing statistics
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_name | No | ||
| schema_name | No | ||
| hours_back | No | ||
| limit | No |