Postgres Pro
Downloads
Home   >   mailing lists

Re: Open Transaction list - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Open Transaction list
Date
Msg-id 20030821150609.GG9803@libertyrms.info
Whole thread Raw
In response to Open Transaction list  (Joseph Tate <jtate@nospam.mi-corporation.com>)
List pgsql-general
Tree view 
On Wed, Aug 20, 2003 at 05:30:14PM -0400, Joseph Tate wrote:
> Is there a way to get a list of all the currently open transactions on a
> database?

You can use the statistics in pg_stat_activity if you have the query
stats turned on.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110

pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Buglist
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: Buglist