Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
>> 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.
pg_stat_activity will tell you about the oldest active query, but not
about oldest open transaction.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Magnus Hagander||Date: 2005-02-24 16:35:57|
|Subject: Some download statistics|
|Previous:||From: Joel Fradkin||Date: 2005-02-24 16:10:41|
|Subject: Re: invalid multibyte character for locale|