Re: monitoring running transaction

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: monitoring running transaction
Дата
Msg-id 20020521101356.E18921@mail.libertyrms.com
обсуждение исходный текст
Ответ на monitoring running transaction  (Shane Wright <me@shanewright.co.uk>)
Список pgsql-general
On Fri, May 17, 2002 at 10:47:53PM +0100, Shane Wright wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi
>
> Is there a way of monitoring running transactions to see what locks they hold
> and what queries they have run?

Not "what they have run", but "what they are running" is sort of
available in 7.2.x.  Or try (the excellent) pg_monitor:

    http://gborg.postgresql.org/project/pgmonitor/projdisplay.php
A

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110


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

Предыдущее
От: "Joel Burton"
Дата:
Сообщение: Re: [NOVICE] Problem with inserting: attribute 'extended_reason'
Следующее
От: Tom Lane
Дата:
Сообщение: Re: data addition speed or how to fast add data?