/* All queries longer than the threshold by descending duration. */

SELECT
  pid,
  now() - pg_stat_activity.query_start AS duration,
  query AS query
FROM
  pg_stat_activity
WHERE
  pg_stat_activity.query <> ''::text
  AND state <> 'idle'
  AND now() - pg_stat_activity.query_start > interval '200 milliseconds'
ORDER BY
  now() - pg_stat_activity.query_start DESC;
