On Sat, May 29, 2021 at 03:34:41PM +0100, dave@davebolt.co.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@sea.gmane.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@momjian.us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.