Let see in contrib/ the application pg_who ... you will see the process, the queries, and the CPU ... ;o)
Even easier:
SELECT * FROM pg_stat_activity;
As a superuser.
Chris
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html