Skip to content

Instantly share code, notes, and snippets.

@vbilopav

vbilopav/pg_stat_statements extension

Created May 23, 2022 07:51
Show Gist options
  • Save vbilopav/c624dcef2f9ae430d92d35a89e1d8ccc to your computer and use it in GitHub Desktop.
Save vbilopav/c624dcef2f9ae430d92d35a89e1d8ccc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pg_stat_statements extension
CREATE EXTENSION pg_stat_statements SCHEMA public;
# postgresql.conf
shared_preload_libraries = 'pg_stat_statements' # (change requires restart)
pg_stat_statements.max = 10000
pg_stat_statements.track = all
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment