Re: equivalent of @@TRANCOUNT PostgreSQL

On Sat, May 29, 2021 at 03:34:41PM +0100, dave(at)davebolt(dot)co(dot)uk wrote:
> @@TRANCOUNT: Transaction count.
>
> How many transactions are open at the moment.
>
> I’m not seeing anything that looks appropriate. As far as I can see it might be
> possible to do something using the Statistics Collector, see https://
> www.postgresql.org/docs/13/monitoring-stats.html
>
> Hope someone knowledgeable on PostgreSQL will have an answer.
>
> I did find this from 2006. https://www.postgresql.org/message-id/
> eg5op3$ria$1(at)sea(dot)gmane(dot)org

Uh, the only way I know to do that is to query pg_stat_activity like
this:

SELECT *
FROM pg_stat_activity
WHERE state != 'idle' AND backend_type = 'client backend';

However, the purpose of why you are using these values probably is not
going to translate to Postgres easily.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.