Re: Add sub-transaction overflow status in pg_stat_activity

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: Nathan Bossart <nathandbossart(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Bruce Momjian <bruce(at)momjian(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Julien Rouhaud <rjuju123(at)gmail(dot)com>, "Bossart, Nathan" <bossartn(at)amazon(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Add sub-transaction overflow status in pg_stat_activity
Date: 2022-12-12 17:51:42
Message-ID: CA+TgmoY7TDnW-FUg_+ydBoOLmdLSsHFwW_28sDf3w6LU=yuy+A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Dec 12, 2022 at 12:42 PM Justin Pryzby <pryzby(at)telsasoft(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nikita Malakhov 2022-12-12 19:14:08 Re: Re[2]: [PATCH] Optional OR REPLACE in CREATE OPERATOR statement
Previous Message Justin Pryzby 2022-12-12 17:42:02 Re: Add sub-transaction overflow status in pg_stat_activity