Re: monitoring running transaction

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