List prewarmed relations
list_prewarmed_relationsLists relations and their shared-buffer cache residency, sorted by blocks cached, to show which tables are prewarmed.
Instructions
Report current shared-buffer residency per relation, ranked by blocks-cached descending. Requires the pg_buffercache extension; returns an empty list when it's missing. Returns a list of objects with schema, table, blocks_cached (8 KiB pages currently in shared buffers), total_blocks (the relation's on-disk size in the same unit), pct_cached (the residency ratio rounded to 2 decimals), and dirty_blocks (pages with pending writes).
Example: list_prewarmed_relations(schema='public', limit=50)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| schema | No | ||
| 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 |
|---|---|---|---|
| result | Yes |