detect_index_misses
Detect tables with missing indexes by analyzing sequential scan dominance, foreign key columns without indexes, and under-indexed hot tables.
Instructions
Detect tables likely suffering from missing indexes: seq-scan dominance, FK columns without indexes, under-indexed hot tables.
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": "detect_index_misses"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | Database alias to query. Omit to use the primary database. |