Contents

/* All queries longer than five minutes 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 '%{interval}'
ORDER BY
  now() - pg_stat_activity.query_start DESC;

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
ruby-pg-extras-1.3.0	lib/ruby-pg-extras/queries/long_running_queries.sql