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