Postgres Pro
Downloads
Home   >   mailing lists

Thread: View running Processes ?

View running Processes ?

From
Arnaud Lesauvage
Date:
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

Re: View running Processes ?

From
"Guido Barosio"
Date:
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 .
/ \ -----------------------------------------------------------------