From: Tom Lane <tgl@sss.pgh.pa.us>
To: dave@davebolt.co.uk
cc: "'Julien Rouhaud'" <rjuju123@gmail.com>, mustafa.pekgoz@forenda.com.tr,
        "'Pgsql-admin'" <pgsql-admin@lists.postgresql.org>
Subject: Re: equivalent of @@TRANCOUNT PostgreSQL
In-reply-to: <042901d75497$c2da72d0$488f5870$@co.uk>
References: <004101d7548b$894e0ce0$9bea26a0$@forenda.com.tr>
 <CAOBaU_bwoQ8Hos1rrMHmGyzA5TfP0oJ0J3tHGYabod_Pe6YwHw@mail.gmail.com>
 <042901d75497$c2da72d0$488f5870$@co.uk>
Comments: In-reply-to <dave@davebolt.co.uk>
	message dated "Sat, 29 May 2021 15:34:41 +0100"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <2045345.1622299864.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Sat, 29 May 2021 10:51:04 -0400
Message-ID: <2045346.1622299864@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2045346.1622299864%40sss.pgh.pa.us>
Precedence: bulk

<dave@davebolt.co.uk> writes:
> @@TRANCOUNT: Transaction count.
> How many transactions are open at the moment.
> I=E2=80=99m not seeing anything that looks appropriate. As far as I can =
see it might be possible to do something using the Statistics Collector, s=
ee https://www.postgresql.org/docs/13/monitoring-stats.html

Yeah, something like this should do for that:

select count(*) from pg_stat_activity where state is not null;

			regards, tom lane