Thread: monitoring running transaction

-----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?

- --
Shane
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE85XqJ5DXg6dCMBrQRAhCkAJ4lYEnIoowa67ajMe3gzAR0sP5EFgCcDjNu
TTRIiwXGx4d+R03LxjTiXSM=
=BvER
-----END PGP SIGNATURE-----

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