View running Processes ? - Mailing list pgsql-novice

From Arnaud Lesauvage
Subject View running Processes ?
Date
Msg-id 43FECAE8.8070303@free.fr
Whole thread Raw
Responses Re: View running Processes ?  ("Guido Barosio" <gbarosio@gmail.com>)
List pgsql-novice
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


pgsql-novice by date:

Previous
From: "Sears, Jeremy"
Date:
Subject: Re: php cant see new table!!
Next
From: Peter Weinzierl
Date:
Subject: Select with Regular Expressions