EDB PWR
Tibero TPR, Oracle AWR같은 기능
PWR 설치를 위해선, 다음 Extension이 필수로 설치되어 있어야 한다.
필수 extension
pg_stat_statements, edb_wait_states
1. 필수 extension 설치
dnf install edb-as17-server-edb_wait_states
vi $PGDATA/postgresql.conf
shared_preload_libraries = '$libdir/dbms_pipe,$libdir/edb_gen,$libdir/dbms_aq,$libdir/pg_stat_statements,,$libdir/pg_prewarm,$libdir/edb_wait_states'
EPAS 재기동 후 접속
edb=# create extension pg_stat_statements;
edb=# create extension edb_wait_states;
2. PWR 설치
dnf install edb-pwr
3. epas pwr 및 lasso 설정
cp /etc/edb-lasso.conf.templ /etc/edb-lasso.conf
cp /etc/pwr.conf.templ /etc/pwr.conf
4. lasso 설정
vi /etc/edb-lasso.conf
id=test
token=test
5. 부하 테스트 시나리오
su - enterprisedb
# psql -p 5444 -U enterprisedb -d edb
# /usr/edb/as17/bin/pgbench -p 5444 -U enterprisedb -i edb
# /usr/edb/as17/bin/pgbench -p 5444 -U enterprisedb -i -s 10 edb
# /usr/edb/as17/bin/pgbench -p 5444 -U enterprisedb -c 32 -j 8 -t 10 edb
6. pwr report 추출
pwr execute --host-name 127.0.0.1 --port 5444 --sampling-start '2025-05-08 07:00:00' \
--sampling-end '2025-05-08 07:10:00' --pdf \
--report-name 'test' \
--output-dir /var/lib/edb edb