Skip to content

Instantly share code, notes, and snippets.

@StevenJL

StevenJL/how_many_running_longer.sql

Created January 23, 2021 08:03
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save StevenJL/e830cc24c04f185fcdaf68c481e3fc9f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save StevenJL/e830cc24c04f185fcdaf68c481e3fc9f to your computer and use it in GitHub Desktop.
Download ZIP
How many queries running longer
Raw
how_many_running_longer.sql
SELECT count(*)
FROM pg_stat_activity
WHERE state != 'idle'
AND query_start < (NOW() - INTERVAL '60 seconds');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment