有奖捉虫:云通信与企业服务文档专题,速来> HOT

命名空间

Namespace = QCE/POSTGRES

监控指标

指标英文名
指标中文名
指标说明
单位
维度
统计规则 [period, statType]
2pc
2PC 事务数
对数据库发起采集时,当前的2PC 事务数量
Count
resourceId
[5s, first] [60s, sum] [300s, sum]
ActiveConns
活跃连接数
对数据库发起采集时,数据库瞬时活跃连接(非 idle 连接)
Count
resourceId
[5s, first] [60s, max] [300s, max]
Connections
连接数
对数据库发起采集时,数据库当前总连接数
count
resourceId
[5s, first] [60s, avg] [300s, avg] [3600s, avg] [86400s, avg]
Cpu
CPU 利用率
CPU 实际利用率
%
resourceId
[5s, first] [60s, avg] [300s, avg] [3600s, max] [86400s, max]
DataFileSize
数据文件大小
数据文件占用空间大小
KBytes
resourceId
[5s, max] [60s, max] [300s, max]
Deadlocks
死锁数
一个统计周期内的所有死锁数
Count
resourceId
[5s, first] [60s, max] [300s, max]
HitPercent
缓冲区缓存命中率
一个统计周期内的所有 SQL 语句执行的命中率
%
resourceId
[5s, first] [60s, max] [300s, max] [3600s, max] [86400s, max]
IdleConns
空闲连接数
对数据库发起采集时,查询出来的数据库瞬时空闲连接(idle 连接)
Count
resourceId
[5s, first] [60s, avg] [300s, avg]
IdleInXact
空闲的事务数
对数据库发起采集时,数据库正在处于 idle in transaction 状态的事务数量
Count
resourceId
[5s, first] [60s, max] [300s, max]
LogFileSize
日志文件大小
wal 日志文件占用空间大小
KBytes
resourceId
[5s, first] [60s, max] [300s, max]
Long2pc
超过5秒未提交的2PC 事务数
对数据库发起采集时,当前执行时间超过5s的2PC 事务数量
Count
resourceId
[5s, first] [60s, max] [300s, max]
LongIdleInXact
超过5秒的空闲事务数
对数据库发起采集时,状态处于 idle in transaction 且时间超过5秒的事务数量
Count
resourceId
[5s, first] [60s, max] [300s, max]
LongQuery
执行时长超过1秒的 SQL 数
对数据库发起采集时,正在执行且执行时间超过1秒的 SQL 数量
Count
resourceId
[5s, first] [60s, max] [300s, max]
LongWaiting
等待超过5秒的会话数
对数据库发起采集时,数据库正在等待且超过5秒的会话数量(状态为 waiting)
Count
resourceId
[5s, first] [60s, max] [300s, max]
LongXact
执行时长超过1秒的事务数目
对数据库发起采集时,执行时间超过1秒的事务数量
Count
resourceId
[5s, first] [60s, max] [300s, max]
Memory
内存占用量
内存实际使用量
MBytes
resourceId
[5s, first] [60s, max] [300s, max]
MemoryRate
内存使用率
内存实际使用率
%
resourceId
[5s, first] [60s, max] [300s, max]
NewConnIn5s
5秒内新建的连接数
对数据库发起采集时,查询出最近5秒内建立的所有连接数
Count
resourceId
[5s, first] [60s, max] [300s, max]
OtherCalls
其他请求数
一个统计周期内的其他请求数(除 SELECT, INSERT, UPDATE, DELETE 以外的请求数)
Count
resourceId
[5s, first] [60s, sum] [300s, sum] [3600s, avg] [86400s, avg]
Qps
每秒查询数
平均每秒执行的 SQL 语句数量
count/s
resourceId
[5s, first] [60s, max] [300s, max] [3600s, max] [86400s, max]
ReadCalls
读请求数
一个统计周期内的读请求数
Count
resourceId
[5s, first] [60s, sum] [300s, sum] [3600s, max] [86400s, max]
ReadWriteCalls
读写请求数
一个统计周期内的读写请求数
Count
resourceId
[5s, first] [60s, sum] [300s, sum] [3600s, avg] [86400s, avg]
RemainXid
剩余 XID 数量
对数据库发起采集时,显示当前剩余 xid 最少的库的剩余 xid 数量。只读实例无此指标
count
resourceId
[5s, first] [60s, min] [300s, min] [3600s, min] [86400s, min]
SlaveApplyDelay
主备数据同步延迟
备库回放 LSN 与主实例当前 LSN 之间的大小差异,对于主实例而言,此指标可以体现出故障切换的 RTO,对于只读实例而言,此指标可以体现出数据延迟大小
s
resourceId
[5s, first] [60s, max] [300s, max]
SlowQueryCnt
慢查询数量
一个统计周期内的慢查询个数
Count
resourceId
[5s, first] [60s, max] [300s, max]
SqlRuntimeAvg
平均执行时延
一次统计周期内所有 SQL 语句的平均执行时延
ms
resourceId
[5s, first] [60s, avg] [300s, avg] [3600s, avg] [86400s, avg]
SqlRuntimeMax
最长 TOP10 执行时延
一次统计周期内最长 TOP10 的 SQL 平均执行时延
ms
resourceId
[5s, first] [60s, avg] [300s, avg] [3600s, avg] [86400s, avg]
SqlRuntimeMin
最短 TOP10 执行时延
一次统计周期内最短 TOP10 的 SQL 平均执行时延
ms
resourceId
[5s, first] [60s, avg] [300s, avg] [3600s, avg] [86400s, avg]
Storage
已用存储空间
整实例空间占用大小
GB
resourceId
[5s, first] [60s, max] [300s, max] [3600s, max] [86400s, max]
StorageRate
存储空间使用率
总的存储空间使用率,包括临时文件、数据文件、日志文件以及其他类型的数据库文件
%
resourceId
[5s, first] [60s, max] [300s, max] [3600s, max] [86400s, max]
TempFileSize
临时文件大小
临时文件的大小
KBytes
resourceId
[5s, max] [60s, max] [300s, max]
Tps
每秒事务数
平均每秒执行成功的事务数(包括回滚和提交)
Count/s
resourceId
[5s, first] [60s, avg] [300s, avg]
TupDeleted
每秒删除记录数
一个统计周期内的平均每秒删除的 tuple 数量
Count/s
resourceId
[5s, first] [60s, max] [300s, max]
TupFetched
每秒索引扫描记录数
一个统计周期内的平均每秒索引扫描的 tuple 数量
Count/s
resourceId
[5s, first] [60s, max] [300s, max]
TupInserted
每秒插入记录数
一个统计周期内的平均每秒插入的 tuple 数量
Count/s
resourceId
[5s, first] [60s, max] [300s, max]
TupReturned
每秒全表扫描记录数
一个统计周期内的平均每秒全表扫描的 tuple 数量
Count/s
resourceId
[5s, first] [60s, max] [300s, max]
TupUpdated
每秒更新记录数
一个统计周期内的平均每秒更新的 tupe 数量
Count/s
resourceId
[5s, first] [60s, max] [300s, max]
Waiting
等待会话
对数据库发起采集时,数据库正在等待的会话数量(状态为 waiting)
Count
resourceId
[5s, first] [60s, max] [300s, max]
WriteCalls
写请求数
一个统计周期内的写请求数
Count
resourceId
[5s, first] [60s, sum] [300s, sum] [3600s, avg] [86400s, avg]
XactCommit
事务提交数
一个统计周期内的平均每秒提交事务数
Count/s
resourceId
[5s, first] [60s, max] [300s, max]
XactRollback
事务回滚数
一个统计周期内的平均每秒回滚事务数
Count/s
resourceId
[5s, first] [60s, max] [300s, max]
XlogDiff
备库日志发送与回放位置差异
日志从主库发送至备库与备库回放完成之间的大小差异,主要反映了备库日志应用的速度,主要能够通过此指标查看出备库的性能、网络传输的速度。只读实例无此指标
Byte/s
resourceId
[5s, first] [60s, max] [300s, max] [3600s, max] [86400s, max]
XlogDiffTime
备库日志落盘时间延迟
日志从主库发送至备库与备库接收到日志并落盘之间的时间差异。只读实例无此指标,且实例版本在10.x以上版本才有此指标
s
resourceId
[5s, first] [60s, max] [300s, max]
说明
每个指标的统计粒度(Period)可取值不一定相同,可通过 DescribeBaseMetrics 接口获取每个指标支持的统计粒度。

各维度对应参数总览

参数名称
维度名称
维度解释
格式
Instances.N.Dimensions.0.Name
resourceId
resourceId 维度名称
输入 String 类型维度名称:resourceId
Instances.N.Dimensions.0.Value
resourceId
实例具体的 resourceId
输入实例的具体 resourceId,例如:postgres-123456

入参说明

查询 PostgreSQL 监控数据,入参取值如下: &Namespace=QCE/POSTGRES &Instances.N.Dimensions.0.Name=resourceId &Instances.N.Dimensions.0.Value=实例的 resourceId