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. -- Guillaume Cottenceau -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
