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