pg_index_usage
Retrieve index usage statistics for user tables to identify unused or inefficient indexes.
Instructions
Retrieve index usage statistics for all user tables in the specified schema.
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": "pg_index_usage"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Schema to filter by. Defaults to the connection's defaultSchema (or 'public'). | |
| connectionId | No | Id of the postgres connection to use, from databases.config.yml. Optional when only one postgres connection is configured. |