Health and performance · stop 4 of 13
index_usage
Shows how often each index on a table is used.
Works in read modeTool sets: dba · full
You might ask
“Are the indexes on orders being used?”
Your assistant may call index_usage to answer.
How it works
- Scan counts, size, type and definition for every index on the table, from
pg_stat_user_indexes.
Parameters
tablestringrequired- Table as "schema.name" (e.g. "public.orders").
What your assistant reads
The description nexql-mcp sends with the tool. It's how the assistant decides when to use it.
Get index usage statistics (scan counts, size, definition, type) for a specific table's indexes. Useful for finding unused or missing indexes.