diff options
Diffstat (limited to 'templates/db/postgresql/template_db_postgresql.yaml')
| -rw-r--r-- | templates/db/postgresql/template_db_postgresql.yaml | 112 |
1 files changed, 111 insertions, 1 deletions
diff --git a/templates/db/postgresql/template_db_postgresql.yaml b/templates/db/postgresql/template_db_postgresql.yaml index 113b17b0e39..2526f1a5505 100644 --- a/templates/db/postgresql/template_db_postgresql.yaml +++ b/templates/db/postgresql/template_db_postgresql.yaml @@ -1,11 +1,13 @@ zabbix_export: version: '5.4' - date: '2021-05-09T00:00:00Z' + date: '2021-05-10T19:40:34Z' groups: - + uuid: 748ad4d098d447d492bb935c907f652f name: Templates/Databases templates: - + uuid: 399bd1ee587245ecac6f39beaa99886f template: PostgreSQL name: PostgreSQL groups: @@ -13,6 +15,7 @@ zabbix_export: name: Templates/Databases items: - + uuid: d17c6c15154d40d1afa5b1eafb2ed93e name: 'Bgwriter: Buffers allocated per second' type: DEPENDENT key: pgsql.bgwriter.buffers_alloc.rate @@ -37,6 +40,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: 2c3ee691d4a54fb6b566739a3a648df4 name: 'Bgwriter: Buffers written directly by a backend per second' type: DEPENDENT key: pgsql.bgwriter.buffers_backend.rate @@ -61,6 +65,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: 77e1eb202a6346ce9df0f1bb2c078688 name: "Bgwriter:\_Buffers backend fsync per second" type: DEPENDENT key: pgsql.bgwriter.buffers_backend_fsync.rate @@ -84,6 +89,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: e29d26a48d0143579bf3acc6655cd659 name: 'Bgwriter: Buffers written during checkpoints per second' type: DEPENDENT key: pgsql.bgwriter.buffers_checkpoint.rate @@ -108,6 +114,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: 5151183461a54d2bbfaad04b8cab3798 name: 'Bgwriter: Buffers written by the background writer per second' type: DEPENDENT key: pgsql.bgwriter.buffers_clean.rate @@ -132,6 +139,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: ff290c0602b9447e87240c1ecf467050 name: 'Bgwriter: Requested checkpoints per second' type: DEPENDENT key: pgsql.bgwriter.checkpoints_req.rate @@ -156,6 +164,7 @@ zabbix_export: value: PostgreSQL triggers: - + uuid: 65e7954489854ad3ad1698dead7c4c02 expression: 'last(/PostgreSQL/pgsql.bgwriter.checkpoints_req.rate) > {$PG.CHECKPOINTS_REQ.MAX.WARN}' name: 'PostgreSQL: Required checkpoints occurs too frequently (over {$PG.CHECKPOINTS_REQ.MAX.WARN})' priority: AVERAGE @@ -163,6 +172,7 @@ zabbix_export: Checkpoints are points in the sequence of transactions at which it is guaranteed that the heap and index data files have been updated with all information written before that checkpoint. At checkpoint time, all dirty data pages are flushed to disk and a special checkpoint record is written to the log file. https://www.postgresql.org/docs/current/wal-configuration.html - + uuid: a5271230be8b431cb96580180e099b98 name: 'Bgwriter: Scheduled checkpoints per second' type: DEPENDENT key: pgsql.bgwriter.checkpoints_timed.rate @@ -186,6 +196,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: 782d2368763b48ad8663aa9fb75c3326 name: 'Bgwriter: Checkpoint sync time' type: DEPENDENT key: pgsql.bgwriter.checkpoint_sync_time @@ -214,6 +225,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: b5e5f463978c46dd9401963f48ea72eb name: "Bgwriter:\_Checkpoint write time" type: DEPENDENT key: pgsql.bgwriter.checkpoint_write_time @@ -242,6 +254,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: f273c71f92bf4ac0b6ec5a0a88d1239c name: 'Bgwriter: Max written per second' type: DEPENDENT key: pgsql.bgwriter.maxwritten_clean.rate @@ -265,6 +278,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: 1fc5ba48a0974bd7bf965b5f130deded name: 'PostgreSQL: Get bgwriter' key: 'pgsql.bgwriter["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]' history: 1h @@ -277,6 +291,7 @@ zabbix_export: value: 'Zabbix raw items' triggers: - + uuid: b5d6e86c862740d5b1d0fe49ecd8a7d5 expression: 'nodata(/PostgreSQL/pgsql.bgwriter["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"],30m) = 1' name: 'PostgreSQL: Failed to get items (no data for 30m)' priority: WARNING @@ -286,6 +301,7 @@ zabbix_export: name: 'PostgreSQL: Service is down' expression: 'last(/PostgreSQL/pgsql.ping["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]) = 0' - + uuid: 70a7581fabd14e05bda762b79811187c name: 'Status: Cache hit ratio %' key: 'pgsql.cache.hit["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]' history: 7d @@ -298,10 +314,12 @@ zabbix_export: value: PostgreSQL triggers: - + uuid: 55f6c16df3cd4ae0a7f4db9060d0a7f5 expression: 'max(/PostgreSQL/pgsql.cache.hit["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"],5m) < {$PG.CACHE_HITRATIO.MIN.WARN}' name: 'PostgreSQL: Cache hit ratio too low (under {$PG.CACHE_HITRATIO.MIN.WARN} in 5m)' priority: WARNING - + uuid: 248cbe5067324b9ca435f2aced5e2a5f name: 'Status: Config hash' key: 'pgsql.config.hash["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]' delay: 15m @@ -320,10 +338,12 @@ zabbix_export: value: PostgreSQL triggers: - + uuid: b73b0e8d3efb4d58aed5edb438944701 expression: '(last(/PostgreSQL/pgsql.config.hash["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"],#1)<>last(/PostgreSQL/pgsql.config.hash["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"],#2))=1 and length(last(/PostgreSQL/pgsql.config.hash["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]))>0' name: 'PostgreSQL: Configuration has changed' priority: INFO - + uuid: c78116d3acf24e6990ed27ba8008728c name: 'Connections sum: Active' type: DEPENDENT key: pgsql.connections.sum.active @@ -342,6 +362,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: be6eb6ecbfad420b889c58d1f1550b23 name: 'Connections sum: Idle' type: DEPENDENT key: pgsql.connections.sum.idle @@ -360,6 +381,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: 6471d014722c4072ae045df4c69578e3 name: 'Connections sum: Idle in transaction' type: DEPENDENT key: pgsql.connections.sum.idle_in_transaction @@ -378,6 +400,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: 197cc14f55db485b891614c7b7ee2a51 name: 'Connections sum: Prepared' type: DEPENDENT key: pgsql.connections.sum.prepared @@ -398,6 +421,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: 24d23377c7cd4cc5b63f98a261c2501c name: 'Connections sum: Total' type: DEPENDENT key: pgsql.connections.sum.total @@ -416,6 +440,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: 488050d9aa8e4c2ea5b3e991ec5ddacc name: 'Connections sum: Total %' type: DEPENDENT key: pgsql.connections.sum.total_pct @@ -436,10 +461,12 @@ zabbix_export: value: PostgreSQL triggers: - + uuid: 3555fccf464040e98b86281a129f1822 expression: 'min(/PostgreSQL/pgsql.connections.sum.total_pct,5m) > {$PG.CONN_TOTAL_PCT.MAX.WARN}' name: 'PostgreSQL: Total number of connections is too high (over {$PG.CONN_TOTAL_PCT.MAX.WARN} in 5m)' priority: AVERAGE - + uuid: fadd1333189c4ed29db57cf2acd158d0 name: 'Connections sum: Waiting' type: DEPENDENT key: pgsql.connections.sum.waiting @@ -460,6 +487,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: b0da0c4856a645ca8ef03405d2d8d4a5 name: 'PostgreSQL: Get connections sum' key: 'pgsql.connections.sum["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]' history: 1h @@ -473,6 +501,7 @@ zabbix_export: tag: Application value: 'Zabbix raw items' - + uuid: b44f263fb33e461e8c3d700fb7688c7b name: 'PostgreSQL: Get dbstat' key: 'pgsql.dbstat["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]' history: 1h @@ -486,6 +515,7 @@ zabbix_export: tag: Application value: 'Zabbix raw items' - + uuid: 7cee21f6225340ef80e9cdef7ce20b10 name: 'PostgreSQL: Get locks' key: 'pgsql.locks["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]' history: 1h @@ -499,6 +529,7 @@ zabbix_export: tag: Application value: 'Zabbix raw items' - + uuid: f42bd73b3af6451b8a3a6113dcc1b675 name: 'Status: Ping time' key: 'pgsql.ping.time["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]' history: 7d @@ -520,6 +551,7 @@ zabbix_export: value: PostgreSQL triggers: - + uuid: 988dd5f8607f4e9481b15bb4c9f9b6e9 expression: 'min(/PostgreSQL/pgsql.ping.time["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"],5m) > {$PG.PING_TIME.MAX.WARN}' name: 'PostgreSQL: Response too long (over {$PG.PING_TIME.MAX.WARN})' priority: AVERAGE @@ -528,6 +560,7 @@ zabbix_export: name: 'PostgreSQL: Service is down' expression: 'last(/PostgreSQL/pgsql.ping["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]) = 0' - + uuid: f5bd615243b344cb88dac1e83436cc85 name: 'Status: Ping' key: 'pgsql.ping["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]' history: 7d @@ -548,10 +581,12 @@ zabbix_export: value: PostgreSQL triggers: - + uuid: 6d9c2b5353ce4f6baeeb0f254fb7d1e2 expression: 'last(/PostgreSQL/pgsql.ping["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]) = 0' name: 'PostgreSQL: Service is down' priority: HIGH - + uuid: 47bf580e1e4e48cf9c0e94fcf90288ac name: 'PostgreSQL: Get queries' key: 'pgsql.queries["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}","{$PG.QUERY_ETIME.MAX.WARN}"]' history: 1h @@ -563,6 +598,7 @@ zabbix_export: tag: Application value: 'Zabbix raw items' - + uuid: d8a509bd011a4ecda5d439295e257e9d name: 'Replication: standby count' key: 'pgsql.replication.count["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]' history: 7d @@ -572,6 +608,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: 21f8bea1141249c7a4dfafad5bc3ef41 name: 'Replication: lag in seconds' key: 'pgsql.replication.lag.sec["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]' history: 7d @@ -583,10 +620,12 @@ zabbix_export: value: PostgreSQL triggers: - + uuid: 155d4e8915044613838d2f85c512d084 expression: 'min(/PostgreSQL/pgsql.replication.lag.sec["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"],5m) > {$PG.REPL_LAG.MAX.WARN}' name: 'PostgreSQL: Streaming lag with {#MASTER} is too high (over {$PG.REPL_LAG.MAX.WARN} in 5m)' priority: AVERAGE - + uuid: 09f696124fca4c5b844bf66c9c912b87 name: 'Replication: recovery role' key: 'pgsql.replication.recovery_role["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]' history: 7d @@ -598,6 +637,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: d449017462704508a4aad51a6b45fb30 name: 'Replication: status' key: 'pgsql.replication.status["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]' history: 7d @@ -610,10 +650,12 @@ zabbix_export: value: PostgreSQL triggers: - + uuid: c1e96b0820fb4460bd121b7893310bb0 expression: 'max(/PostgreSQL/pgsql.replication.status["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"],5m)=0' name: 'PostgreSQL: Replication is down' priority: AVERAGE - + uuid: 4883717865c84c19b48d46f009317de2 name: 'Transactions: Max active transaction time' type: DEPENDENT key: pgsql.transactions.active @@ -634,6 +676,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: 4c89121d71a14c15b6169417ea69d0a3 name: 'Transactions: Max idle transaction time' type: DEPENDENT key: pgsql.transactions.idle @@ -654,6 +697,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: 0ee43ddd9da246d19097107b45e4c8e8 name: 'Transactions: Max prepared transaction time' type: DEPENDENT key: pgsql.transactions.prepared @@ -674,6 +718,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: da341b2011714a1f994ecbe96bd52155 name: 'Transactions: Max waiting transaction time' type: DEPENDENT key: pgsql.transactions.waiting @@ -694,6 +739,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: ff26a1c256bd40978f49a7a025538aa1 name: 'PostgreSQL: Get transactions' key: 'pgsql.transactions["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]' history: 1h @@ -705,6 +751,7 @@ zabbix_export: tag: Application value: 'Zabbix raw items' - + uuid: 6418a2f286e64ecabf2295fca063f8af name: 'Status: Uptime' key: 'pgsql.uptime["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]' history: 7d @@ -715,11 +762,13 @@ zabbix_export: value: PostgreSQL triggers: - + uuid: 85565aba402740868a16c0e4639a98fc expression: 'last(/PostgreSQL/pgsql.uptime["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]) < 10m' name: 'PostgreSQL: Service has been restarted (uptime < 10m)' priority: INFO description: 'PostgreSQL uptime is less than 10 minutes' - + uuid: 321525ebcea44396922e96deec2e8ad1 name: 'Status: Version' key: 'pgsql.version["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]' delay: 15m @@ -738,10 +787,12 @@ zabbix_export: value: PostgreSQL triggers: - + uuid: 14ffea66f065426f86f04575c9c59729 expression: '(last(/PostgreSQL/pgsql.version["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"],#1)<>last(/PostgreSQL/pgsql.version["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"],#2))=1 and length(last(/PostgreSQL/pgsql.version["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]))>0' name: 'PostgreSQL: Version has changed (new version value received: {ITEM.VALUE})' priority: INFO - + uuid: 5385ec7d39514039a641d18cba335ddc name: 'WAL: Segments count' type: DEPENDENT key: pgsql.wal.count @@ -760,6 +811,7 @@ zabbix_export: tag: Application value: PostgreSQL - + uuid: 7cd6c524ecab41f9a22489866d503361 name: 'PostgreSQL: Get WAL' key: 'pgsql.wal.stat["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]' delay: 5m @@ -772,6 +824,7 @@ zabbix_export: tag: Application value: 'Zabbix raw items' - + uuid: 5cc9c67621cc46e0a42b1eb79bda83b3 name: 'WAL: Bytes written' type: DEPENDENT key: pgsql.wal.write @@ -796,6 +849,7 @@ zabbix_export: value: PostgreSQL discovery_rules: - + uuid: 5c4c658507394f5bb362e601f7c59d63 name: 'Database discovery' key: 'pgsql.discovery.db["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]' delay: 1h @@ -807,6 +861,7 @@ zabbix_export: formulaid: A item_prototypes: - + uuid: 69575e9785184ef5be2502e3cc282220 name: 'DB {#DBNAME}: Database size' key: 'pgsql.db.size["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}","{#DBNAME}"]' delay: 15m @@ -818,6 +873,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: 615e6567a85e421bb06ab8cac0eaba69 name: 'DB {#DBNAME}: Blocks hit per second' type: DEPENDENT key: 'pgsql.dbstat.blks_hit.rate["{#DBNAME}"]' @@ -841,6 +897,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: 9136517d08b447869e5b8f5fd684c3b9 name: 'DB {#DBNAME}: Disk blocks read per second' type: DEPENDENT key: 'pgsql.dbstat.blks_read.rate["{#DBNAME}"]' @@ -864,6 +921,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: a76f6d28995441ff9fe28bbc09445e64 name: 'DB {#DBNAME}: Detected conflicts per second' type: DEPENDENT key: 'pgsql.dbstat.conflicts.rate["{#DBNAME}"]' @@ -888,6 +946,7 @@ zabbix_export: value: 'PostgreSQL: DB {#DBNAME}' trigger_prototypes: - + uuid: d336bc7d7d974615b54ff743413e7dc5 expression: 'min(/PostgreSQL/pgsql.dbstat.conflicts.rate["{#DBNAME}"],5m) > {$PG.CONFLICTS.MAX.WARN:"{#DBNAME}"}' name: 'Database {#DBNAME}: Too many recovery conflicts (over {$PG.CONFLICTS.MAX.WARN:"{#DBNAME}"} in 5m)' priority: AVERAGE @@ -895,6 +954,7 @@ zabbix_export: The primary and standby servers are in many ways loosely connected. Actions on the primary will have an effect on the standby. As a result, there is potential for negative interactions or conflicts between them. https://www.postgresql.org/docs/current/hot-standby.html#HOT-STANDBY-CONFLICT - + uuid: b874cc2dd80643208c2479ad25fae0ac name: 'DB {#DBNAME}: Detected deadlocks per second' type: DEPENDENT key: 'pgsql.dbstat.deadlocks.rate["{#DBNAME}"]' @@ -919,10 +979,12 @@ zabbix_export: value: 'PostgreSQL: DB {#DBNAME}' trigger_prototypes: - + uuid: 00fd68a95388437da983cf5aeedaf1a9 expression: 'min(/PostgreSQL/pgsql.dbstat.deadlocks.rate["{#DBNAME}"],5m) > {$PG.DEADLOCKS.MAX.WARN:"{#DBNAME}"}' name: 'Database {#DBNAME}: Deadlock occurred (over {$PG.DEADLOCKS.MAX.WARN:"{#DBNAME}"} in 5m)' priority: HIGH - + uuid: d235ead54c8b41f9a91398c75383e5d7 name: 'DB {#DBNAME}: Temp_bytes written per second' type: DEPENDENT key: 'pgsql.dbstat.temp_bytes.rate["{#DBNAME}"]' @@ -946,6 +1008,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: af4e35eee1764d3f97d9c1218867f885 name: 'DB {#DBNAME}: Temp_files created per second' type: DEPENDENT key: 'pgsql.dbstat.temp_files.rate["{#DBNAME}"]' @@ -968,6 +1031,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: 35c6f93aefe4439bbc36f2f358440b16 name: 'DB {#DBNAME}: Tuples deleted per second' type: DEPENDENT key: 'pgsql.dbstat.tup_deleted.rate["{#DBNAME}"]' @@ -991,6 +1055,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: 92f33d96f8a348088cdba593c0e66929 name: 'DB {#DBNAME}: Tuples fetched per second' type: DEPENDENT key: 'pgsql.dbstat.tup_fetched.rate["{#DBNAME}"]' @@ -1014,6 +1079,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: 8c03c87a44fe43928c32087ca7561e88 name: 'DB {#DBNAME}: Tuples inserted per second' type: DEPENDENT key: 'pgsql.dbstat.tup_inserted.rate["{#DBNAME}"]' @@ -1037,6 +1103,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: f6d378f4e38e455fa5a12467fe977657 name: 'DB {#DBNAME}: Tuples returned per second' type: DEPENDENT key: 'pgsql.dbstat.tup_returned.rate["{#DBNAME}"]' @@ -1060,6 +1127,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: 4c8de8c1064d43ffa18c4f37fead37f7 name: 'DB {#DBNAME}: Tuples updated per second' type: DEPENDENT key: 'pgsql.dbstat.tup_updated.rate["{#DBNAME}"]' @@ -1083,6 +1151,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: 81c33f5b3c31475fa5f28f4ad149a328 name: 'DB {#DBNAME}: Commits per second' type: DEPENDENT key: 'pgsql.dbstat.xact_commit.rate["{#DBNAME}"]' @@ -1106,6 +1175,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: 8e5080186d034323be21473099b0b0ce name: 'DB {#DBNAME}: Rollbacks per second' type: DEPENDENT key: 'pgsql.dbstat.xact_rollback.rate["{#DBNAME}"]' @@ -1129,6 +1199,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: df9dd9bac2a54f1085b29fb22b394a1f name: 'DB {#DBNAME}: Frozen XID before avtovacuum %' type: DEPENDENT key: 'pgsql.frozenxid.prc_before_av["{#DBNAME}"]' @@ -1151,6 +1222,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: 44ddd66ea37449cb8fab6979b98dfd3c name: 'DB {#DBNAME}: Frozen XID before stop %' type: DEPENDENT key: 'pgsql.frozenxid.prc_before_stop["{#DBNAME}"]' @@ -1174,6 +1246,7 @@ zabbix_export: value: 'PostgreSQL: DB {#DBNAME}' trigger_prototypes: - + uuid: 709df9c1e29a4ff68a3de9423ff7ae58 expression: 'last(/PostgreSQL/pgsql.frozenxid.prc_before_stop["{#DBNAME}"])<{$PG.FROZENXID_PCT_STOP.MIN.HIGH:"{#DBNAME}"}' name: 'Database {#DBNAME}: VACUUM FREEZE is required to prevent wraparound (frozen XID less then {$PG.FROZENXID_PCT_STOP.MIN.HIGH:"{#DBNAME}"} %)' priority: AVERAGE @@ -1181,6 +1254,7 @@ zabbix_export: Preventing Transaction ID Wraparound Failures https://www.postgresql.org/docs/current/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND - + uuid: ddf6d0b7b5fe4cbbb540687051b8e5f5 name: 'DB {#DBNAME}: Get frozen XID' key: 'pgsql.frozenxid["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{#DBNAME}"]' history: 1h @@ -1191,6 +1265,7 @@ zabbix_export: tag: Application value: 'Zabbix raw items' - + uuid: 3d0acf4b45fc4a72bb2a214222f93f2a name: 'DB {#DBNAME}: Locks total' type: DEPENDENT key: 'pgsql.locks.total["{#DBNAME}"]' @@ -1210,10 +1285,12 @@ zabbix_export: value: 'PostgreSQL: DB {#DBNAME}' trigger_prototypes: - + uuid: 7fb8b20d6565439982761b7d7a74d9e3 expression: 'min(/PostgreSQL/pgsql.locks.total["{#DBNAME}"],5m)>{$PG.LOCKS.MAX.WARN:"{#DBNAME}"}' name: 'Database {#DBNAME}: Number of locks is too high (over {$PG.LOCKS.MAX.WARN:"{#DBNAME}"} in 5m)' priority: WARNING - + uuid: 939ab05c71ed4be9979662203ebba980 name: 'DB {#DBNAME}: Queries slow maintenance count' type: DEPENDENT key: 'pgsql.queries.mro.slow_count["{#DBNAME}"]' @@ -1232,6 +1309,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: bbc8f9bf86394cf28e0c2db44ee4711d name: 'DB {#DBNAME}: Queries max maintenance time' type: DEPENDENT key: 'pgsql.queries.mro.time_max["{#DBNAME}"]' @@ -1251,6 +1329,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: f1427228bfa14ad3b7bb9d63bcfaec59 name: 'DB {#DBNAME}: Queries sum maintenance time' type: DEPENDENT key: 'pgsql.queries.mro.time_sum["{#DBNAME}"]' @@ -1270,6 +1349,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: 5d937f46f4684f1e8253ec62e0f75379 name: 'DB {#DBNAME}: Queries slow query count' type: DEPENDENT key: 'pgsql.queries.query.slow_count["{#DBNAME}"]' @@ -1289,10 +1369,12 @@ zabbix_export: value: 'PostgreSQL: DB {#DBNAME}' trigger_prototypes: - + uuid: 9cdceacd8c634d45a3b50aa708ef6bf0 expression: 'min(/PostgreSQL/pgsql.queries.query.slow_count["{#DBNAME}"],5m)>{$PG.SLOW_QUERIES.MAX.WARN:"{#DBNAME}"}' name: 'Database {#DBNAME}: Too many slow queries (over {$PG.SLOW_QUERIES.MAX.WARN:"{#DBNAME}"} in 5m)' priority: WARNING - + uuid: 044cc16d0a2f46b28d88eff86c33b30b name: 'DB {#DBNAME}: Queries max query time' type: DEPENDENT key: 'pgsql.queries.query.time_max["{#DBNAME}"]' @@ -1312,6 +1394,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: c6232400b39c4564a30a403859ffb4ee name: 'DB {#DBNAME}: Queries sum query time' type: DEPENDENT key: 'pgsql.queries.query.time_sum["{#DBNAME}"]' @@ -1331,6 +1414,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: f7099043ea6345f0a5531f70f9573a3e name: 'DB {#DBNAME}: Queries slow transaction count' type: DEPENDENT key: 'pgsql.queries.tx.slow_count["{#DBNAME}"]' @@ -1349,6 +1433,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: c6800ca30a564766ba745e875cb4e929 name: 'DB {#DBNAME}: Queries max transaction time' type: DEPENDENT key: 'pgsql.queries.tx.time_max["{#DBNAME}"]' @@ -1368,6 +1453,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: 0eda974576794768ac9ddc592ff27e19 name: 'DB {#DBNAME}: Queries sum transaction time' type: DEPENDENT key: 'pgsql.queries.tx.time_sum["{#DBNAME}"]' @@ -1387,6 +1473,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: cafcc00cce824c33a321da0e9ecc7f6e name: 'DB {#DBNAME}: Index scans per second' type: DEPENDENT key: 'pgsql.scans.idx.rate["{#DBNAME}"]' @@ -1409,6 +1496,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: f07396ca9d224e1b819f22efe6c4259d name: 'DB {#DBNAME}: Sequential scans per second' type: DEPENDENT key: 'pgsql.scans.seq.rate["{#DBNAME}"]' @@ -1432,6 +1520,7 @@ zabbix_export: tag: Application value: 'PostgreSQL: DB {#DBNAME}' - + uuid: 4bf92e4b0fed4d32b808b299d9e1fb0c name: 'DB {#DBNAME}: Get scans' key: 'pgsql.scans["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{#DBNAME}"]' history: 1h @@ -1444,6 +1533,7 @@ zabbix_export: value: 'Zabbix raw items' graph_prototypes: - + uuid: 3f8124b817f2437096c620d62ec2e055 name: 'DB {#DBNAME}: Block hit/read' ymin_type_1: FIXED graph_items: @@ -1459,6 +1549,7 @@ zabbix_export: host: PostgreSQL key: 'pgsql.dbstat.blks_read.rate["{#DBNAME}"]' - + uuid: 6bd0a0d65b8d43ad946b145cf8a8b533 name: 'DB {#DBNAME}: Database size' ymin_type_1: FIXED graph_items: @@ -1468,6 +1559,7 @@ zabbix_export: host: PostgreSQL key: 'pgsql.db.size["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}","{#DBNAME}"]' - + uuid: 41e765d906324595a396d8985b204ff5 name: 'DB {#DBNAME}: Events' ymin_type_1: FIXED graph_items: @@ -1496,6 +1588,7 @@ zabbix_export: host: PostgreSQL key: 'pgsql.dbstat.xact_rollback.rate["{#DBNAME}"]' - + uuid: 2b260fdf7623476095429434b5c79041 name: 'DB {#DBNAME}: Locks' ymin_type_1: FIXED graph_items: @@ -1505,6 +1598,7 @@ zabbix_export: host: PostgreSQL key: 'pgsql.locks.total["{#DBNAME}"]' - + uuid: 8a60a92b41b146f49145b86bab559b2e name: 'DB {#DBNAME}: Queries' ymin_type_1: FIXED graph_items: @@ -1550,6 +1644,7 @@ zabbix_export: host: PostgreSQL key: 'pgsql.queries.tx.time_sum["{#DBNAME}"]' - + uuid: 93518b06f71e46ada3dabefa1726b867 name: 'DB {#DBNAME}: Slow queries' ymin_type_1: FIXED graph_items: @@ -1571,6 +1666,7 @@ zabbix_export: host: PostgreSQL key: 'pgsql.queries.tx.slow_count["{#DBNAME}"]' - + uuid: 779b872280ad46c7a6cdf95c2df7c646 name: 'DB {#DBNAME}: Temp files' graph_items: - @@ -1587,6 +1683,7 @@ zabbix_export: host: PostgreSQL key: 'pgsql.dbstat.temp_files.rate["{#DBNAME}"]' - + uuid: f10be22e3bac4d66936c34ec99446c64 name: 'DB {#DBNAME}: Tuples' ymin_type_1: FIXED graph_items: @@ -1685,6 +1782,7 @@ zabbix_export: value: zbx_monitor dashboards: - + uuid: d95f29826778497a9ed265e0c335fd0f name: 'PostgreSQL databases' pages: - @@ -1884,6 +1982,7 @@ zabbix_export: name: 'DB {#DBNAME}: Slow queries' host: PostgreSQL - + uuid: f2ceabf59fd64ca9828ea55e9b9668bd name: 'PostgreSQL stat' pages: - @@ -2020,6 +2119,7 @@ zabbix_export: host: PostgreSQL valuemaps: - + uuid: 2e376ee568d04e7bbe98cbae4181f313 name: 'PostgreSQL recovery role' mappings: - @@ -2029,6 +2129,7 @@ zabbix_export: value: '1' newvalue: Standby - + uuid: 7f553f18ef6544ceaa4b50c4ebf0e583 name: 'PostgreSQL replication status' mappings: - @@ -2041,6 +2142,7 @@ zabbix_export: value: '2' newvalue: Master - + uuid: 372bc939f3924aafa13c4821b83a9276 name: 'Service state' mappings: - @@ -2051,6 +2153,7 @@ zabbix_export: newvalue: Up graphs: - + uuid: 6b4b92c62cb94e10b11f218ed35f6211 name: 'PostgreSQL bgwriter' ymin_type_1: FIXED graph_items: @@ -2094,6 +2197,7 @@ zabbix_export: host: PostgreSQL key: pgsql.bgwriter.buffers_backend_fsync.rate - + uuid: 4a105d193df64be7898ac19a2f07faa4 name: 'PostgreSQL checkpoints' ymin_type_1: FIXED graph_items: @@ -2123,6 +2227,7 @@ zabbix_export: host: PostgreSQL key: pgsql.bgwriter.checkpoint_write_time - + uuid: 8d41d719832049a5a1fcd6f4da67fb6a name: 'PostgreSQL connections' ymin_type_1: FIXED graph_items: @@ -2175,6 +2280,7 @@ zabbix_export: host: PostgreSQL key: pgsql.connections.sum.waiting - + uuid: 1e9a55ee61824779a9f46f42ec21abef name: 'PostgreSQL ping' ymin_type_1: FIXED graph_items: @@ -2192,6 +2298,7 @@ zabbix_export: host: PostgreSQL key: 'pgsql.ping.time["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]' - + uuid: d8cf31fc39584a63b9384d9c3ebf40ee name: 'PostgreSQL replication lag' ymin_type_1: FIXED graph_items: @@ -2201,6 +2308,7 @@ zabbix_export: host: PostgreSQL key: 'pgsql.replication.lag.sec["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]' - + uuid: 10d1de74e9d848399ca038055e5cc8ce name: 'PostgreSQL transactions' ymin_type_1: FIXED graph_items: @@ -2232,6 +2340,7 @@ zabbix_export: host: PostgreSQL key: pgsql.transactions.waiting - + uuid: 45fe7967596741129b4f2462922636bf name: 'PostgreSQL uptime' show_triggers: 'NO' ymin_type_1: FIXED @@ -2249,6 +2358,7 @@ zabbix_export: host: PostgreSQL key: 'pgsql.cache.hit["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.DB}"]' - + uuid: 93ca2dc7a3ff4a458c45e2a56390ce72 name: 'PostgreSQL WAL' ymin_type_1: FIXED graph_items: |