Skip to content

Instantly share code, notes, and snippets.

@sauloperez

sauloperez/enable_pg_stat_statements.sh

Created February 23, 2019 09:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sauloperez/62f923ff726a3d81862d5b97cb8cc584 to your computer and use it in GitHub Desktop.
Save sauloperez/62f923ff726a3d81862d5b97cb8cc584 to your computer and use it in GitHub Desktop.
Download ZIP
Enable pg_stat_statements
Raw
enable_pg_stat_statements.sh
# At the bottom of add /etc/postgresql/9.5/main/postgresql.conf
shared_preload_libraries = 'pg_stat_statements'
pg_stat_statements.max = 10000
pg_stat_statements.track = all
sudo systemctl restart postgresql
sudo su postgres
psql
CREATE extension pg_stat_statements;
# You can only query pg_stat_statements as postgres user
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment