Re: Finding if old transactions are running... - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Finding if old transactions are running...
Date
Msg-id 421D9E6B.2090707@familyhealth.com.au
Whole thread Raw
In response to Finding if old transactions are running...  (Christopher Browne <cbbrowne@acm.org>)
Responses Re: Finding if old transactions are running...
List pgsql-hackers
> It sure would be nice to be able to have a way to query the start time
> of the eldest transaction on the system.  If that could be done at a
> not-too-high cost, it would be eminently helpful for various sorts of
> maintenance processes so that you could assortedly:

You can get that from pg_stat_activity, if you have the relevant stats 
turned on.

Chris


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: psql: recall previous command?
Next
From: Evgen Potemkin
Date:
Subject: SQL99 Hierarchical queries