analyze_workload_indexes
Analyzes frequently executed PostgreSQL queries to recommend optimal indexes, helping reduce slow query performance and improve workload efficiency.
Instructions
Analyze frequently executed queries in the database and recommend optimal indexes
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": "analyze_workload_indexes"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| method | No | Method to use for analysis | dta |
| max_index_size_mb | No | Max index size in MB |