get_index_usage_stats
Analyze PostgreSQL index usage frequency and efficiency to identify unused or unnecessary indexes and review scan and tuple-return statistics for performance optimization.
Instructions
[Tool Purpose]: Analyze usage rate and performance statistics of all indexes in database
[Exact Functionality]:
Analyze usage frequency and efficiency of all indexes
Identify unused indexes
Provide scan count and tuple return statistics per index
[Required Use Cases]:
When user requests "index usage rate", "index performance", "unnecessary indexes", etc.
When database performance optimization is needed
When index cleanup or reorganization is required
[Strictly Prohibited Use Cases]:
Requests for index creation or deletion
Requests for index reorganization or REINDEX execution
Requests for statistics reset
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_index_usage_stats"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_name | No | Database name to analyze (uses default database if omitted) |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |