find_dead_weight
Identify indexes that cost writes but earn nothing: unused, duplicated, or redundant. Review them as safe removal candidates.
Instructions
Find indexes that cost writes but earn nothing: never-scanned indexes, exact duplicates, prefix-redundant pairs, and (if pgstattuple is installed) b-tree indexes with low leaf density.
These are observations, safe quick wins to review — pgverdict does not drop anything and never will. Mind stats_since: an index used by a rare job can look unused within a short window.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"profile": "<profile>"
},
"name": "find_dead_weight"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| profile | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||