PostgreSQL current queries view

pg_current_queries_view_sql.md

CREATE OR REPLACE VIEW public.current_queries_view
 AS
 SELECT pg_stat_activity.pid,
    age(clock_timestamp(), pg_stat_activity.query_start) AS age,
    pg_stat_activity.wait_event_type,
    pg_stat_activity.wait_event,
    pg_stat_activity.usename,
    replace(pg_stat_activity.query, '
'::text, ' '::text) AS trimmed_one_line_query,
    pg_stat_activity.application_name
   FROM pg_stat_activity
  WHERE pg_stat_activity.query <> '<IDLE>'::text AND pg_stat_activity.query !~~* '%pg_stat_activity%'::text
  ORDER BY (age(clock_timestamp(), pg_stat_activity.query_start)) DESC;