监控项类型 | 应用集 | 监控项说明 | 监控项 |
普通 | DB_PostgreSQL Bgwrite | 每秒分配的缓冲区数量 | Allocation buffers/sec |
每秒后端写入的缓冲区数量 | Backend buffers/sec |
每秒后端强制写入的缓冲区数量 | Backend fsync buffers/sec |
每秒检查点写入的缓冲区数量 | Checkpoint buffers/sec |
每秒发生的强制检查点数量 | Checkpoint count (by checkpoint_segments) /sec |
每秒发生的计划检查点数量 | Checkpoint count (by checkpoint_timeout) /sec |
每秒后台进程写入的缓冲区数量 | Cleaned buffers/sec |
DB_PostgreSQL General | 数据库版本 | PG version |
DB_PostgreSQL Log | 日志文件中错误信息 | Log of /var/lib/pgsql/data/pg_log/postgresql-.*\.log |
DB_PostgreSQL Monitor | 执行脚本(获取PG数据脚本-版本相关) | Run script pgsql_vgeneral.sh |
执行脚本(获取PG数据脚本-数据库相关) | Run script pgsql_dbstat.sh |
执行脚本(获取PG数据脚本) | Run script pgsql_general.sh |
DB_PostgreSQL SlowQuery | DML慢查询操作数量(执行超过10s) | Slow DML queries |
慢查询操作数量(执行超过10s) | Slow queries |
SELECT慢查询操作数量(执行超过10s) | Slow select queries |
DB_PostgreSQL Status | postgres进程数量 | Number of postgres process |
5432端口侦听状态 | Port 5432 listening status |
主数据库状态 | Primary server status |
备数据库状态 | Standby server status |
DB_PostgreSQL Transcation | 活动连接数 | Active (SQL processing) connections |
总连接数 | Connections of server |
空闲连接数 | Idle connections |
处于事务中的空闲连接数 | Idle in transaction connections |
锁等待连接数 | Lock waiting connections |
最大连接数 | Max connections |
每秒提交事务数量 | Total commited transactions/sec |
每秒回滚事务数量 | Total rolled back transactions/sec |
LLD | DB_PostgreSQL DBInfo | 活动的连接数 | {#DBNAME} Active connections |
缓存命中率 | {#DBNAME} Cache hit ratio (%) |
每秒提交事务数量 | {#DBNAME} Commited transactions/sec |
数据大小 | {#DBNAME} DB Size |
死锁数量 | {#DBNAME} Deadlocks |
预估的垃圾数据占比 | {#DBNAME} Estimate DB Garbage ratio % |
每秒回滚事务数量 | {#DBNAME} Rolled back transactions/sec |
临时文件增长大小 | {#DBNAME} Temp bytes |
每秒删除元组数量 | {#DBNAME} Tuples deleted/sec |
每秒获取元组数量 | {#DBNAME} Tuples fetched/sec |
每秒插入元组数量 | {#DBNAME} Tuples inserted/sec |
每秒返回元组数量 | {#DBNAME} Tuples returned/sec |
每秒更新元组数量 | {#DBNAME} Tuples updated/sec |
普通 | DB_PostgreSQL HACluster | keepalived进程数量 | Number of keepalived process |
VIP状态(是否在本机上) | VIP alive status |
VIP连接性 | VIP replication status |
配置文件是否有修改 | Checksum of file /etc/keepalived/keepalived.conf |
判断脚本是否有修改 | Checksum of file /etc/keepalived/pgsql_check.sh |