How to list what queries are running in postgres? - Mailing list pgsql-admin

From P.A.M. van Dam
Subject How to list what queries are running in postgres?
Date
Msg-id 20040623213446.GA31224@pmg.xs4all.nl
Whole thread Raw
Responses Re: How to list what queries are running in postgres?
List pgsql-admin
Hi!

I'm looking for a command or method to find out what queries are
currently being serviced by the database.

Once in a while a query goes berzerk and uses up all CPU. I'd like to
find out which query is the culprit and want to kill it off. In Sybase
you can get a list of running "processes" within the database and kill
the offending one. Is there an equivalent in postgres?

Right now we only have the method to shutdown the database en restart it
to get rid of the culprit.

Thanks in advance!

Best regards,

    Pascal

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Binary/source for 7.4.3
Next
From: Ivo Rossacher
Date:
Subject: Re: Change the character encoding of a database