pg_activity is a top like application for PostgreSQL server activity monitoring.