get_index_io_stats
Analyze PostgreSQL index I/O performance by showing disk reads versus buffer cache hits, identifying indexes with poor cache efficiency and excessive disk I/O to optimize buffer usage.
Instructions
[Tool Purpose]: Analyze I/O performance statistics for indexes (disk reads vs buffer cache hits)
[Exact Functionality]:
Show index-level I/O statistics and buffer hit ratios
Identify indexes with poor buffer cache performance
Provide detailed I/O performance metrics per index
Help optimize index and buffer cache usage
[Required Use Cases]:
When user requests "index I/O stats", "index buffer performance", etc.
When analyzing index-level I/O performance
When identifying indexes causing excessive disk I/O
When optimizing index buffer cache efficiency
[Strictly Prohibited Use Cases]:
Requests for index optimization actions
Requests for buffer cache configuration changes
Requests for statistics reset
Args: database_name: Database name to analyze (uses default database if omitted) schema_name: Schema name to filter (default: public)
Returns: Index I/O statistics including buffer hit ratios and performance metrics
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_name | No | ||
| schema_name | No | public |