Cache and I/O
pg_cache_ioReport PostgreSQL cache effectiveness and I/O by showing buffer cache hit ratios, pg_stat_io summaries, temp file use, and I/O timings to diagnose slow reads.
Instructions
Report cache effectiveness and I/O: the buffer cache hit ratio of the database, of the tables and of the indexes (worst first among the busy ones), a summary of pg_stat_io (PostgreSQL 16+), temporary file use, I/O timings when track_io_timing is on, and, if the pg_buffercache extension is installed, the relations that occupy shared_buffers.
A low hit ratio means reads go to the operating system or the disk; it does not count
the OS page cache, so a lower value is not always slow. limit caps each list.
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_cache_io"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| connection | No |