| From: | Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz> |
|---|---|
| To: | Cristian Prieto <cristian(at)clickdiario(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Help with process list II |
| Date: | 2005-04-14 20:25:17 |
| Message-ID: | Pine.LNX.4.44.0504142219400.19405-100000@kix.fsv.cvut.cz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 14 Apr 2005, Cristian Prieto wrote:
> Hello, I have a couple of bussy pgsql 8 servers running in my office, in
> MySQL I use SHOW PROCESSLIST to show the actual process running in the
> MySQL server (idle time, resources and other statistical data) and a
> little perl app named mytop to show the data like the top unix
> utility... There such way to do the same or similar stuff in PostgreSQL?
>
PostgreSQL can log long time executed sql commands. Set
log_min_duration_statement on some value in your postgresql.conf file.
I have good experience with it. Its very usefull for finding long sql
cmds.
regards
Pavel Stehule
| From | Date | Subject | |
|---|---|---|---|
| Next Message | OpenMacNews | 2005-04-14 20:26:41 | pgsql config flag update: apple rendezvous renamed bonjour |
| Previous Message | Alvaro Herrera | 2005-04-14 20:21:00 | Re: use SAVEPOINT function |