Postgres detect long running queries

SELECT

  pid,
  user,
  pg_stat_activity.query_start,
  now() - pg_stat_activity.query_start AS query_time,
  query,
  state,
  wait_event_type,
  wait_event
FROM
  pg_stat_activity
WHERE
  state = 'active'
  AND now() - pg_stat_activity.query_start > interval '10 minutes'
ORDER BY
  now() - pg_stat_activity.query_start DESC;