It could provide:
- number of used blocks and/or a % of shared_buffers
(will max to shared_buffers and 100%, except if filtered on a DB)
- number and % of dirty blocks
maybe split by db
Perhaps is it possible to target a specified table, db,or set of tables.
If filtering by DB or table, add a column showing with percentage of the table are in the shared_buffers.
Usage counts and pins are probably overkill.
It could provide:
(will max to shared_buffers and 100%, except if filtered on a DB)
maybe split by db
Perhaps is it possible to target a specified table, db,or set of tables.
If filtering by DB or table, add a column showing with percentage of the table are in the shared_buffers.
Usage counts and pins are probably overkill.