From c22533a6c8a8526b75a95ccf0eb39b5d10cca1f2 Mon Sep 17 00:00:00 2001 From: Bertrand Drouvot Date: Wed, 9 Apr 2025 18:11:28 +0000 Subject: [PATCH v1] Add pg_buffercache_numa usage example Add a query showing pg_buffercache_numa usage. --- doc/src/sgml/pgbuffercache.sgml | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) diff --git a/doc/src/sgml/pgbuffercache.sgml b/doc/src/sgml/pgbuffercache.sgml index 537d6014942..86846830e48 100644 --- a/doc/src/sgml/pgbuffercache.sgml +++ b/doc/src/sgml/pgbuffercache.sgml @@ -550,6 +550,30 @@ regression=# SELECT n.nspname, c.relname, count(*) AS buffers public | spgist_text_tbl | 182 (10 rows) +regression=# SELECT n.nspname, c.relname, m.numa_node, count(*) AS buffers + FROM pg_buffercache b JOIN pg_class c + ON b.relfilenode = pg_relation_filenode(c.oid) AND + b.reldatabase IN (0, (SELECT oid FROM pg_database + WHERE datname = current_database())) + JOIN pg_namespace n ON n.oid = c.relnamespace + JOIN pg_buffercache_numa m ON b.bufferid = m.bufferid + GROUP BY n.nspname, c.relname, m.numa_node + ORDER BY 4 DESC + LIMIT 10; + + nspname | relname | numa_node | buffers +------------+------------------------+-----------+--------- + public | delete_test_table_pkey | 1 | 395 + public | delete_test_table | 0 | 367 + pg_catalog | pg_attribute | 0 | 306 + pg_catalog | pg_attribute | 1 | 273 + public | delete_test_table | 1 | 228 + pg_catalog | pg_largeobject | 0 | 193 + public | tenk1 | 1 | 188 + public | gin_test_idx | 1 | 187 + public | quad_poly_tbl | 1 | 182 + public | tenk2 | 0 | 176 +(10 rows) regression=# SELECT * FROM pg_buffercache_summary(); buffers_used | buffers_unused | buffers_dirty | buffers_pinned | usagecount_avg -- 2.34.1