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