Hi Arnaud,

The pg_stat_activity system exists for your need.

Documentation on how and what to access:

http://www.postgresql.org/docs/curre...onitoring.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 .
/ \ -----------------------------------------------------------------