Ivan Voras <ivoras 'at' freebsd.org> writes:
> pgtop (http://pgfoundry.org/projects/pgtop/) might help you see what
> is your database doing.
A simpler (but most probably less powerful) method would be to
activate "stats_command_string = on" in the server configuration,
then issue that query to view the currently running queries:
SELECT procpid, datname, current_query, query_start FROM pg_stat_activity WHERE current_query <> '<IDLE>'
That may also be interesting.