Read PG buffercache summary
read_pg_buffercache_summaryProvides a high-level summary of PostgreSQL shared buffer cache, including total, free, used, and dirty buffers, plus average usage count. Helps assess cache efficiency and memory pressure.
Instructions
Read a high-level summary of the PostgreSQL shared buffer cache usage. Reports total buffers, free/used buffers, dirty buffers, and average usage count. Requires the pg_buffercache extension. If not installed, returns available=false.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | Optional: target a configured secondary (read-only) database by name; omit for the primary. Call list_databases to see the configured ids. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| available | Yes | ||
| free_buffers | No | ||
| used_buffers | No | ||
| dirty_buffers | No | ||
| total_buffers | No | ||
| average_usage_count | No |