Skip to content

Instantly share code, notes, and snippets.

@kpy3
Forked from troyk/pg_stat_statements
Last active August 29, 2015 14:07
Show Gist options
  • Save kpy3/ff25be54088534b79ff1 to your computer and use it in GitHub Desktop.
Save kpy3/ff25be54088534b79ff1 to your computer and use it in GitHub Desktop.
1) see re: increasing shmmax http://stackoverflow.com/a/10629164/1283020
2) add to postgresql.conf:
shared_preload_libraries = 'pg_stat_statements' # (change requires restart)
136 pg_stat_statements.max = 1000
137 pg_stat_statements.track = all
3) restart postgres
4) check it out in psql
psql: CREATE EXTENSION pg_stat_statements;
psql: \x
psql: SELECT query, calls, total_time, rows, 100.0 * shared_blks_hit / nullif(shared_blks_hit + shared_blks_read, 0) AS hit_percent FROM pg_stat_statements ORDER BY total_time DESC LIMIT 5;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment