martinrusev
4/21/2015 - 5:39 AM

Enable Postgres Stats

Enable Postgres Stats

# Install
sudo apt-get install postgres-contrib

# In postgres.conf
shared_preload_libraries = 'pg_stat_statements'
pg_stat_statements.max = 10000
pg_stat_statements.track = all

# In any database 
create extension pg_stat_statements;