Sha256: 7b9cb282e6b3cba6a111bf8acbfe81cefaea340a8c2e9470dcf2b031cc42642a
Contents?: true
Size: 363 Bytes
Versions: 64
Compression:
Stored size: 363 Bytes
Contents
/* 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 '%{threshold}'
ORDER BY
now() - pg_stat_activity.query_start DESC;
Version data entries
64 entries across 64 versions & 1 rubygems