Created
May 16, 2016 13:16
-
-
Save Madusudanan/cf41ad220182f1d2595677572303e34a to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
(total_time / 1000 / 60)::decimal as total_minutes, | |
(total_time/calls)::decimal as average_time, | |
query | |
FROM pg_stat_statements | |
ORDER BY 1 DESC | |
LIMIT 100; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment