View running Processes ?

From: Arnaud Lesauvage <thewild(at)free(dot)fr>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: View running Processes ?
Date: 2006-02-24 08:59:20
Message-ID: 43FECAE8.8070303@free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Arnaud Lesauvage 2006-02-24 09:32:26 View running Processes ?
Previous Message Bruno Wolff III 2006-02-24 00:52:32 Re: check problem