pgTop is a console-based (non-gui) tool for monitoring the threads and overall performance of a PostgreSQL server. pgTop is written in python.
The pgTop - a top clone for PostgreSQLproject is a PostgreSQL Community project that is a part of the pgFoundry.
The pgFoundry page for the project is at http://pgfoundry.org/projects/pgtop, where you can find downloads, documentation, bug reports, mailing lists, and a whole lot more.