Enabling pg_stat_statements

enabling_pg_stat_statements.md

Find the postgresql.conf location

$ psql -U postgres -c 'show config_file'

               config_file               
-----------------------------------------
 /path/to/postgresql.conf

Edit the file content by adding

shared_preload_libraries = 'pg_stat_statements'
pg_stat_statements.track = all

Restart the database

sudo systemctl restart postgresql

Execute the following on the database that you wish to track

CREATE EXTENSION IF NOT EXISTS pg_stat_statements;

Check by using

SELECT count(*) FROM pg_stat_statements;

Check configuration

psql -U postgres -c 'show max_wal_size'