I was wondering if there is a tool either as part of the Postgres or
avaliable
as a seperate utilitiy that would allow us to monitor how much of the
database
resources are being used up by each particular query while they are
running.
I ask because we run a lot of rather large queries and it would be
useful to
be able tell at a glance which one it eating all the resources.

Many Thanks
David Phillips

Fuzzydave <dav.phillips (AT) ntlworld (DOT) com> wrote:
I don't know - there's a number of pg_stat_get_*(oid) functions that
belong to the statistics collection, but I don't know anything about
them.

Since every query is executed by a special process, the backend, you can
use OS commands to find out the resource consumption of the query.
Apart from shared memory usage, that is.

Yours,
Laurenz Albe

thats great thanks I'll go look up the statistics collection adn try
the
OS side thanks for the suggestions

David P