PostgreSQL每日一贴-pg_stat_statements工具安装使用

1. 进入postgresql-9.4.0/contrib/pg_stat_statements目录，执行make，编译出对应动态库pg_stat_statements.so
2. 将动态库拷贝到数据库服务器lib目录下
3. 拷贝pg_stat_statements.control、pg_stat_statements--1.2.sql到数据库服务器share/extension/目录下
4. 在配置文件postgresql.conf中增加如下参数:
shared_preload_libraries = 'pg_stat_statements'
pg_stat_statements.max = 10000
pg_stat_statements.track = all
5. 登陆到要安装该工具的数据库中，执行如下sql语句导入对应视图和存储过程
CREATE EXTENSION pg_stat_statements;
6. 检查是否安装成功
\d pg_stat_statements
\df pg_stat_statements_reset
\df pg_stat_statements
7. 测试
select pg_stat_statements_reset();
select * from pg_class where relname = 'pg_class';
select * from pg_class where relname = 'pg_attribute';

select * from pg_stat_statements;