pgsql: Expose some information about backend subxact status.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Expose some information about backend subxact status.
Date: 2022-12-19 19:56:11
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-committers

Expose some information about backend subxact status.

A new function pg_stat_get_backend_subxact() can be used to get
information about the number of subtransactions in the cache of
a particular backend and whether that cache has overflowed. This
can be useful for tracking down performance problems that can
result from overflowed snapshots.

Dilip Kumar, reviewed by Zhihong Yu, Nikolay Samokhvalov,
Justin Pryzby, Nathan Bossart, Ashutosh Sharma, Julien
Rouhaud. Additional design comments from Andres Freund,
Tom Lane, Bruce Momjian, and David G. Johnston.




Modified Files
doc/src/sgml/monitoring.sgml | 18 ++++++++++++++
src/backend/storage/ipc/sinvaladt.c | 13 +++++++---
src/backend/utils/activity/backend_status.c | 4 ++-
src/backend/utils/adt/pgstatfuncs.c | 38 +++++++++++++++++++++++++++++
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_proc.dat | 7 ++++++
src/include/storage/sinvaladt.h | 4 ++-
src/include/utils/backend_status.h | 11 +++++++++
8 files changed, 90 insertions(+), 7 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2022-12-19 20:08:35 pgsql: Fix typo in comment
Previous Message Alvaro Herrera 2022-12-19 16:47:13 Re: pgsql: Doc: Explain about Column List feature.