carltondickson/postgres-queries.md

Last active February 8, 2021 09:34

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/carltondickson/c356325e0d03459bca73ff13965acce6.js"></script>
Save carltondickson/c356325e0d03459bca73ff13965acce6 to your computer and use it in GitHub Desktop.

Download ZIP

Useful Postgres queries

Raw

postgres-queries.md

Source: Hans-Jürgen Schönig - PostgreSQL performance in 5 minutes https://youtu.be/5M2FFbVeLSs?t=757

SELECT substring(query, 1, 5000) AS short_query,
       round(total_time::numeric, 2) AS total_time,
       calls, round(mean_time::numeric, 2) AS mean,
       round((100*total_time/sum(total_time::numeric) OVER ())::numeric, 2) AS percentage_overall
FROM pg_stat_statements ORDER BY total_time DESC LIMIT 20;