Forum OpenACS Q&A: Re: How to go about debugging a Postgres performance problem?

If you want to see what Postgres is upto you could try pgmonitor http://gborg.postgresql.org/project/pgmonitor/projdisplay.php

It will show you what your pg processes are upto and give you some idea of the load they are imposing although his choice of colours leaves a lot to be desired.

Whilst we are about it pgadmin3 http://www.pgadmin.org/pgadmin3/index.php is also useful for running speed test queries on remote db's etc.

    - Steve