| From: | "Rudi Starcevic" <rudi(at)oasis(dot)net(dot)au> |
|---|---|
| To: | "Ramil Sagum" <ramil(at)astra(dot)ph>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: get current queries |
| Date: | 2003-08-18 12:05:15 |
| Message-ID: | 20030818120515.M77941@oasis.net.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> is there any way to see what statements/queries are currently being passed
> on to the database?
Yes - I haven't got around to installing it yet but 'pgmonitor' over
at http://gborg.postgresql.org/project/pgmonitor/projdisplay.php sounds
like what your after.
Here's the overview:
"This is a Tcl/Tk script that displays current database connections, and
allows you to view the currently executing query, cancel the query, or
terminate the session. You can also start/stop the postmaster."
I believe it requires X on your database server.
I haven't got X on my database server so I have used it yet but it looks
really cool.
For you other Admin's do you have X on your servers ?
Cheers
Rudi.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe | 2003-08-18 12:07:57 | Re: Connection Timeout |
| Previous Message | Ramil Sagum | 2003-08-18 09:22:19 | get current queries |