SELECT p.procpid, p.usename, p.datname, p.query_start, p.backend_start, p.client_addr, p.current_query
FROM pg_stat_activity AS p;

peshka's reminder site – ver. 2.0
SELECT p.procpid, p.usename, p.datname, p.query_start, p.backend_start, p.client_addr, p.current_query
FROM pg_stat_activity AS p;