The pg_stat_acticity is nice and all, but sometimes I like it when the activity is presented following this view definition:
SELECT extract(epoch FROM (now() - query_start))::numeric(5,2) AS age,
procpid, usename, client_addr, current_query
FROM pg_stat_activity
WHERE pg_stat_activity.current_query <> '<IDLE>'::text
ORDER BY 1;