select datname,
 pid,
 sess_id,
 usename,
 client_addr ,
 query_start,
 query
 from pg_stat_activity;

希望对你有所帮助，如有帮助请采纳