From 444e093ea44698f4b57e03220e9680cf149343b6 Mon Sep 17 00:00:00 2001 From: Jakub Wartak Date: Tue, 4 Nov 2025 12:05:13 +0100 Subject: [PATCH] 0009 --- contrib/pg_buffercache/pg_buffercache--1.6--1.7.sql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/contrib/pg_buffercache/pg_buffercache--1.6--1.7.sql b/contrib/pg_buffercache/pg_buffercache--1.6--1.7.sql index 306063e159e..d97fb08e8eb 100644 --- a/contrib/pg_buffercache/pg_buffercache--1.6--1.7.sql +++ b/contrib/pg_buffercache/pg_buffercache--1.6--1.7.sql @@ -42,7 +42,10 @@ LANGUAGE C PARALLEL SAFE; -- Create a view for convenient access. CREATE VIEW pg_buffercache_pgproc AS - SELECT P.* FROM pg_buffercache_pgproc() AS P + SELECT P.partition, P.numa_node, P.num_procs, + '0x' || to_hex(P.pgproc_ptr) as pgproc_ptr, + '0x' || to_hex(P.fastpath_ptr) as fastpath_ptr + FROM pg_buffercache_pgproc() AS P (partition integer, numa_node integer, num_procs integer, pgproc_ptr bigint, fastpath_ptr bigint); -- 2.39.5