Re: Finding if old transactions are running...

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Christopher Browne <cbbrowne(at)acm(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Finding if old transactions are running...
Date: 2005-02-24 09:29:15
Message-ID: 421D9E6B.2090707@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Evgen Potemkin 2005-02-24 10:02:52 SQL99 Hierarchical queries
Previous Message Bjoern Metzdorf 2005-02-24 07:41:53 Re: invalid multibyte character for locale