get_table_io_stats
Analyze table I/O statistics to compare disk reads against buffer cache hits, calculate hit ratios, and identify tables with poor cache performance for PostgreSQL tuning.
Instructions
[Tool Purpose]: Analyze I/O performance statistics for tables (disk reads vs buffer cache hits)
[Exact Functionality]:
Show heap, index, and TOAST table I/O statistics
Calculate buffer hit ratios for performance analysis
Identify tables with poor buffer cache performance
Provide detailed I/O breakdown by table component
[Required Use Cases]:
When user requests "table I/O stats", "buffer performance", "disk vs cache", etc.
When analyzing table-level I/O performance
When identifying tables causing excessive disk I/O
When optimizing buffer cache efficiency
[Strictly Prohibited Use Cases]:
Requests for I/O optimization actions
Requests for buffer cache configuration changes
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_table_io_stats"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema_name | No | Schema name to filter (default: public) | public |
| database_name | No | Database name to analyze (uses default database if omitted) |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |