Skip site navigation (1) Skip section navigation (2)

View running Processes ?

From: Arnaud Lesauvage <thewild(at)freesurf(dot)fr>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: View running Processes ?
Date: 2006-02-24 09:32:26
Message-ID: 43FED2AA.4000501@freesurf.fr (view raw or flat)
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

pgsql-novice by date

Next:From: A. KretschmerDate: 2006-02-24 09:41:34
Subject: Re: View running Processes ?
Previous:From: Arnaud LesauvageDate: 2006-02-24 08:59:20
Subject: View running Processes ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group