Hi Arnaud,
The pg_stat_activity system exists for your need.
Documentation on how and what to access:
http://www.postgresql.org/docs/current/static/monitoring.html (note that you will have to browse the chapter to get the details)
You will have to setup your postgresql.conf file, and enable the
stats_command_string (
boolean ) param.
Regards
On 2/24/06, Arnaud Lesauvage <thewild@free.fr> wrote:Hi List !
Is there an equivalent of mysql's "SHOW PROCESSLIST" command in
PostgreS ?
Sometimes my server takes a lot of processing power, and I would
like to know what it is doing.
Also, is there no way to kill a running query from *within*
postgres ? With a query, or something similar ?
The only way I found to kill running queries was to "kill <pid>"
from a command prompt, but that is not very clean, I can't run
this from a remote client.
Thanks a lot !
Regards
--
Arnaud
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
--
/"\ ASCII Ribbon Campaign .
\ / - NO HTML/RTF in e-mail .
X - NO Word docs in e-mail .
/ \ -----------------------------------------------------------------