Re: Finding if old transactions are running...

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Finding if old transactions are running...
Дата
Msg-id 421D9E6B.2090707@familyhealth.com.au
обсуждение исходный текст
Ответ на Finding if old transactions are running...  (Christopher Browne <cbbrowne@acm.org>)
Ответы Re: Finding if old transactions are running...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: psql: recall previous command?
Следующее
От: Evgen Potemkin
Дата:
Сообщение: SQL99 Hierarchical queries