Re: Add sub-transaction overflow status in pg_stat_activity

On Tue, Dec 13, 2022 at 5:09 AM Dilip Kumar <dilipbalaut(at)gmail(dot)com> wrote:
>
> On Mon, Dec 12, 2022 at 11:21 PM Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> >
> > 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.
>
> +1

+1