PostgreSQL模块 pg_stat_statements安装(慢sql原因查找)

• su postgres
  
• vim /var/lib/pgsql/9.4/data/postgresql.conf
  #postgresql.conf
  #------------------------------------------------------------------------------
  # PG_STAT_STATEMENTS OPTIONS
  #------------------------------------------------------------------------------
  shared_preload_libraries = 'pg_stat_statements'
  custom_variable_classes = 'pg_stat_statements'
  pg_stat_statements.max = 1000
  pg_stat_statements.track = all
  
• 编译安装pg_stat_statements模块
  进入postgresql的源码目录：
  cd /usr/pgsql-9.4/share/extension/pg_stat_statements
  
  make
  
  make install
  
  
  如果$pgpath/share/extension目录下存在pg_stat_statements--1.0.sql，说明安装成功了
  
  
  
• psql -f ../share/extension/pg_stat_statements--1.2.sql -p 5432
  
• create extension pg_stat_statements;         #创建pg_stat_statements
  
• SELECT pg_stat_statements_reset();          #清空pg_stat_statements(可以不做)
  
  安装完成后可以 select from pg_stat_statements 查看sql的执行情况