Re: equivalent of @@TRANCOUNT PostgreSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "dave@xxxxxxxxxxxxxx" <dave@xxxxxxxxxxxxxx>
Subject: Re: equivalent of @@TRANCOUNT PostgreSQL
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Sat, 29 May 2021 07:44:57 -0700
Cc: Julien Rouhaud <rjuju123@xxxxxxxxx>, "mustafa.pekgoz@xxxxxxxxxxxxxx" <mustafa.pekgoz@xxxxxxxxxxxxxx>, Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
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>

On Saturday, May 29, 2021, <dave@xxxxxxxxxxxxxx> 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.

Follow-Ups:
- Re: equivalent of @@TRANCOUNT PostgreSQL
  - From: MichaelDBA

References:
- equivalent of @@TRANCOUNT PostgreSQL
  - From: mustafa.pekgoz
- Re: equivalent of @@TRANCOUNT PostgreSQL
  - From: Julien Rouhaud
- RE: equivalent of @@TRANCOUNT PostgreSQL
  - From: dave

Prev by Date: RE: equivalent of @@TRANCOUNT PostgreSQL
Next by Date: Re: equivalent of @@TRANCOUNT PostgreSQL
Previous by thread: RE: equivalent of @@TRANCOUNT PostgreSQL
Next by thread: Re: equivalent of @@TRANCOUNT PostgreSQL
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux