PostgreSQL 9.1 slow queries logging

gistfile1.txt

sudo apt-get install postgresql-contrib

# in /etc/postgresql/9.1/main/postgresql.conf
shared_preload_libraries = 'pg_stat_statements' 
custom_variable_classes = 'pg_stat_statements'

pg_stat_statements.max = 100
pg_stat_statements.track = top
pg_stat_statements.save = off

sudo service postgresql restart

# In pqsl
CREATE EXTENSION pg_stat_statements;

# Result
SELECT query, calls, total_time FROM pg_stat_statements ORDER BY total_time DESC LIMIT 5;