postgresql监控相关

 

1.活动会话数监控

[root@localhost scripts]# more get_pg_session_cnt.sh
#!/bin/bash
. /etc/profile
. ~/.bash_profile

export PGPASSWORD=postgres

session_cnt=`psql -h localhost -U postgres -p5432 -At<<EOF
select count(1) from pg_stat_activity where state='active' and pid<>pg_backend_pid();
\q
EOF`

##session_cnt01=`psql -h localhost -U postgres -p5432 -At -c "select count(1) from pg_stat_activity where state='act
ive'"`

echo $session_cnt
##echo $session_cnt01

说明:

-At:不输出表头和最后一行

必须设置PGPASSWORD环境变量,因为psql模式没有明文密码的参数