Package pg_top

'top' for PostgreSQL process

http://pgfoundry.org/projects/ptop

pg_top is 'top' for PostgreSQL processes. See running queries,
query plans, issued locks, and table and index statistics.

General Commands
Command Description
pg_top display and update information about the top cpu PostgreSQL processes