Maximum number of coprocessor request errors

Maximum number of pending commands

Maximum number of tasks currently running by the worker or pending

The port of TiKV server metrics web endpoint

Maximum number of failure messages

TiKV server URL

Discovery coprocessor metrics.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_coprocessor_request_duration_seconds_count")]

- JAVASCRIPT: The text is too long. Please see the template.

- DISCARDUNCHANGEDHEARTBEAT: 1h

Discovery QPS metrics.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_grpc_msg_duration_seconds_count")]

- JAVASCRIPT: The text is too long. Please see the template.

- DISCARDUNCHANGEDHEARTBEAT: 1h

Discovery scheduler metrics.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_scheduler_stage_total")]

- JAVASCRIPT: The text is too long. Please see the template.

- DISCARDUNCHANGEDHEARTBEAT: 1h

Discovery server errors metrics.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_server_report_failure_msg_total")]

- JAVASCRIPT: The text is too long. Please see the template.

- DISCARDUNCHANGEDHEARTBEAT: 1h

Overrides:

Too many unreachable messages trigger
- {#TYPE} MATCHESREGEX unreachable
- TRIGGERPROTOTYPE LIKE Too many failure messages - DISCOVER

The storage size of TiKV instance.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_engine_size_bytes")].value.sum()

The available capacity of TiKV instance.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_store_size_bytes" && @.labels.type == "available")].value.first()

The capacity size of TiKV instance.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_store_size_bytes" && @.labels.type == "capacity")].value.first()

The total bytes of read in TiKV instance.

Preprocessing:

- JSONPATH: `$[?(@.name == "tikvengineflowbytes" && @.labels.db == "kv" && @.labels.type =~ "bytesread

The total bytes of write in TiKV instance.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_engine_flow_bytes" && @.labels.db == "kv" && @.labels.type == "wal_file_bytes")].value.first()

Total number of commands received per second.

- CHANGEPER_SECOND

The CPU usage ratio on TiKV instance.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_thread_cpu_seconds_total")].value.sum()

- CHANGEPERSECOND

- MULTIPLIER: 100

Resident memory size in bytes.

Preprocessing:

- JSONPATH: $[?(@.name == "process_resident_memory_bytes")].value.first()

The number of regions collected in TiKV instance.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_raftstore_region_count" && @.labels.type == "region" )].value.first()

The number of leaders in TiKV instance.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_raftstore_region_count" && @.labels.type == "leader" )].value.first()

The total QPS in TiKV instance.

- CHANGEPER_SECOND

The total number of gRPC message handling failure per second.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_grpc_msg_fail_total")].value.sum()

⛔️ONFAIL: DISCARD_VALUE ->

- CHANGEPER_SECOND

Total number of push down request error per second.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_coprocessor_request_error")].value.sum()

⛔️ONFAIL: DISCARD_VALUE ->

- CHANGEPER_SECOND

Total number of coprocessor requests per second.

- CHANGEPER_SECOND

Total number of scan keys observed per request per second.

- CHANGEPER_SECOND

Total number of RocksDB internal operations from PerfContext per second.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_coprocessor_rocksdb_perf")].value.sum()

- CHANGEPERSECOND

The total size of coprocessor response per second.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_coprocessor_response_bytes")].value.first()

- CHANGEPERSECOND

The total number of pending commands. The scheduler receives commands from clients, executes them against the MVCC layer storage engine.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_scheduler_contex_total")].value.first()

The total count of too busy schedulers per second.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_scheduler_too_busy_total")].value.sum()

⛔️ONFAIL: DISCARD_VALUE ->

- CHANGEPER_SECOND

Total number of commands per second.

⛔️ONFAIL: CUSTOM_VALUE -> 0

- CHANGEPERSECOND

Total count of low priority commands per second.

- CHANGEPER_SECOND

Total count of normal priority commands per second.

- CHANGEPER_SECOND

Total count of high priority commands per second.

- CHANGEPER_SECOND

The number of tasks currently running by the worker or pending.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_worker_pending_task_total")].value.first()

The total amount of raftstore snapshot traffic.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_raftstore_snapshot_traffic_total" && @.labels.type == "sending")].value.first()

The total amount of raftstore snapshot traffic.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_raftstore_snapshot_traffic_total" && @.labels.type == "receiving")].value.first()

The total amount of raftstore snapshot traffic.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_raftstore_snapshot_traffic_total" && @.labels.type == "applying")].value.first()

The runtime of each TiKV instance.

Preprocessing:

- JSONPATH: $[?(@.name=="process_start_time_seconds")].value.first()

- JAVASCRIPT: //use boottime to calculate uptime return (Math.floor(Date.now()/1000)-Number(value));

Total number of reporting failure messages per second.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_server_report_failure_msg_total")].value.sum()

⛔️ONFAIL: DISCARD_VALUE ->

- CHANGEPER_SECOND

The QPS per command in TiKV instance.

⛔️ONFAIL: CUSTOM_VALUE ->

Total number of push down request error per second.

⛔️ONFAIL: DISCARD_VALUE ->

- CHANGEPERSECOND

Total number of coprocessor requests per second.

Preprocessing:

- JSONPATH: $[?(@.name == "tikv_coprocessor_request_duration_seconds_count" && @.labels.req == "{#REQ_TYPE}")].value.first()

- CHANGEPERSECOND

Total number of scan keys observed per request per second.

- CHANGEPER_SECOND

Total number of RocksDB internal operations from PerfContext per second.

- CHANGEPER_SECOND

Total number of commands on each stage per second.

⛔️ONFAIL: CUSTOM_VALUE -> 0

- CHANGEPERSECOND

Total number of reporting failure messages. The metric has two labels: type and storeid. type represents the failure type, and storeid represents the destination peer store id.

- CHANGEPER_SECOND

Get TiKV instance metrics.

- CHECKNOTSUPPORTED

⛔️ONFAIL: DISCARD_VALUE ->

- PROMETHEUSTOJSON

-

-

-

Uptime is less than 10 minutes.

Manual close: YES

Indicates that the remote TiKV cannot be connected.

Maximum number of DDL tasks that are waiting

Maximum number of GC-related operations failures

Maximum heap memory used

Minimum number of keep alive operations

Maximum percentage of used file descriptors

The port of TiDB server metrics web endpoint

Maximum number of region related errors

Maximum number of schema lease errors

Maximum number of load schema errors

Maximum number of times that the operating system rewinds every second

TiDB server URL

Discovery GC action results metrics.

Preprocessing:

- JSONPATH: $[?(@.name=="tidb_tikvclient_gc_action_result")]

- JAVASCRIPT: The text is too long. Please see the template.

- DISCARDUNCHANGEDHEARTBEAT: 1h

Overrides:

Failed GC-related operations trigger
- {#TYPE} MATCHESREGEX failed
- TRIGGERPROTOTYPE LIKE Too many failed GC-related operations - DISCOVER

Discovery KV backoff specific metrics.

- DISCARDUNCHANGED_HEARTBEAT: 1h

Discovery KV specific metrics.

- DISCARDUNCHANGED_HEARTBEAT: 1h

Discovery lock resolves specific metrics.

- DISCARDUNCHANGED_HEARTBEAT: 1h

Discovery QPS specific metrics.

Preprocessing:

- JSONPATH: $[?(@.name=="tidb_server_query_total")]

- JAVASCRIPT: The text is too long. Please see the template.

- DISCARDUNCHANGEDHEARTBEAT: 1h

Discovery statement specific metrics.

Preprocessing:

- JSONPATH: $[?(@.name=="tidb_executor_statement_total")]

- JAVASCRIPT: The text is too long. Please see the template.

- DISCARDUNCHANGEDHEARTBEAT: 1h

Status of PD instance.

Preprocessing:

- JSONPATH: $.status

⛔️ONFAIL: CUSTOM_VALUE -> 1

- DISCARDUNCHANGED_HEARTBEAT: 1h

The number of queries on TiDB instance per second with failure of command execution results.

- CHANGEPER_SECOND

The number of queries on TiDB instance per second with success of command execution results.

- CHANGEPER_SECOND

The number of queries per second on TiDB instance.

- CHANGEPER_SECOND

The total number of SQL statements executed per second.

- CHANGEPER_SECOND

The number of error occurred when executing SQL statements per second (such as syntax errors and primary key conflicts).

⛔️ONFAIL: DISCARD_VALUE ->

- CHANGEPERSECOND

The number of executed KV commands per second.

- CHANGEPER_SECOND

The number of TSO commands that TiDB obtains from PD per second.

Preprocessing:

- JSONPATH: $[?(@.name=="pd_client_cmd_handle_cmds_duration_seconds_count" && @.labels.type == "tso")].value.first()

- CHANGEPERSECOND

The number of TSO requests that TiDB obtains from PD per second.

Preprocessing:

- JSONPATH: $[?(@.name=="pd_client_request_handle_requests_duration_seconds_count" && @.labels.type == "tso")].value.first()

- CHANGEPERSECOND

The number of region related errors returned by TiKV per second.

Preprocessing:

- JSONPATH: $[?(@.name=="tidb_tikvclient_region_err_total")].value.sum()

- CHANGEPERSECOND

The number of DDL tasks that are waiting.

- CHANGEPER_SECOND

The number of TiDB operations that resolve locks per second. When TiDB's read or write request encounters a lock, it tries to resolve the lock.

Preprocessing:

- JSONPATH: $[?(@.name=="tidb_ddl_waiting_jobs")].value.sum()

The statistics of the schemas that TiDB obtains from TiKV per second.

Preprocessing:

- JSONPATH: $[?(@.name=="tidb_domain_load_schema_total")].value.sum()

- CHANGEPERSECOND

The total number of failures to reload the latest schema information in TiDB per second.

Preprocessing:

- JSONPATH: $[?(@.name=="tidb_domain_load_schema_total && @.labels.type == "failed"")].value.first()

⛔️ONFAIL: DISCARD_VALUE ->

- CHANGEPER_SECOND

The number of schema lease errors per second.

"outdate" errors means that the schema cannot be updated, which is a more serious error and triggers an alert.

⛔️ONFAIL: DISCARD_VALUE ->

- CHANGEPERSECOND

The number of schema lease errors per second.

"change" means that the schema has changed

⛔️ONFAIL: DISCARD_VALUE ->

- CHANGEPERSECOND

The number of errors returned by TiKV.

⛔️ONFAIL: DISCARD_VALUE ->

- CHANGEPERSECOND

The number of times that the metrics are refreshed on TiDB instance per minute.

Preprocessing:

- JSONPATH: $[?(@.name=="tidb_monitor_keep_alive_total")].value.first()

⛔️ONFAIL: DISCARD_VALUE ->

- SIMPLECHANGE

The connection number of current TiDB instance.

Preprocessing:

- JSONPATH: $[?(@.name=="tidb_server_connections")].value.first()

Number of heap bytes that are in use.

Preprocessing:

- JSONPATH: $[?(@.name=="go_memstats_heap_inuse_bytes")].value.first()

Resident memory size in bytes.

Preprocessing:

- JSONPATH: $[?(@.name=="process_resident_memory_bytes")].value.first()

The number of Goroutines on TiDB instance.

Preprocessing:

- JSONPATH: $[?(@.name=="go_goroutines")].value.first()

Number of open file descriptors.

Preprocessing:

- JSONPATH: $[?(@.name=="process_open_fds")].value.first()

Maximum number of open file descriptors.

Preprocessing:

- JSONPATH: $[?(@.name=="process_max_fds")].value.first()

Total user and system CPU usage ratio.

Preprocessing:

- JSONPATH: $[?(@.name=="process_cpu_seconds_total")].value.first()

- CHANGEPERSECOND

- MULTIPLIER: 100

The runtime of each TiDB instance.

Preprocessing:

- JSONPATH: $[?(@.name=="process_start_time_seconds")].value.first()

- JAVASCRIPT: //use boottime to calculate uptime return (Math.floor(Date.now()/1000)-Number(value));

Version of the TiDB instance.

Preprocessing:

- JSONPATH: $.version

- DISCARDUNCHANGEDHEARTBEAT: 3h

The number of times that the operating system rewinds every second.

- CHANGEPER_SECOND

The number of critical errors occurred in TiDB per second.

Preprocessing:

- JSONPATH: $[?(@.name=="tidb_server_critical_error_total")].value.first()

- CHANGEPERSECOND

The number of panics occurred in TiDB per second.

⛔️ONFAIL: DISCARD_VALUE ->

- CHANGEPERSECOND

The number of queries on TiDB instance per second with success of command execution results.

- CHANGEPER_SECOND

The number of queries on TiDB instance per second with failure of command execution results.

- CHANGEPER_SECOND

The number of SQL statements executed per second.

Preprocessing:

- JSONPATH: $[?(@.name=="tidb_executor_statement_total" && @.labels.type == "{#TYPE}")].value.first()

- CHANGEPERSECOND

The number of executed KV commands per second.

- CHANGEPER_SECOND

The number of TiDB operations that resolve locks per second. When TiDB's read or write request encounters a lock, it tries to resolve the lock.

- CHANGEPER_SECOND

The number of TiDB operations that resolve locks per second. When TiDB's read or write request encounters a lock, it tries to resolve the lock.

- CHANGEPER_SECOND

The number of results of GC-related operations per second.

Preprocessing:

- JSONPATH: $[?(@.name=="tidb_tikvclient_gc_action_result" && @.labels.type == "{#TYPE}")].value.first()

- CHANGEPERSECOND

Get TiDB instance metrics.

- CHECKNOTSUPPORTED

⛔️ONFAIL: DISCARD_VALUE ->

- PROMETHEUSTOJSON

Get TiDB instance status info.

- CHECKNOTSUPPORTED

⛔️ONFAIL: CUSTOM_VALUE -> {"status": "0"}

-

-

-

-

The latest schema information is not reloaded in TiDB within one lease.

Indicates whether the TiDB process still exists. If the number of times for tidbmonitorkeepalivetotal increases less than 10 per minute, the TiDB process might already exit and an alert is triggered.

-

Heavy file descriptor usage (i.e., near the process's file descriptor limit) indicates a potential file descriptor exhaustion issue.

Uptime is less than 10 minutes.

Manual close: YES

TiDB version has changed. Ack to close.

Manual close: YES

-

When a panic occurs, an alert is triggered. The thread is often recovered, otherwise, TiDB will frequently restart.

-

Maximum number of missed regions

The port of PD server metrics web endpoint

Maximum percentage of cluster space used

PD server URL

Discovery cluster specific metrics.

Preprocessing:

- JSONPATH: $[?(@.name=="pd_cluster_status")]

- JAVASCRIPT: return JSON.stringify(value != "[]" ? [{'{#SINGLETON}': ''}] : []);

- DISCARDUNCHANGEDHEARTBEAT: 1h

Discovery grpc commands specific metrics.

- DISCARDUNCHANGED_HEARTBEAT: 1h

Discovery region specific metrics.

Preprocessing:

- JSONPATH: $[?(@.name == "pd_scheduler_region_heartbeat")]

- JAVASCRIPT: The text is too long. Please see the template.

- DISCARDUNCHANGEDHEARTBEAT: 1h

Discovery region labels specific metrics.

- DISCARDUNCHANGED_HEARTBEAT: 1h

Discovery region status specific metrics.

- DISCARDUNCHANGEDHEARTBEAT: 1h

Overrides:

Too many missed regions trigger
- {#TYPE} MATCHESREGEX miss_peer_region_count
- TRIGGERPROTOTYPE LIKE Too many missed regions - DISCOVER

Unresponsive peers trigger
- {#TYPE} MATCHESREGEX down_peer_region_count
- TRIGGER_PROTOTYPE LIKE There are unresponsive peers - DISCOVER

Discovery scheduler specific metrics.

Preprocessing:

- JSONPATH: $[?(@.name == "pd_scheduler_status" && @.labels.type == "allow")]

- JAVASCRIPT: The text is too long. Please see the template.

- DISCARDUNCHANGEDHEARTBEAT: 1h

Status of PD instance.

Preprocessing:

- JSONPATH: $.status

⛔️ONFAIL: CUSTOM_VALUE -> 1

- DISCARDUNCHANGED_HEARTBEAT: 1h

The rate at which gRPC commands are completed.

⛔️ONFAIL: DISCARD_VALUE ->

- CHANGEPERSECOND

Version of the PD instance.

Preprocessing:

- JSONPATH: $.version

- DISCARDUNCHANGEDHEARTBEAT: 3h

The runtime of each PD instance.

Preprocessing:

- JSONPATH: $.start_timestamp

- JAVASCRIPT: //use boottime to calculate uptime return (Math.floor(Date.now()/1000)-Number(value));

The rate per command type at which gRPC commands are completed.

Preprocessing:

- JSONPATH: $[?(@.name == "grpc_server_handling_seconds_count" && @.labels.grpc_method == "{#GRPC_METHOD}")].value.first()

- CHANGEPERSECOND

-

Preprocessing:

- JSONPATH: $[?(@.name == "pd_cluster_status" && @.labels.type == "store_offline_count")].value.first()

- DISCARDUNCHANGEDHEARTBEAT: 1h

The count of tombstone stores.

Preprocessing:

- JSONPATH: $[?(@.name == "pd_cluster_status" && @.labels.type == "store_tombstone_count")].value.first()

- DISCARDUNCHANGEDHEARTBEAT: 1h

The count of down stores.

Preprocessing:

- JSONPATH: $[?(@.name == "pd_cluster_status" && @.labels.type == "store_down_count")].value.first()

- DISCARDUNCHANGEDHEARTBEAT: 1h

The count of low space stores.

- DISCARDUNCHANGED_HEARTBEAT: 1h

The count of unhealthy stores.

Preprocessing:

- JSONPATH: $[?(@.name == "pd_cluster_status" && @.labels.type == "store_unhealth_count")].value.first()

- DISCARDUNCHANGEDHEARTBEAT: 1h

The count of disconnected stores.

Preprocessing:

- JSONPATH: $[?(@.name == "pd_cluster_status" && @.labels.type == "store_disconnected_count")].value.first()

- DISCARDUNCHANGEDHEARTBEAT: 1h

The count of healthy storage instances.

Preprocessing:

- JSONPATH: $[?(@.name == "pd_cluster_status" && @.labels.type == "store_up_count")].value.first()

- DISCARDUNCHANGEDHEARTBEAT: 1h

The total storage capacity for this TiDB cluster.

Preprocessing:

- JSONPATH: $[?(@.name == "pd_cluster_status" && @.labels.type == "storage_capacity")].value.first()

- DISCARDUNCHANGEDHEARTBEAT: 1h

The storage size that is currently used by the TiDB cluster.

Preprocessing:

- JSONPATH: $[?(@.name == "pd_cluster_status" && @.labels.type == "storage_size")].value.first()

The total count of cluster Regions.

Preprocessing:

- JSONPATH: $[?(@.name == "pd_cluster_status" && @.labels.type == "leader_count")].value.first()

The current count of all cluster peers.

Preprocessing:

- JSONPATH: $[?(@.name == "pd_cluster_status" && @.labels.type == "region_count")].value.first()

The number of Regions in different label levels.

Preprocessing:

- JSONPATH: $[?(@.name == "pd_regions_label_level" && @.labels.type == "{#TYPE}")].value.first()

The health status of Regions indicated via the count of unusual Regions including pending peers, down peers, extra peers, offline peers, missing peers, learner peers and incorrect namespaces.

Preprocessing:

- JSONPATH: $[?(@.name == "pd_regions_status" && @.labels.type == "{#TYPE}")].value.first()

The current running schedulers.

Preprocessing:

- JSONPATH: $[?(@.name == "pd_regions_status" && @.labels.type == "allow" && @.labels.kind == "{#KIND}")].value.first()

⛔️ON_FAIL: CUSTOM_VALUE -> 0

The count of heartbeats with the ok status per second.

Preprocessing:

- JSONPATH: $[?(@.name == "pd_scheduler_region_heartbeat" && @.labels.status == "ok" && @.labels.type == "report" && @.labels.address == "{#STORE_ADDRESS}")].value.sum()

⛔️ONFAIL: CUSTOM_VALUE -> 0

- CHANGEPER_SECOND

The count of heartbeats with the error status per second.

Preprocessing:

- JSONPATH: $[?(@.name == "pd_scheduler_region_heartbeat" && @.labels.status == "err" && @.labels.type == "report" && @.labels.address == "{#STORE_ADDRESS}")].value.sum()

⛔️ONFAIL: CUSTOM_VALUE -> 0

- CHANGEPER_SECOND

The count of heartbeats reported to PD per instance per second.

Preprocessing:

- JSONPATH: $[?(@.name == "pd_scheduler_region_heartbeat" && @.labels.type == "report" && @.labels.address == "{#STORE_ADDRESS}")].value.sum()

⛔️ONFAIL: CUSTOM_VALUE -> 0

- CHANGEPER_SECOND

-

Preprocessing:

- JSONPATH: $[?(@.name == "pd_scheduler_region_heartbeat" && @.labels.type == "push" && @.labels.address == "{#STORE_ADDRESS}")].value.sum()

⛔️ONFAIL: CUSTOM_VALUE -> 0

- CHANGEPER_SECOND

Get TiDB PD instance metrics.

- CHECKNOTSUPPORTED

⛔️ONFAIL: DISCARD_VALUE ->

- PROMETHEUSTOJSON

Get TiDB PD instance status info.

- CHECKNOTSUPPORTED

⛔️ONFAIL: CUSTOM_VALUE -> {"status": "0"}

-

PD version has changed. Ack to close.

Manual close: YES

Uptime is less than 10 minutes.

Manual close: YES

PD has not received a TiKV heartbeat for a long time.

Indicates that there is no sufficient space on the TiKV node.

PD does not receive a TiKV heartbeat within 20 seconds. Normally a TiKV heartbeat comes in every 10 seconds.

Over {$PD.STORAGE_USAGE.MAX.WARN}% of the cluster space is occupied.

The number of Region replicas is smaller than the value of max-replicas. When a TiKV machine is down and its downtime exceeds max-down-time, it usually leads to missing replicas for some Regions during a period of time. When a TiKV node is made offline, it might result in a small number of Regions with missing replicas.

The number of Regions with an unresponsive peer reported by the Raft leader.

Maximum percentage of connected clients

Connection string in the URI format (password is not used). This param overwrites a value configured in the "Server" option of the configuration file (if it's set), otherwise, the plugin's default value is used: "tcp://localhost:6379"

Filter of discoverable databases

Filter to exclude discovered databases

Redis server process name for LLD

Maximum memory fragmentation ratio

Maximum percentage of memory used

Redis server process name

Maximum replication lag in seconds

Maximum number of slowlog entries per second

If AOF is activated, additional metrics will be added

Preprocessing:

- JAVASCRIPT: The text is too long. Please see the template.

Individual keyspace metrics

Preprocessing:

- JAVASCRIPT: The text is too long. Please see the template.

Filter:

- {#DB} MATCHESREGEX {$REDIS.LLD.FILTER.DB.MATCHES}

- {#DB} NOTMATCHES_REGEX {$REDIS.LLD.FILTER.DB.NOT_MATCHES}

Collect metrics by Zabbix agent if it exists

Preprocessing:

- JAVASCRIPT: return JSON.stringify(value > 0 ? [{'{#SINGLETON}': ''}] : []);

If the instance is the master and the slaves are connected, additional metrics are provided

Preprocessing:

- JAVASCRIPT: The text is too long. Please see the template.

If the instance is a replica, additional metrics are provided

Preprocessing:

- JAVASCRIPT: The text is too long. Please see the template.

Additional metrics for versions 4+

Preprocessing:

- JSONPATH: $.Server.redis_version

- JAVASCRIPT: return JSON.stringify(parseInt(value.split('.')[0]) >= 4 ? [{'{#SINGLETON}': ''}] : []);

Additional metrics for versions 5+

Preprocessing:

- JSONPATH: $.Server.redis_version

- JAVASCRIPT: return JSON.stringify(parseInt(value.split('.')[0]) >= 5 ? [{'{#SINGLETON}': ''}] : []);

Preprocessing:

- DISCARDUNCHANGEDHEARTBEAT: 10m

Preprocessing:

- CHANGEPERSECOND

System CPU consumed by the Redis server

Preprocessing:

- JSONPATH: $.CPU.used_cpu_sys

System CPU consumed by the background processes

Preprocessing:

- JSONPATH: $.CPU.used_cpu_sys_children

User CPU consumed by the Redis server

Preprocessing:

- JSONPATH: $.CPU.used_cpu_user

User CPU consumed by the background processes

Preprocessing:

- JSONPATH: $.CPU.used_cpu_user_children

The number of connections waiting on a blocking call

Preprocessing:

- JSONPATH: $.Clients.blocked_clients

The biggest input buffer among current client connections

Preprocessing:

- JAVASCRIPT: The text is too long. Please see the template.

The biggest output buffer among current client connections

Preprocessing:

- JAVASCRIPT: The text is too long. Please see the template.

The number of connected clients

Preprocessing:

- JSONPATH: $.Clients.connected_clients

Indicate Redis cluster is enabled

Preprocessing:

- JSONPATH: $.Cluster.cluster_enabled

Total number of bytes allocated by Redis using its allocator

Preprocessing:

- JSONPATH: $.Memory.used_memory

Amount of memory used by the Lua engine

Preprocessing:

- JSONPATH: $.Memory.used_memory_lua

Peak memory consumed by Redis (in bytes)

Preprocessing:

- JSONPATH: $.Memory.used_memory_peak

Number of bytes that Redis allocated as seen by the operating system

Preprocessing:

- JSONPATH: $.Memory.used_memory_rss

This ratio is an indication of memory mapping efficiency:

— Value over 1.0 indicate that memory fragmentation is very likely. Consider restarting the Redis server so the operating system can recover fragmented memory, especially with a ratio over 1.5.

— Value under 1.0 indicate that Redis likely has insufficient memory available. Consider optimizing memory usage or adding more RAM.

Note: If your peak memory usage is much higher than your current memory usage, the memory fragmentation ratio may be unreliable.

https://redis.io/topics/memory-optimization

Preprocessing:

- JSONPATH: $.Memory.mem_fragmentation_ratio

Duration of the on-going AOF rewrite operation if any

Preprocessing:

- JSONPATH: $.Persistence.aof_current_rewrite_time_sec

Flag indicating AOF logging is activated

Preprocessing:

- JSONPATH: $.Persistence.aof_enabled

Status of the last AOF rewrite operation

- BOOLTO_DECIMAL

Duration of the last AOF rewrite

Preprocessing:

- JSONPATH: $.Persistence.aof_last_rewrite_time_sec

Status of the last write operation to the AOF

- BOOLTO_DECIMAL

Flag indicating a AOF rewrite operation is on-going

Preprocessing:

- JSONPATH: $.Persistence.aof_rewrite_in_progress

Flag indicating an AOF rewrite operation will be scheduled once the on-going RDB save is complete

Preprocessing:

- JSONPATH: $.Persistence.aof_rewrite_scheduled

Flag indicating if the load of a dump file is on-going

Preprocessing:

- JSONPATH: $.Persistence.loading

"1" if bgsave is in progress and "0" otherwise

Preprocessing:

- JSONPATH: $.Persistence.rdb_bgsave_in_progress

Number of changes since the last background save

Preprocessing:

- JSONPATH: $.Persistence.rdb_changes_since_last_save

Duration of the on-going RDB save operation if any

Preprocessing:

- JSONPATH: $.Persistence.rdb_current_bgsave_time_sec

Status of the last RDB save operation

- BOOLTO_DECIMAL

Duration of the last bg_save operation

Preprocessing:

- JSONPATH: $.Persistence.rdb_last_bgsave_time_sec

Epoch-based timestamp of last successful RDB save

Preprocessing:

- JSONPATH: $.Persistence.rdb_last_save_time

Number of connected slaves

Preprocessing:

- JSONPATH: $.Replication.connected_slaves

Flag indicating replication backlog is active

Preprocessing:

- JSONPATH: $.Replication.repl_backlog_active

The master offset of the replication backlog buffer

Preprocessing:

- JSONPATH: $.Replication.repl_backlog_first_byte_offset

Amount of data in the backlog sync buffer

Preprocessing:

- JSONPATH: $.Replication.repl_backlog_histlen

Total size in bytes of the replication backlog buffer

Preprocessing:

- JSONPATH: $.Replication.repl_backlog_size

Value is "master" if the instance is replica of no one, or "slave" if the instance is a replica of some master instance. Note that a replica can be master of another replica (chained replication).

Preprocessing:

- JSONPATH: $.Replication.role

- DISCARDUNCHANGEDHEARTBEAT: 1d

Replication offset reported by the master

Preprocessing:

- JSONPATH: $.Replication.master_repl_offset

PID of the server process

- DISCARDUNCHANGED_HEARTBEAT: 1d

The server's mode ("standalone", "sentinel" or "cluster")

- DISCARDUNCHANGED_HEARTBEAT: 1d

Version of the Redis server

- DISCARDUNCHANGED_HEARTBEAT: 1d

TCP/IP listen port

- DISCARDUNCHANGED_HEARTBEAT: 1d

Number of seconds since Redis server start

Preprocessing:

- JSONPATH: $.Server.uptime_in_seconds

Number of evicted keys due to maxmemory limit

Preprocessing:

- JSONPATH: $.Stats.evicted_keys

Total number of key expiration events

Preprocessing:

- JSONPATH: $.Stats.expired_keys

The network's read rate per second in KB/sec

Preprocessing:

- JSONPATH: $.Stats.instantaneous_input_kbps

- MULTIPLIER: 1024

Number of commands processed per second

Preprocessing:

- JSONPATH: $.Stats.instantaneous_ops_per_sec

The network's write rate per second in KB/sec

Preprocessing:

- JSONPATH: $.Stats.instantaneous_output_kbps

- MULTIPLIER: 1024

Number of successful lookup of keys in the main dictionary

Preprocessing:

- JSONPATH: $.Stats.keyspace_hits

Number of failed lookup of keys in the main dictionary

Preprocessing:

- JSONPATH: $.Stats.keyspace_misses

Duration of the latest fork operation in microseconds

Preprocessing:

- JSONPATH: $.Stats.latest_fork_usec

- MULTIPLIER: 1.0E-5

The number of sockets open for MIGRATE purposes

Preprocessing:

- JSONPATH: $.Stats.migrate_cached_sockets

Global number of pub/sub channels with client subscriptions

Preprocessing:

- JSONPATH: $.Stats.pubsub_channels

Global number of pub/sub pattern with client subscriptions

Preprocessing:

- JSONPATH: $.Stats.pubsub_patterns

Number of connections rejected because of maxclients limit

Preprocessing:

- JSONPATH: $.Stats.rejected_connections

The number of full resyncs with replicas

Preprocessing:

- JSONPATH: $.Stats.sync_full

The number of denied partial resync requests

Preprocessing:

- JSONPATH: $.Stats.sync_partial_err

The number of accepted partial resync requests

Preprocessing:

- JSONPATH: $.Stats.sync_partial_ok

Total number of commands processed by the server

Preprocessing:

- JSONPATH: $.Stats.total_commands_processed

Total number of connections accepted by the server

Preprocessing:

- JSONPATH: $.Stats.total_connections_received

The total number of bytes read from the network

Preprocessing:

- JSONPATH: $.Stats.total_net_input_bytes

The total number of bytes written to the network

Preprocessing:

- JSONPATH: $.Stats.total_net_output_bytes

Max number of connected clients at the same time.

Once the limit is reached Redis will close all the new connections sending an error "max number of clients reached".

Preprocessing:

- JSONPATH: $.maxclients

- DISCARDUNCHANGEDHEARTBEAT: 30m

Average TTL

Preprocessing:

- JSONPATH: $.Keyspace["{#DB}"].avg_ttl

- MULTIPLIER: 0.001

Number of keys with an expiration

Preprocessing:

- JSONPATH: $.Keyspace["{#DB}"].expires

Total number of keys

Preprocessing:

- JSONPATH: $.Keyspace["{#DB}"].keys

AOF current file size

Preprocessing:

- JSONPATH: $.Persistence.aof_current_size

AOF file size on latest startup or rewrite

Preprocessing:

- JSONPATH: $.Persistence.aof_base_size

Flag indicating an AOF rewrite operation will

Preprocessing:

- JSONPATH: $.Persistence.aof_pending_rewrite

Size of the AOF buffer

Preprocessing:

- JSONPATH: $.Persistence.aof_buffer_length

Size of the AOF rewrite buffer

Preprocessing:

- JSONPATH: $.Persistence.aof_rewrite_buffer_length

Number of fsync pending jobs in background I/O queue

Preprocessing:

- JSONPATH: $.Persistence.aof_pending_bio_fsync

Delayed fsync counter

Preprocessing:

- JSONPATH: $.Persistence.aof_delayed_fsync

Host or IP address of the master

- DISCARDUNCHANGED_HEARTBEAT: 1d

Master listening TCP port

- DISCARDUNCHANGED_HEARTBEAT: 1d

Status of the link (up/down)

Preprocessing:

- JSONPATH: $.Replication.master_link_status

- BOOLTODECIMAL

Number of seconds since the last interaction with master

Preprocessing:

- JSONPATH: $.Replication.master_last_io_seconds_ago

Indicate the master is syncing to the replica

Preprocessing:

- JSONPATH: $.Replication.master_sync_in_progress

The replication offset of the replica instance

Preprocessing:

- JSONPATH: $.Replication.slave_repl_offset

The priority of the instance as a candidate for failover

Preprocessing:

- JSONPATH: $.Replication.slave_priority

Flag indicating if the replica is read-only

Preprocessing:

- JSONPATH: $.Replication.slave_read_only

- DISCARDUNCHANGEDHEARTBEAT: 1d

Replication lag in bytes

Preprocessing:

- JAVASCRIPT: The text is too long. Please see the template.

-

Resident set size memory used by process in bytes.

Virtual memory size used by process in bytes.

Process CPU utilization percentage.

The path to the server's executable

Preprocessing:

- JSONPATH: $.Server.executable

- DISCARDUNCHANGEDHEARTBEAT: 1d

The percentage of usedmemorypeak out of used_memory

Preprocessing:

- JSONPATH: $.Memory.used_memory_peak_perc

- REGEX: (.+)% \1

The sum in bytes of all overheads that the server allocated for managing its internal data structures

Preprocessing:

- JSONPATH: $.Memory.used_memory_overhead

Initial amount of memory consumed by Redis at startup in bytes

Preprocessing:

- JSONPATH: $.Memory.used_memory_startup

The size in bytes of the dataset

Preprocessing:

- JSONPATH: $.Memory.used_memory_dataset

The percentage of usedmemorydataset out of the net memory usage (usedmemory minus usedmemory_startup)

Preprocessing:

- JSONPATH: $.Memory.used_memory_dataset_perc

- REGEX: (.+)% \1

The total amount of memory that the Redis host has

Preprocessing:

- JSONPATH: $.Memory.total_system_memory

Maximum amount of memory allocated to the Redisdb system

Preprocessing:

- JSONPATH: $.Memory.maxmemory

The value of the maxmemory-policy configuration directive

- DISCARDUNCHANGED_HEARTBEAT: 1d

Flag indicating if active defragmentation is active

Preprocessing:

- JSONPATH: $.Memory.active_defrag_running

The number of objects waiting to be freed (as a result of calling UNLINK, or FLUSHDB and FLUSHALL with the ASYNC option)

Preprocessing:

- JSONPATH: $.Memory.lazyfree_pending_objects

The size in bytes of copy-on-write allocations during the last RDB save operation

Preprocessing:

- JSONPATH: $.Persistence.rdb_last_cow_size

The size in bytes of copy-on-write allocations during the last AOF rewrite operation

Preprocessing:

- JSONPATH: $.Persistence.aof_last_cow_size

-

Preprocessing:

- JSONPATH: $.Stats.expired_stale_perc

-

Preprocessing:

- JSONPATH: $.Stats.expired_time_cap_reached_count

The number of keys tracked for expiry purposes (applicable only to writable replicas)

Preprocessing:

- JSONPATH: $.Stats.slave_expires_tracked_keys

Number of value reallocations performed by active the defragmentation process

Preprocessing:

- JSONPATH: $.Stats.active_defrag_hits

Number of aborted value reallocations started by the active defragmentation process

Preprocessing:

- JSONPATH: $.Stats.active_defrag_misses

Number of keys that were actively defragmented

Preprocessing:

- JSONPATH: $.Stats.active_defrag_key_hits

Number of keys that were skipped by the active defragmentation process

Preprocessing:

- JSONPATH: $.Stats.active_defrag_key_misses

Offset up to which replication IDs are accepted

Preprocessing:

- JSONPATH: $.Replication.second_repl_offset

-

Preprocessing:

- JSONPATH: $.Memory.allocator_active

-

Preprocessing:

- JSONPATH: $.Memory.allocator_allocated

-

Preprocessing:

- JSONPATH: $.Memory.allocator_resident

-

Preprocessing:

- JSONPATH: $.Memory.used_memory_scripts

-

Preprocessing:

- JSONPATH: $.Memory.number_of_cached_scripts

-

Preprocessing:

- JSONPATH: $.Memory.allocator_frag_bytes

-

Preprocessing:

- JSONPATH: $.Memory.allocator_frag_ratio

-

Preprocessing:

- JSONPATH: $.Memory.allocator_rss_bytes

-

Preprocessing:

- JSONPATH: $.Memory.allocator_rss_ratio

-

Preprocessing:

- JSONPATH: $.Memory.rss_overhead_bytes

-

Preprocessing:

- JSONPATH: $.Memory.rss_overhead_ratio

-

Preprocessing:

- JSONPATH: $.Memory.mem_fragmentation_bytes

-

Preprocessing:

- JSONPATH: $.Memory.mem_not_counted_for_evict

-

Preprocessing:

- JSONPATH: $.Memory.mem_replication_backlog

-

Preprocessing:

- JSONPATH: $.Memory.mem_clients_normal

-

Preprocessing:

- JSONPATH: $.Memory.mem_clients_slaves

Size of the AOF buffer

Preprocessing:

- JSONPATH: $.Memory.mem_aof_buffer

Preprocessing:

- DISCARDUNCHANGEDHEARTBEAT: 1h

-

Manual close: YES

-

When the number of clients reaches the value of the "maxclients" parameter, new connections will be rejected.

https://redis.io/topics/clients#maximum-number-of-clients

This ratio is an indication of memory mapping efficiency:

— Value over 1.0 indicate that memory fragmentation is very likely. Consider restarting the Redis server so the operating system can recover fragmented memory, especially with a ratio over 1.5.

— Value under 1.0 indicate that Redis likely has insufficient memory available. Consider optimizing memory usage or adding more RAM.

Note: If your peak memory usage is much higher than your current memory usage, the memory fragmentation ratio may be unreliable.

https://redis.io/topics/memory-optimization

Detailed information about persistence: https://redis.io/topics/persistence

Detailed information about persistence: https://redis.io/topics/persistence

Redis number of slaves has changed. Ack to close.

Manual close: YES

Redis replication role has changed. Ack to close.

Manual close: YES

Redis version has changed. Ack to close.

Manual close: YES

Uptime is less than 10 minutes.

Manual close: YES

The number of connections has reached the value of "maxclients".

https://redis.io/topics/clients

-

-

-

Zabbix has not received data for items for the last 30 minutes

Manual close: YES

Depends on:

- Redis: Service is down

Redis configuration has changed. Ack to close.

Manual close: YES

-

-

-

-

-

-

-

Execution time limit for count of slow queries.

Slow queries count threshold for a trigger.

-

-

-

Filter:

- {#DBNAME} MATCHES_REGEX {$PG.LLD.FILTER.DBNAME}

-

Filter:

- {#APPLICATIONNAME} MATCHESREGEX {$PG.LLD.FILTER.APPLICATION}

Execute custom queries from file *.sql (check for option Plugins.Postgres.CustomQueriesPath at agent configuration)

WAL write in bytes

Preprocessing:

- JSONPATH: $.write

- CHANGEPERSECOND

WAL receive in bytes

Preprocessing:

- JSONPATH: $.receive

- CHANGEPERSECOND

Number of WAL segments

Preprocessing:

- JSONPATH: $.count

Number of buffers allocated

- CHANGEPER_SECOND

Number of buffers written directly by a backend

- CHANGEPER_SECOND

Number of times the background writer stopped a cleaning scan because it had written too many buffers

- CHANGEPER_SECOND

Number of times a backend had to execute its own fsync call (normally the background writer handles those even when the backend does its own write)

Preprocessing:

- JSONPATH: $.buffers_backend_fsync

- CHANGEPERSECOND

Number of buffers written by the background writer

- CHANGEPER_SECOND

Number of buffers written during checkpoints

- CHANGEPER_SECOND

Number of scheduled checkpoints that have been performed

- CHANGEPER_SECOND

Number of requested checkpoints that have been performed

- CHANGEPER_SECOND

Total amount of time that has been spent in the portion of checkpoint processing where files are written to disk, in milliseconds

Preprocessing:

- JSONPATH: $.checkpoint_write_time

- MULTIPLIER: 0.001

- CHANGEPERSECOND

Total amount of time that has been spent in the portion of checkpoint processing where files are synchronized to disk, in milliseconds

Preprocessing:

- JSONPATH: $.checkpoint_sync_time

- MULTIPLIER: 0.001

- CHANGEPERSECOND

Total amount of time that has been spent in the portion of checkpoint processing where files are synchronized to disk

Preprocessing:

- JSONPATH: $.checkpoint_sync_time

- MULTIPLIER: 0.001

- CHANGEPERSECOND

Collect all metrics from pgstatactivity

https://www.postgresql.org/docs/current/monitoring-stats.html#PG-STAT-ARCHIVER-VIEW

Preprocessing:

- JSONPATH: $.archived_count

Collect all metrics from pgstatactivity

https://www.postgresql.org/docs/current/monitoring-stats.html#PG-STAT-ARCHIVER-VIEW

Preprocessing:

- JSONPATH: $.failed_count

-

Preprocessing:

- JSONPATH: $.count_files

Size of files to archive

Preprocessing:

- JSONPATH: $.size_files

Time spent reading data file blocks by backends, in milliseconds

Preprocessing:

- JSONPATH: $.blk_read_time

- MULTIPLIER: 0.001

Time spent writing data file blocks by backends, in milliseconds

Preprocessing:

- JSONPATH: $.blk_write_time

- MULTIPLIER: 0.001

Number of data page checksum failures detected (or on a shared object), or NULL if data checksums are not enabled. This metric included in PostgreSQL 12

- MATCHESREGEX: ^\d*$

- CHANGEPERSECOND

⛔️ON_FAIL: CUSTOM_VALUE -> -1

Number of transactions that have been committed

- CHANGEPER_SECOND

Number of queries canceled due to conflicts with recovery. (Conflicts occur only on standby servers; see pgstatdatabase_conflicts for details.)

Preprocessing:

- JSONPATH: $.conflicts

- CHANGEPERSECOND

Number of deadlocks detected

Preprocessing:

- JSONPATH: $.deadlocks

- CHANGEPERSECOND

Number of disk blocks read

- CHANGEPER_SECOND

Number of times disk blocks were found already in the buffer cache

- CHANGEPER_SECOND

Total amount of data written to temporary files by queries

- CHANGEPER_SECOND

Number of temporary files created by queries

- CHANGEPER_SECOND

Number of transactions that have been rolled back

- CHANGEPER_SECOND

Number of rows deleted by queries

- CHANGEPER_SECOND

Number of rows fetched by queries

- CHANGEPER_SECOND

Number of rows inserted by queries

- CHANGEPER_SECOND

Number of rows returned by queries

- CHANGEPER_SECOND

Number of rows updated by queries

- CHANGEPER_SECOND

Number of connected backends

Preprocessing:

- JSONPATH: $.numbackends

Total number of connections executing a query

Preprocessing:

- JSONPATH: $.active

Total number of connections executing a fast-path function

Preprocessing:

- JSONPATH: $.idle_in_transaction

Total number of connections waiting for a new client command

Preprocessing:

- JSONPATH: $.idle

Total number of connections in a transaction state, but not executing a query

Preprocessing:

- JSONPATH: $.idle_in_transaction

Total number of prepared transactions

https://www.postgresql.org/docs/current/sql-prepare-transaction.html

Preprocessing:

- JSONPATH: $.prepared

Total number of connections

Preprocessing:

- JSONPATH: $.total

Total number of connections in percentage

Preprocessing:

- JSONPATH: $.total_pct

Total number of waiting connections

https://www.postgresql.org/docs/current/monitoring-stats.html#WAIT-EVENT-TABLE

Preprocessing:

- JSONPATH: $.waiting

Total number of connections in a transaction state, but not executing a query and one of the statements in the transaction caused an error.

Preprocessing:

- JSONPATH: $.idle_in_transaction_aborted

Total number of disabled connections

Preprocessing:

- JSONPATH: $.disabled

Age of oldest xid.

Number of autovacuum workers.

-

Expression:

-

Replication lag with Master in byte.

Replication lag with Master in seconds.

Replication role: 1 — recovery is still in progress (standby mode), 0 — master mode.

Number of standby servers

Replication status: 0 — streaming is down, 1 — streaming is up, 2 — master mode

-

Preprocessing:

- DISCARDUNCHANGEDHEARTBEAT: 1h

Preprocessing:

- JSONPATH: $['{#APPLICATION_NAME}'].flush_lag

Preprocessing:

- JSONPATH: $['{#APPLICATION_NAME}'].replay_lag

Preprocessing:

- JSONPATH: $['{#APPLICATION_NAME}'].write_lag

Database age

Number of bloating tables

Database size

Total number of times disk blocks were found already in the buffer cache, so that a read was not necessary

- CHANGEPER_SECOND

Total number of disk blocks read in this database

- CHANGEPER_SECOND

Total number of queries canceled due to conflicts with recovery in this database

Preprocessing:

- JSONPATH: $['{#DBNAME}'].conflicts

- CHANGEPERSECOND

Total number of detected deadlocks in this database

Preprocessing:

- JSONPATH: $['{#DBNAME}'].deadlocks

- CHANGEPERSECOND

Total amount of data written to temporary files by queries in this database

- CHANGEPER_SECOND

Total number of temporary files created by queries in this database

- CHANGEPER_SECOND

Total number of rows deleted by queries in this database

- CHANGEPER_SECOND

Total number of rows fetched by queries in this database

- CHANGEPER_SECOND

Total number of rows inserted by queries in this database

- CHANGEPER_SECOND

Number of rows returned by queries in this database

- CHANGEPER_SECOND

Total number of rows updated by queries in this database

- CHANGEPER_SECOND

Number of transactions in this database that have been committed

- CHANGEPER_SECOND

Total number of transactions in this database that have been rolled back

- CHANGEPER_SECOND

Number of backends currently connected to this database

Preprocessing:

- JSONPATH: $['{#DBNAME}'].numbackends

Number of data page checksum failures detected in this database

- MATCHESREGEX: ^\d*$

- CHANGEPERSECOND

⛔️ON_FAIL: CUSTOM_VALUE -> -1

Time spent reading data file blocks by backends, in milliseconds

Preprocessing:

- JSONPATH: $['{#DBNAME}'].blk_read_time

- MULTIPLIER: 0.001

- CHANGEPERSECOND

Time spent writing data file blocks by backends, in milliseconds

Preprocessing:

- JSONPATH: $['{#DBNAME}'].blk_write_time

- MULTIPLIER: 0.001

- CHANGEPERSECOND

Number of accessexclusive locks for each database

Preprocessing:

- JSONPATH: $['{#DBNAME}'].accessexclusive

Number of accessshare locks for each database

Preprocessing:

- JSONPATH: $['{#DBNAME}'].accessshare

Number of exclusive locks for each database

Preprocessing:

- JSONPATH: $['{#DBNAME}'].exclusive

Number of rowexclusive locks for each database

Preprocessing:

- JSONPATH: $['{#DBNAME}'].rowexclusive

Number of rowshare locks for each database

Preprocessing:

- JSONPATH: $['{#DBNAME}'].rowshare

Number of total sharerowexclusive for each database

Preprocessing:

- JSONPATH: $['{#DBNAME}'].sharerowexclusive

Number of shareupdateexclusive locks for each database

Preprocessing:

- JSONPATH: $['{#DBNAME}'].shareupdateexclusive

Number of share locks for each database

Preprocessing:

- JSONPATH: $['{#DBNAME}'].share

Number of total locks for each database

Preprocessing:

- JSONPATH: $['{#DBNAME}'].total

Max maintenance query time

Preprocessing:

- JSONPATH: $['{#DBNAME}'].mro_time_max

Max query time

Preprocessing:

- JSONPATH: $['{#DBNAME}'].query_time_max

Max transaction query time

Preprocessing:

- JSONPATH: $['{#DBNAME}'].tx_time_max

Slow maintenance query count

Preprocessing:

- JSONPATH: $['{#DBNAME}'].mro_slow_count

Slow query count

Preprocessing:

- JSONPATH: $['{#DBNAME}'].query_slow_count

Slow transaction query count

Preprocessing:

- JSONPATH: $['{#DBNAME}'].tx_slow_count

Sum maintenance query time

Preprocessing:

- JSONPATH: $['{#DBNAME}'].mro_time_sum

Sum query time

Preprocessing:

- JSONPATH: $['{#DBNAME}'].query_time_sum

Sum transaction query time

Preprocessing:

- JSONPATH: $['{#DBNAME}'].tx_time_sum

https://www.postgresql.org/docs/12/monitoring-stats.html#PG-STAT-BGWRITER-VIEW

Collect archive status metrics

Collect all metrics from pgstatdatabase per database

https://www.postgresql.org/docs/current/monitoring-stats.html#PG-STAT-DATABASE-VIEW

Collect all metrics from pgstatdatabase per database

https://www.postgresql.org/docs/current/monitoring-stats.html#PG-STAT-DATABASE-VIEW

Collect all metrics from pgstatactivity

https://www.postgresql.org/docs/current/monitoring-stats.html#PG-STAT-ACTIVITY-VIEW

Collect WAL metrics

Collect all metrics from pg_locks per database

https://www.postgresql.org/docs/current/explicit-locking.html#LOCKING-TABLES

Collect metrics from the pgstatreplication, which contains information about the WAL sender process, showing statistics about replication to that sender's connected standby server.

Collect all metrics by query execution time

Data page checksum failures were detected on that DB instance.

https://www.postgresql.org/docs/current/checksums.html

-

-

-

-

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

-

Data page checksum failures were detected on that database.

https://www.postgresql.org/docs/current/checksums.html

-

-

-

-

-

-

-

-

-

-

-

-

-

Please set user's password in this macro.

-

-

-

-

-

-

-

-

-

-

Filter:

- {#DBNAME} MATCHES_REGEX {$PG.LLD.FILTER.DBNAME}

Number of buffers allocated

- CHANGEPER_SECOND

Number of buffers written directly by a backend

- CHANGEPER_SECOND

Number of times a backend had to execute its own fsync call (normally the background writer handles those even when the backend does its own write)

Preprocessing:

- JSONPATH: $.buffers_backend_fsync

- CHANGEPERSECOND

Number of buffers written during checkpoints

- CHANGEPER_SECOND

Number of buffers written by the background writer

- CHANGEPER_SECOND

Number of requested checkpoints that have been performed

- CHANGEPER_SECOND

Number of scheduled checkpoints that have been performed

- CHANGEPER_SECOND

Total amount of time that has been spent in the portion of checkpoint processing where files are synchronized to disk

Preprocessing:

- JSONPATH: $.checkpoint_sync_time

- MULTIPLIER: 0.001

- CHANGEPERSECOND

Total amount of time that has been spent in the portion of checkpoint processing where files are written to disk, in milliseconds

Preprocessing:

- JSONPATH: $.checkpoint_write_time

- MULTIPLIER: 0.001

- CHANGEPERSECOND

Number of times the background writer stopped a cleaning scan because it had written too many buffers

- CHANGEPER_SECOND

Cache hit ratio

PostgreSQL configuration hash

Preprocessing:

- DISCARDUNCHANGEDHEARTBEAT: 1h

Total number of connections executing a query

Preprocessing:

- JSONPATH: $.active

Total number of connections waiting for a new client command

Preprocessing:

- JSONPATH: $.idle

Total number of connections in a transaction state, but not executing a query

Preprocessing:

- JSONPATH: $.idle_in_transaction

Total number of prepared transactions

https://www.postgresql.org/docs/current/sql-prepare-transaction.html

Preprocessing:

- JSONPATH: $.prepared

Total number of connections

Preprocessing:

- JSONPATH: $.total

Total number of connections in percentage

Preprocessing:

- JSONPATH: $.total_pct

Total number of waiting connections

https://www.postgresql.org/docs/current/monitoring-stats.html#WAIT-EVENT-TABLE

Preprocessing:

- JSONPATH: $.waiting

-

Preprocessing:

- REGEX: Time:\s+(\d+\.\d+)\s+ms \1

- MULTIPLIER: 0.001

-

Preprocessing:

- JAVASCRIPT: return value.search(/accepting connections/)>0 ? 1 : 0

- DISCARDUNCHANGEDHEARTBEAT: 1h

Number of standby servers

Replication lag with Master in seconds

Replication role: 1 — recovery is still in progress (standby mode), 0 — master mode.

Replication status: 0 — streaming is down, 1 — streaming is up, 2 — master mode

Current max active transaction time

Preprocessing:

- JSONPATH: $.active

Current max idle transaction time

Preprocessing:

- JSONPATH: $.idle

Current max prepared transaction time

Preprocessing:

- JSONPATH: $.prepared

Current max waiting transaction time

Preprocessing:

- JSONPATH: $.waiting

-

PostgreSQL version

Preprocessing:

- DISCARDUNCHANGEDHEARTBEAT: 1d

Number of WAL segments

Preprocessing:

- JSONPATH: $.count

WAL write in bytes

Preprocessing:

- JSONPATH: $.write

- CHANGEPERSECOND

Database size

Total number of times disk blocks were found already in the buffer cache, so that a read was not necessary

- CHANGEPER_SECOND

Total number of disk blocks read in this database

- CHANGEPER_SECOND

Total number of queries canceled due to conflicts with recovery in this database

Preprocessing:

- JSONPATH: $['{#DBNAME}'].conflicts

- CHANGEPERSECOND

Total number of detected deadlocks in this database

Preprocessing:

- JSONPATH: $['{#DBNAME}'].deadlocks

- CHANGEPERSECOND

Total amount of data written to temporary files by queries in this database

- CHANGEPER_SECOND

Total number of temporary files created by queries in this database

- CHANGEPER_SECOND

Total number of rows deleted by queries in this database

- CHANGEPER_SECOND

Total number of rows fetched by queries in this database

- CHANGEPER_SECOND

Total number of rows inserted by queries in this database

- CHANGEPER_SECOND

Total number of rows updated by queries in this database

- CHANGEPER_SECOND

Total number of rows updated by queries in this database

- CHANGEPER_SECOND

Number of transactions in this database that have been committed

- CHANGEPER_SECOND

Total number of transactions in this database that have been rolled back

- CHANGEPER_SECOND

reventing Transaction ID Wraparound Failures

https://www.postgresql.org/docs/current/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND

Preprocessing:

- JSONPATH: $.prc_before_av

Preventing Transaction ID Wraparound Failures

https://www.postgresql.org/docs/current/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND

Preprocessing:

- JSONPATH: $.prc_before_stop

Total number of locks in the database

Preprocessing:

- JSONPATH: $['{#DBNAME}'].total

Slow maintenance query count

Preprocessing:

- JSONPATH: $['{#DBNAME}'].mro_slow_count

Max maintenance query time

Preprocessing:

- JSONPATH: $['{#DBNAME}'].mro_time_max

Sum maintenance query time

Preprocessing:

- JSONPATH: $['{#DBNAME}'].mro_time_sum

Slow query count

Preprocessing:

- JSONPATH: $['{#DBNAME}'].query_slow_count

Max query time

Preprocessing:

- JSONPATH: $['{#DBNAME}'].query_time_max

Sum query time

Preprocessing:

- JSONPATH: $['{#DBNAME}'].query_time_sum

Slow transaction query count

Preprocessing:

- JSONPATH: $['{#DBNAME}'].tx_slow_count

Max transaction query time

Preprocessing:

- JSONPATH: $['{#DBNAME}'].tx_time_max

Sum transaction query time

Preprocessing:

- JSONPATH: $['{#DBNAME}'].tx_time_sum

Number of index scans in the database

Preprocessing:

- JSONPATH: $.idx

- CHANGEPERSECOND

Number of sequential scans in the database

Preprocessing:

- JSONPATH: $.seq

- CHANGEPERSECOND

Statistics about the background writer process's activity

Collect all metrics from pgstatactivity

https://www.postgresql.org/docs/current/monitoring-stats.html#PG-STAT-ACTIVITY-VIEW

Collect all metrics from pgstatdatabase per database

https://www.postgresql.org/docs/current/monitoring-stats.html#PG-STAT-DATABASE-VIEW

Collect all metrics from pg_locks per database

https://www.postgresql.org/docs/current/explicit-locking.html#LOCKING-TABLES

Collect all metrics by query execution time

Collect metrics by transaction execution time

Master item to collect WAL metrics

-

Number of scans done for table/index in the database

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

-

-

-

-

Depends on:

- PostgreSQL: Service is down

-

-

-

PostgreSQL uptime is less than 10 minutes

-

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

-

Preventing Transaction ID Wraparound Failures

https://www.postgresql.org/docs/current/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND

-

-

Zabbix has not received data for items for the last 30 minutes

Depends on:

- PostgreSQL: Service is down

The maximum percentage of used Automatic Storage Management (ASM) disk group for a high trigger expression.

The maximum percentage of used ASM disk group for a warning trigger expression.

The maximum percentage of sessions concurrency usage for a trigger expression.

The maximum percentage of used database files for a trigger expression.

This macro is used in database discovery. It can be overridden on host level or its linked template level.

This macro is used in database discovery. It can be overridden on host level or its linked template level.

The Oracle driver path. For example: /usr/lib/oracle/21/client64/lib/libsqora.so.21.1

The number of warning days before the password expires for a trigger expression.

The Oracle user's password.

Alert threshold for the maximum percentage of the Program Global Area (PGA) usage for a trigger expression.

Oracle DB TCP port.

Alert threshold for the maximum percentage of active processes for a trigger expression.

Alert threshold for the minimum number of REDO logs for a trigger expression.

Oracle Service Name.

The maximum duration of the session lock in seconds to count the session as a prolongedly locked query.

Alert threshold for the maximum number of the prolongedly locked sessions for a trigger expression.

Alert threshold for the maximum percentage of locked sessions for a trigger expression.

Alert threshold for the maximum percentage of active sessions for a trigger expression.

Alert threshold for the minimum percentage of free shared pool for a trigger expression.

This macro is used in tablespace discovery. It can be overridden on host level or its linked template level.

This macro is used in tablespace discovery. It can be overridden on host level or its linked template level.

High severity alert threshold for the maximum percentage of tablespace usage (used bytes/allocated bytes) for a trigger expression.

Warning severity alert threshold for the maximum percentage of tablespace usage (used bytes/allocated bytes) for a trigger expression.

High severity alert threshold for the maximum percentage of tablespace utilization (allocated bytes/max bytes) for a trigger expression.

Warning severity alert threshold for the maximum percentage of tablespace utilization (allocated bytes/max bytes) for a trigger expression.

Oracle username.

Destinations of the log archive.

The ASM disk groups.

Scanning databases in the database management system (DBMS).

- {#DBNAME} MATCHESREGEX {$ORACLE.DBNAME.MATCHES}

- {#DBNAME} NOTMATCHESREGEX {$ORACLE.DBNAME.NOT_MATCHES}

Scanning a pluggable database (PDB) in DBMS.

- {#DBNAME} MATCHESREGEX {$ORACLE.DBNAME.MATCHES}

- {#DBNAME} NOTMATCHESREGEX {$ORACLE.DBNAME.NOT_MATCHES}

Scanning tablespaces in DBMS.

Filter:

- {#TABLESPACE} MATCHESREGEX {$ORACLE.TABLESPACE.NAME.MATCHES}

- {#TABLESPACE} NOTMATCHES_REGEX {$ORACLE.TABLESPACE.NAME.NOT_MATCHES}

It checks the availability of Oracle on the TCP port.

Preprocessing:

- DISCARDUNCHANGEDHEARTBEAT: 10m

The number of running LISTENER processes.

Preprocessing:

- DISCARDUNCHANGEDHEARTBEAT: 10m

The Oracle Server version.

Preprocessing:

- JSONPATH: $..VERSION.first()

- DISCARDUNCHANGEDHEARTBEAT: 1d

The Oracle instance uptime expressed in seconds.

Preprocessing:

- JSONPATH: $..UPTIME.first()

The status of the instance.

Preprocessing:

- JSONPATH: $..STATUS.first()

The status of automatic archiving.

Preprocessing:

- JSONPATH: $..ARCHIVER.first()

The name of an instance.

Preprocessing:

- JSONPATH: $..INSTANCE_NAME.first()

The name of the host machine.

Preprocessing:

- JSONPATH: $..HOST_NAME.first()

It indicates whether the instance is an active instance or an inactive secondary instance.

Preprocessing:

- JSONPATH: $..INSTANCE_ROLE.first()

The user and system sessions.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYSPARAM::Sessions')].VALUE.first()

The maximum allowable number of datafiles.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYSPARAM::Db_Files')].VALUE.first()

The maximum number of user processes.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYSPARAM::Processes')].VALUE.first()

Preprocessing:

- JSONPATH: $[?(@.METRIC=='PROC::Procnum')].VALUE.first()

The current number of datafiles.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='DATAFILE::Count')].VALUE.first()

The ratio of buffer cache hits ((LogRead - PhyRead)/LogRead).

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Buffer Cache Hit Ratio')].VALUE.first()

The ratio of cursor cache hits (CursorCacheHit/SoftParse).

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Cursor Cache Hit Ratio')].VALUE.first()

The ratio of library cache hits (Hits/Pins).

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Library Cache Hit Ratio')].VALUE.first()

Free memory of a shared pool expressed in %.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Shared Pool Free %')].VALUE.first()

Reads per second.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Physical Reads Per Sec')].VALUE.first()

Writes per second.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Physical Writes Per Sec')].VALUE.first()

Read bytes per second.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Physical Read Bytes Per Sec')].VALUE.first()

Write bytes per second.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Physical Write Bytes Per Sec')].VALUE.first()

Enqueue timeouts per second.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Enqueue Timeouts Per Sec')].VALUE.first()

The global cache (GC) and the consistent read (CR) block received per second.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::GC CR Block Received Per Second')].VALUE.first()

The number of blocks that encountered corruption or checksum failure during the interconnect.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Global Cache Blocks Corrupted')].VALUE.first()

The number of lost global cache blocks.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Global Cache Blocks Lost')].VALUE.first()

The number of logon attempts.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Logons Per Sec')].VALUE.first()

The average active sessions at a point in time. The number of sessions that are either working or waiting.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Average Active Sessions')].VALUE.first()

The count of sessions.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SESSION::Total')].VALUE.first()

The number of active user sessions.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SESSION::Active User')].VALUE.first()

⛔️ON_FAIL: CUSTOM_VALUE -> 0

The number of active background sessions.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SESSION::Active Background')].VALUE.first()

⛔️ON_FAIL: CUSTOM_VALUE -> 0

The number of inactive user sessions.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SESSION::Inactive User')].VALUE.first()

⛔️ON_FAIL: CUSTOM_VALUE -> 0

The percentage of locked sessions. Locks are mechanisms that prevent destructive interaction between transactions accessing the same resource — either user objects, such as tables and rows or system objects not visible to users, such as shared data structures in memory and data dictionary rows.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SESSION::Lock rate')].VALUE.first()

The count of the prolongedly locked sessions. (You can change the duration of maximum session lock in seconds for a query by {$ORACLE.SESSION.LOCK.MAX.TIME} macro. Default is 600 sec).

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SESSION::Long time locked')].VALUE.first()

The percentage of concurrency. Concurrency is a DB behavior when different transactions request to change the same resource. In the case of modifying data transactions, it sequentially temporarily blocks the right to change the data, the rest of the transactions are waiting for the access. In the case when the access for the resource is locked for a long time, then the concurrency grows (like the transaction queue) and this often has an extremely negative impact on the performance. A high contention value does not indicate the root cause of the problem but is a signal to search for it.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SESSION::Concurrency rate')].VALUE.first()

The number of days before the password of Zabbix account expires.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='USER::Expire password')].VALUE.first()

The number of active serial sessions.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Active Serial Sessions')].VALUE.first()

The number of active parallel sessions.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Active Parallel Sessions')].VALUE.first()

The number of long table scans per second. A table is considered 'long' if the table is not cached and if its high-water mark is greater than five blocks.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Long Table Scans Per Sec')].VALUE.first()

The Structured Query Language (SQL) service response time expressed in seconds.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::SQL Service Response Time')].VALUE.first()

- MULTIPLIER: 0.01

The number of times that users manually issue the ROLLBACK statement or an error occurred during the users' transactions.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::User Rollbacks Per Sec')].VALUE.first()

The total sorts per user call.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Total Sorts Per User Call')].VALUE.first()

The average number of rows per sort for all types of sorts performed.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Rows Per Sort')].VALUE.first()

The number of sorts going to disk per second.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Disk Sort Per Sec')].VALUE.first()

The percentage of sorts (from ORDER BY clauses or index building) that are done to disk vs in-memory.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Memory Sorts Ratio')].VALUE.first()

Wait time - the time that the server process spends waiting for available shared resources to be released by other server processes, such as latches, locks, data buffers, etc.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Database Wait Time Ratio')].VALUE.first()

It is calculated by dividing the total CPU (used by the database) by the Oracle time model statistic DB time.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Database CPU Time Ratio')].VALUE.first()

Used temporary space.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SYS::Temp Space Used')].VALUE.first()

It indicates how much the Program Global Area (PGA) memory is currently consumed by work areas. This number can be used to determine how much memory is consumed by other consumers of the PGA memory (for example, PL/SQL or Java).

Preprocessing:

- JSONPATH: $[?(@.METRIC=='PGA::Total Pga Inuse')].VALUE.first()

The current value of the PGAAGGREGATETARGET initialization parameter. If this parameter is not set, then its value is 0 and automatic management of the PGA memory is disabled.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='PGA::Aggregate Pga Target Parameter')].VALUE.first()

The current amount of the PGA memory allocated by the instance. The Oracle Database attempts to keep this number below the value of the PGAAGGREGATETARGET initialization parameter. However, it is possible for the PGA allocated to exceed that value by a small percentage and for a short period of time when the work area workload is increasing very rapidly or when PGAAGGREGATETARGET is set to a small value.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='PGA::Total Pga Allocated')].VALUE.first()

The number of bytes of the PGA memory in all processes that could be freed back to the operating system.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='PGA::Total Freeable Pga Memory')].VALUE.first()

The maximum size of work area executed in automatic mode.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='PGA::Global Memory Bound')].VALUE.first()

The maximum amount of disk space (in bytes) that the database can use for the Fast Recovery Area (FRA).

Preprocessing:

- JSONPATH: $[?(@.METRIC=='FRA::Space Limit')].VALUE.first()

⛔️ON_FAIL: CUSTOM_VALUE -> 0

The amount of disk space (in bytes) used by FRA files created in the current and all the previous FRAs.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='FRA::Space Used')].VALUE.first()

⛔️ON_FAIL: CUSTOM_VALUE -> 0

The total amount of disk space (in bytes) that can be created by deleting obsolete, redundant, and other low priority files from the FRA.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='FRA::Space Reclaimable')].VALUE.first()

⛔️ON_FAIL: CUSTOM_VALUE -> 0

The number of files in the FRA.

⛔️ONFAIL: CUSTOM_VALUE -> 0

Preprocessing:

- JSONPATH: $[?(@.METRIC=='FRA::Usable Pct')].VALUE.first()

⛔️ON_FAIL: CUSTOM_VALUE -> 0

Preprocessing:

- JSONPATH: $[?(@.METRIC=='FRA::Restore Point')].VALUE.first()

The memory is allocated from the Java pool.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SGA::Java Pool')].VALUE.first()

⛔️ON_FAIL: CUSTOM_VALUE -> 0

The memory is allocated from a large pool.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SGA::Large Pool')].VALUE.first()

⛔️ON_FAIL: CUSTOM_VALUE -> 0

The memory is allocated from a shared pool.

Preprocessing:

- JSONPATH: $[?(@.METRIC=='SGA::Shared Pool')].VALUE.first()

⛔️ON_FAIL: CUSTOM_VALUE -> 0