Fix pg_stat_get_backend_activity() to use multi-byte truncated result

Michael Paquier <michael@paquier.xyz>

Commit: 300575fe2e7f0f75bec92682cd9122a72998fd04
Author: Michael Paquier <michael@paquier.xyz>
Date: 2025-12-27T08:23:56Z
Releases: 15.16
Fix pg_stat_get_backend_activity() to use multi-byte truncated result

pg_stat_get_backend_activity() calls pgstat_clip_activity() to ensure
that the reported query string is correctly truncated when it finishes
with an incomplete multi-byte sequence.  However, the result returned by
the function was not what pgstat_clip_activity() generated, but the
non-truncated, original, contents from PgBackendStatus.st_activity_raw.

Oversight in 54b6cd589ac2, so backpatch all the way down.

Author: Chao Li <li.evan.chao@gmail.com>
Discussion: https://postgr.es/m/CAEoWx2mDzwc48q2EK9tSXS6iJMJ35wvxNQnHX+rXjy5VgLvJQw@mail.gmail.com
Backpatch-through: 14

Files

PathChange+/−
src/backend/utils/adt/pgstatfuncs.c modified +1 −1

Discussion