PG 插件安装

一、pg_stat_statements

1.1 PG9.3 pg_stat_statements

PG9.3 安装 pg_stat_statements



# 

sudo yum install postgresql-contrib


shared_preload_libraries = 'pg_stat_statements'
# Increase the max size of the query strings Postgres records
track_activity_query_size = 2048
# Track statements generated by stored procedures as well
pg_stat_statements.track = all







# 将pg_stat_statements复制到/usr/pgsql-9.3/share/contrib路径下
cp /usr/pgsql-9.3/share/extension/pg_stat_statements--1.1.sql /usr/pgsql-9.3/share/contrib



# 重启pg服务



：：q！

1.2 PG11

# 
# ### 安装contrib
# 



# 安装对应版本的contrib
yum install postgresql11-contrib.x86_64



# 
sudo -u postgres psql



# 创建一个pg_trgm测试
create extension pg_trgm;

# 验证
\dT

# 退出
\q







# 
# ### 配置 postgresql.conf 文件
# 

shared_preload_libraries = 'pg_stat_statements'                # (change requires restart)


# 
# ### 重启PG
# 







# 
# ### 在某个租户内使用
# 

create extension pg_stat_statements; 

二、

三、