| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: monitoring running transaction |
| Date: | 2002-05-21 14:13:56 |
| Message-ID: | 20020521101356.E18921@mail.libertyrms.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-05-21 14:25:07 | Re: data addition speed or how to fast add data? |
| Previous Message | Joel Burton | 2002-05-21 13:38:38 | Re: [NOVICE] Problem with inserting: attribute 'extended_reason' |