pg_dbactivity.sql

CREATE VIEW db_activity AS
    SELECT (now() - pg_stat_activity.xact_start) as
   age, pg_stat_activity.datname, pg_stat_activity.pid, pg_stat_activity.usename, pg_stat_activity.state_change, pg_stat_activity.query_start, pg_stat_activity.client_addr, pg_stat_activity.client_port, pg_stat_activity.query 
  FROM pg_stat_activity WHERE ((pg_stat_activity.xact_start IS NOT NULL) AND ((now() - pg_stat_activity.xact_start) > '00:00:00.5'::interval)) and pg_stat_activity.pid<>pg_backend_pid() 
 ORDER BY pg_stat_activity.xact_start;