Postgres Pro
Downloads
Home   >   mailing lists

Re: equivalent of @@TRANCOUNT PostgreSQL - Mailing list pgsql-admin

From David G. Johnston
Subject Re: equivalent of @@TRANCOUNT PostgreSQL
Date
Msg-id CAKFQuwZZDB5bSYK+MzEvbdGCCSeLrG+eC5UC4NraVLmw=iEkaQ@mail.gmail.com
Whole thread Raw
In response to RE: equivalent of @@TRANCOUNT PostgreSQL  (<dave@davebolt.co.uk>)
Responses Re: equivalent of @@TRANCOUNT PostgreSQL
List pgsql-admin
Tree view

On Saturday, May 29, 2021, <dave@davebolt.co.uk> wrote:

@@TRANCOUNT: Transaction count.

How many transactions are open at the moment.


pg_stat_activity could be used for this.  One transaction per process actively executing a query.

David J. 

pgsql-admin by date:

Previous
From:
Date:
Subject: RE: equivalent of @@TRANCOUNT PostgreSQL
Next
From: MichaelDBA
Date:
Subject: Re: equivalent of @@TRANCOUNT PostgreSQL