Skip site navigation (1) Skip section navigation (2)

Re: Finding if old transactions are running...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Christopher Browne <cbbrowne(at)acm(dot)org>,pgsql-hackers(at)postgresql(dot)org
Subject: Re: Finding if old transactions are running...
Date: 2005-02-24 16:14:07
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
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 HaganderDate: 2005-02-24 16:35:57
Subject: Some download statistics
Previous:From: Joel FradkinDate: 2005-02-24 16:10:41
Subject: Re: invalid multibyte character for locale

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group