pg_wait_sampling-等待事件监控

pg_wait_sampling

安装

# su - postgres
$ git clone https://github.com/postgrespro/pg_wait_sampling.git
$ cd pg_wait_sampling
$ make USE_PGXS=1
$ sudo make USE_PGXS=1 install
$ make USE_PGXS=1 installcheck

# vi /var/lib/pgsql/10/data/postgresql.conf

shared_preload_libraries = 'pg_stat_statements, pg_wait_sampling'

# systemctl restart postgresql-10.service 


postgres=# create extension pg_wait_sampling;
postgres=# select name,setting from pg_settings where name like 'pg_wait_sampling%';

压测一波

# su - postgres

$ pgbench -r -j 2 -c 4 -T 60 -P 1 -h localhost -p 5432 pgbenchdb

check

select * from pg_wait_sampling_current;