pg_top

pg_top is 'top' for PostgreSQL. It is derived from Unix Top. Similar to top, pg_top allows you to monitor PostgreSQL processes. It also allows you to:

• View currently running SQL statement of a process.
• View query plan of a currently running SQL statement.
• View locks held by a process.
• View user table statistics.
• View user index statistics.

Install to Ubuntu server:
* download : axel http://pgfoundry.org/frs/download.php/1780/pg_top-3.6.2.tar.bz2
* install lib: sudo apt-get install libpq-dev
* uncompress:
tar -xvf pg_top-3.6.2.tar.gz
cd pg_top-3.6.2
* install
./configure
make
make install