Horton

Re: Add sub-transaction overflow status in pg_stat_activity

Robert Haas <robertmhaas@gmail.com>

View thread View on postgr.es
From: Robert Haas <robertmhaas@gmail.com>
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: Nathan Bossart <nathandbossart@gmail.com>, Andres Freund <andres@anarazel.de>, Bruce Momjian <bruce@momjian.us>, Tom Lane <tgl@sss.pgh.pa.us>, Julien Rouhaud <rjuju123@gmail.com>, "Bossart, Nathan" <bossartn@amazon.com>, Dilip Kumar <dilipbalaut@gmail.com>, Ashutosh Sharma <ashu.coek88@gmail.com>, pgsql-hackers@lists.postgresql.org
Date: 2022-12-12T17:51:42Z
Lists: pgsql-hackers 
On Mon, Dec 12, 2022 at 12:42 PM Justin Pryzby <pryzby@telsasoft.com> wrote:
> diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml
> index 4efa1d5fca0..ac15e2ce789 100644
> --- a/doc/src/sgml/monitoring.sgml
> +++ b/doc/src/sgml/monitoring.sgml
> @@ -5680,12 +5680,12 @@ FROM pg_stat_get_backend_idset() AS backendid;
>          <returnvalue>record</returnvalue>
>         </para>
>         <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>
> +        Returns a record of information about the subtransactions of the backend
> +        with the specified ID.
> +        The fields returned are <parameter>subxact_count</parameter>, which
> +        identifies the number of active subtransaction and
> +        <parameter>subxact_overflow</parameter>, which shows whether the
> +        backend's subtransaction cache is overflowed or not.
>         </para></entry>
>        </row>

Makes sense.

-- 
Robert Haas
EDB: http://www.enterprisedb.com

Commits

  1. Fix comment that was missing a word.

  2. Expose some information about backend subxact status.