Expose some information about backend subxact status.
authorRobert Haas <rhaas@postgresql.org>
Mon, 19 Dec 2022 19:43:09 +0000 (14:43 -0500)
committerRobert Haas <rhaas@postgresql.org>
Mon, 19 Dec 2022 19:43:09 +0000 (14:43 -0500)
commit10ea0f924a2788f9e701d6213745aaa5ca3efb8a
tree7b59764577d935ade39514b0c500237acb38a527
parent7122f9d5437789312cb0a7e26e853bb8d2e57add
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.

Discussion: http://postgr.es/m/CAFiTN-ut0uwkRJDQJeDPXpVyTWD46m3gt3JDToE02hTfONEN=Q@mail.gmail.com
doc/src/sgml/monitoring.sgml
src/backend/storage/ipc/sinvaladt.c
src/backend/utils/activity/backend_status.c
src/backend/utils/adt/pgstatfuncs.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.dat
src/include/storage/sinvaladt.h
src/include/utils/backend_status.h