Christopher Kings-Lynne <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
