Zabbix 监控 RDS PostgreSQL数据库–2 创建模板监控项

在Zabbix Server 创建监控的模板

 {$ACCESSKEY_ID}
访问RDS PostgreSQL的KeyID
{$ACCESSKEY_SECRET}
KeyID的密钥
{$DBINSTANCEID}
RDS PostgreSQL的实例ID
{$RDS_IP}
RDS PostgreSQL实例的内网连接地址，在端口监控的时候会用到

模版创建好后，创建监控项：
check.rds_postgresql[Attribute,{$DBINSTANCEID},MaxIOPS,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]

check.rds_postgresql[Attribute,{$DBINSTANCEID},MaxConnections,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]


check.rds_postgresql[Attribute,{$DBINSTANCEID},DBInstanceCPU,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]


check.rds_postgresql[Attribute,{$DBINSTANCEID},DBInstanceMemory,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}] 


check.rds_postgresql[Attribute,{$DBINSTANCEID},DBInstanceStorageType,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]


check.rds_postgresql[Attribute,{$DBINSTANCEID},DBInstanceStatus,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]


check.rds_postgresql[Attribute,{$DBINSTANCEID},DBInstanceStorage,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]


check.rds_postgresql[Attribute,{$DBINSTANCEID},EngineVersion,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]


#########*********
check.rds_postgresql[Disk,{$DBINSTANCEID},LogSize,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]
 check.rds_postgresql[Disk,{$DBINSTANCEID},DiskUsed,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]

 check.rds_postgresql[Disk,{$DBINSTANCEID},DataSize,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]

 check.rds_postgresql[Disk,{$DBINSTANCEID},BackupSize,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}] 

############*********************
check.rds_postgresql[Performance,{$DBINSTANCEID},PgSQL_Session,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]



check.rds_postgresql[Performance,{$DBINSTANCEID},PgSQL_SpaceUsage,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]




check.rds_postgresql[Performance,{$DBINSTANCEID},MemoryUsage,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]




check.rds_postgresql[Performance,{$DBINSTANCEID},DiskUsage,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]




check.rds_postgresql[Performance1,{$DBINSTANCEID},cpu_ratio,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]



check.rds_postgresql[Performance1,{$DBINSTANCEID},cpu_user_ratio,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]



check.rds_postgresql[Performance1,{$DBINSTANCEID},cpu_sys_ratio,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]


check.rds_postgresql[Performance1,{$DBINSTANCEID},active_session,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]



check.rds_postgresql[Performance1,{$DBINSTANCEID},idle_connection,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]



check.rds_postgresql[Performance1,{$DBINSTANCEID},waiting_connection,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]

check.rds_postgresql[Performance1,{$DBINSTANCEID},commits_delta,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]



check.rds_postgresql[Performance1,{$DBINSTANCEID},rollbacks_delta,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]



check.rds_postgresql[Performance1,{$DBINSTANCEID},deadlocks_delta,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]



check.rds_postgresql[Performance1,{$DBINSTANCEID},mean_tps,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]



check.rds_postgresql[Performance1,{$DBINSTANCEID},returned_delta,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]

 check.rds_postgresql[Performance1,{$DBINSTANCEID},fetched_delta,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]



check.rds_postgresql[Performance1,{$DBINSTANCEID},inserted_delta,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]



check.rds_postgresql[Performance1,{$DBINSTANCEID},updated_delta,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]



check.rds_postgresql[Performance1,{$DBINSTANCEID},deleted_delta,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]



check.rds_postgresql[Performance1,{$DBINSTANCEID},iops_read,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]


check.rds_postgresql[Performance1,{$DBINSTANCEID},iops_write,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]


check.rds_postgresql[Performance1,{$DBINSTANCEID},local_iops,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]