get_table_io_stats
Analyze PostgreSQL table I/O performance by comparing disk reads versus buffer cache hits to identify tables with poor cache efficiency and optimize database performance.
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
Args: database_name: Database name to analyze (uses default database if omitted) schema_name: Schema name to filter (default: public)
Returns: Table I/O statistics including heap, index, and TOAST performance metrics
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_name | No | ||
| schema_name | No | public |