Re: Add sub-transaction overflow status in pg_stat_activity - Mailing list pgsql-hackers

From Bossart, Nathan
Subject Re: Add sub-transaction overflow status in pg_stat_activity
Date
Msg-id 1B794E40-5217-4793-920A-0565037068AC@amazon.com
Whole thread Raw
In response to Re: Add sub-transaction overflow status in pg_stat_activity  (Dilip Kumar <dilipbalaut@gmail.com>)
Responses Re: Add sub-transaction overflow status in pg_stat_activity
List pgsql-hackers
Thanks for the new patch!

+       <para>
+        Returns a record of information about the backend's subtransactions.
+        The fields returned are <parameter>subxact_count</parameter> identifies
+        number of active subtransaction and <parameter>subxact_overflow
+        </parameter> shows whether the backend's subtransaction cache is
+        overflowed or not.
+       </para></entry>
+       </para></entry>

nitpick: There is an extra "</para></entry>" here.

Would it be more accurate to say that subxact_count is the number of
subxids that are cached?  It can only ever go up to
PGPROC_MAX_CACHED_SUBXIDS.

Nathan


pgsql-hackers by date:

Previous
From: "Bossart, Nathan"
Date:
Subject: Re: do only critical work during single-user vacuum?
Next
From: Petar Dambovaliev
Date:
Subject: Undocumented error