get_autovacuum_activity
Monitor recent autovacuum and autoanalyze activity patterns, timing intervals, and execution history to troubleshoot scheduling issues and analyze workload distribution.
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
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "get_autovacuum_activity"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum number of tables to show (1-100, default: 50) | |
| hours_back | No | Time period to analyze in hours (default: 24, max: 168 for 7 days) | |
| schema_name | No | Schema to analyze (analyzes all user schemas if omitted) | |
| database_name | No | Target database name (uses default database from POSTGRES_DB env var if omitted) |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |