v1-0001-Fixes-a-clip-bug-in-pg_stat_get_backend_activity.patch

From 0f72d7dfb49979d1350233dcbfa7d965d87a5f1b Mon Sep 17 00:00:00 2001
From: "Chao Li (Evan)" <lic@highgo.com>
Date: Fri, 26 Dec 2025 11:43:19 +0800
Subject: [PATCH v1] Fixes a clip bug in pg_stat_get_backend_activity()

pg_stat_get_backend_activity() already calls pgstat_clip_activity() to
truncate overly long activity strings, but it mistakenly returned the
original st_activity_raw value instead of the clipped result.

Fix this by returning the clipped activity string.

Author: Chao Li <lic@highgo.com>
---
 src/backend/utils/adt/pgstatfuncs.c | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/src/backend/utils/adt/pgstatfuncs.c b/src/backend/utils/adt/pgstatfuncs.c
index 2341ac76ae9..a97aa7c73db 100644
--- a/src/backend/utils/adt/pgstatfuncs.c
+++ b/src/backend/utils/adt/pgstatfuncs.c
@@ -806,7 +806,7 @@ pg_stat_get_backend_activity(PG_FUNCTION_ARGS)
 		activity = beentry->st_activity_raw;
 
 	clipped_activity = pgstat_clip_activity(activity);
-	ret = cstring_to_text(activity);
+	ret = cstring_to_text(clipped_activity);
 	pfree(clipped_activity);
 
 	PG_RETURN_TEXT_P(ret);
-- 
2.39.5 (Apple Git-154)