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