0009.patch_txt

application/octet-stream

Download

From 444e093ea44698f4b57e03220e9680cf149343b6 Mon Sep 17 00:00:00 2001
From: Jakub Wartak <jakub.wartak@enterprisedb.com>
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