GCP project ID.

Service account client e-mail.

Service account private key id.

Service account private key data.

A response timeout for an API.

The update interval for the GCP Authorization item, which also equals to the access token regeneration request frequency.

Check the template documentation notes carefully for more details.

The filter to include GCP Compute Engine instances by namespace.

The filter to exclude GCP Compute Engine instances by namespace.

The filter to include GCP Compute Engine instances by zone.

The filter to exclude GCP Compute Engine instances by zone.

The filter to include GCP Cloud SQL MySQL instances by namespace.

The filter to exclude GCP Cloud SQL MySQL instances by namespace.

The filter to include GCP Cloud SQL MySQL instances by zone.

The filter to exclude GCP Cloud SQL MySQL instances by zone.

The filter to include GCP Cloud SQL MySQL instances by type (standalone/replica).

The filter to exclude GCP Cloud SQL MySQL instances by type (standalone/replica).

Set a macro value 'CLOUD_SQL_INSTANCE' to exclude standalone Instances or 'READ_REPLICA_INSTANCE' to exclude read-only Replicas.

The filter to include GCP Cloud SQL PostgreSQL instances by namespace.

The filter to exclude GCP Cloud SQL PostgreSQL instances by namespace.

The filter to include GCP Cloud SQL PostgreSQL instances by zone.

The filter to exclude GCP Cloud SQL PostgreSQL instances by zone.

The filter to include GCP Cloud SQL PostgreSQL instances by type (standalone/replica).

The filter to exclude GCP Cloud SQL PostgreSQL instances by type (standalone/replica).

Set a macro value 'CLOUD_SQL_INSTANCE' to exclude standalone Instances or 'READ_REPLICA_INSTANCE' to exclude read-only Replicas.

The filter to include GCP Cloud SQL MSSQL instances by namespace.

The filter to exclude GCP Cloud SQL MSSQL instances by namespace.

The filter to include GCP Cloud SQL MSSQL instances by zone.

The filter to exclude GCP Cloud SQL MSSQL instances by zone.

The filter to include GCP Cloud SQL MSSQL instances by type (standalone/replica).

The filter to exclude GCP Cloud SQL MSSQL instances by type (standalone/replica).

Set a macro value 'CLOUD_SQL_INSTANCE' to exclude standalone Instances or 'READ_REPLICA_INSTANCE' to exclude read-only Replicas.

The filter to include GCP Compute Engine project quotas by namespace.

The filter to exclude GCP Compute Engine project quotas by namespace.

GCP Compute Engine project quota warning utilization threshold.

GCP Compute Engine project quota critical quota utilization threshold.

Google Cloud Platform REST authorization with service account authentication parameters and temporary-generated RSA-based JWT-token usage.

The necessary scopes are pre-defined.

Returns a signed authorization token with 1 hour lifetime; it is required only once, and is used for all the dependent script items.

Check the template documentation for the details.

Get GCP Compute Engine instances.

Preprocessing

• JavaScript: The text is too long. Please see the template.

A list of errors from API requests.

Preprocessing

• JSON Path: $.error

  ⛔️Custom on fail: Set value to: ``

GCP Cloud SQL: Instances get.

Preprocessing

• JavaScript: The text is too long. Please see the template.

GCP Cloud SQL instances total count.

Preprocessing

• JSON Path: $.[*].length()

GCP Cloud SQL MSSQL instances count.

Preprocessing

• JSON Path: $[?(@.db_type =~ 'SQLSERVER')].length()

  ⛔️Custom on fail: Discard value

GCP Cloud SQL MySQL instances count.

Preprocessing

• JSON Path: $[?(@.db_type =~ 'MYSQL')].length()

  ⛔️Custom on fail: Discard value

GCP Cloud SQL PostgreSQL instances count.

Preprocessing

• JSON Path: $[?(@.db_type =~ 'POSTGRES')].length()

  ⛔️Custom on fail: Discard value

GCP Compute Engine instances total count.

Preprocessing

• JSON Path: $.[*].length()

  ⛔️Custom on fail: Discard value

GCP Compute Engine: Regular instances count.

Preprocessing

• JSON Path: $[?(@.i_type == 'regular')].length()

  ⛔️Custom on fail: Discard value

GCP Compute Engine: count of instances with Container-Optimized OS used.

Preprocessing

• JSON Path: $[?(@.i_type == 'container-optimized')].length()

  ⛔️Custom on fail: Discard value

GCP Compute Engine resource quotas available for the particular project.

Preprocessing

• JavaScript: The text is too long. Please see the template.

GCP: Authorization has failed.
Check the authorization parameters and GCP API availability from a network segment, where Zabbix-server/proxy is located.

GCP Compute Engine: Instances discovery.

Preprocessing

• Discard unchanged with heartbeat: 3h

GCP Cloud SQL: PostgreSQL instances discovery.

Preprocessing

• Discard unchanged with heartbeat: 3h

GCP Cloud SQL: MSSQL instances discovery.

Preprocessing

• Discard unchanged with heartbeat: 3h

GCP Cloud SQL: MySQL instances discovery.

Preprocessing

• Discard unchanged with heartbeat: 3h

GCP Compute Engine: Quotas discovery.

Preprocessing

• Discard unchanged with heartbeat: 3h

GCP Compute Engine: Get metrics for [{#GCE.QUOTA.NAME}] quota.

Preprocessing

• JSON Path: $[?(@.metric == "{#GCE.QUOTA.NAME}")].first()

GCP Compute Engine: The current usage value for [{#GCE.QUOTA.NAME}] quota.

Preprocessing

• JSON Path: $.usage

GCP Compute Engine: The current limit value for [{#GCE.QUOTA.NAME}] quota.

Preprocessing

• JSON Path: $.limit

GCP Compute Engine: Percentage usage for [{#GCE.QUOTA.NAME}] quota.

Preprocessing

• Check for not supported value

  ⛔️Custom on fail: Discard value

• JSON Path: $.p_used

GCP Compute Engine: The limit for the {#GCE.QUOTA.NAME} quota has been changed.

GCP Compute Engine: The usage percentage for the {#GCE.QUOTA.NAME} quota is close to reaching the limit.

• GCP Compute Engine: Quota [{#GCE.QUOTA.NAME}] usage is critically close to reaching the limit

GCP Compute Engine: The usage percentage for the {#GCE.QUOTA.NAME} quota is critically close to reaching the limit.

A response timeout for an API.

Time interval for the data requests.

Supported usage type:

1. The default update interval for most of the items.

2. The minimal time window for the data requested in the Monitoring Query Language REST API request.

The filter to include GCP Compute Engine disks by namespace.

The filter to exclude GCP Compute Engine disks by namespace.

The filter to include GCP Compute Engine disks by device type.

The filter to exclude GCP Compute Engine disks by device type.

The filter to include GCP Compute Engine disks by storage type.

The filter to exclude GCP Compute Engine disks by storage type.

GCP Compute Engine instance CPU utilization threshold.

GCP Compute Engine instance RAM utilization threshold.

GCP Compute Engine metrics get in raw format.

Preprocessing

• Check for not supported value

  ⛔️Custom on fail: Discard value

Count of incoming packets dropped by the firewall.

Preprocessing

• JSON Path: $.dropped_packets_count

Count of incoming bytes dropped by the firewall.

Preprocessing

• JSON Path: $.dropped_bytes_count

Number of vCPUs visible inside the guest.

For many GCE machine types, the number of vCPUs visible inside the guest is equal to the compute.googleapis.com/instance/cpu/reserved_cores metric.

For shared-core machine types, the number of guest-visible vCPUs differs from the number of reserved cores.

For example, e2-small instances have two vCPUs visible inside the guest and 0.5 fractional vCPUs reserved.

Therefore, for an e2-small instance, compute.googleapis.com/instance/cpu/guest_visible_vcpus has a value of 2 and compute.googleapis.com/instance/cpu/reserved_cores has a value of 0.5.

Preprocessing

• JSON Path: $.guest_visible_vcpus

Number of vCPUs reserved on the host of the instance.

Preprocessing

• JSON Path: $.reserved_cores

Wait time is the time a vCPU is ready to run, but unexpectedly not scheduled to run.

The wait time returned here is the accumulated value for all vCPUs.

The time interval for which the value was measured is returned by Monitoring in whole seconds as start_time and end_time.

This metric is only available for VMs that belong to the e2 family or to overcommitted VMs on sole-tenant nodes.

Preprocessing

• JSON Path: $.scheduler_wait_time

  ⛔️Custom on fail: Discard value

Delta vCPU usage for all vCPUs, in vCPU-seconds.

To compute the per-vCPU utilization fraction, divide this value by (end-start)*N, where end and start define this value's time interval and N is compute.googleapis.com/instance/cpu/reserved_cores at the end of the interval.

This value is reported by the hypervisor for the VM and can differ from agent.googleapis.com/cpu/usage_time, which is reported from inside the VM.

Preprocessing

• JSON Path: $.usage_time

Fractional utilization of allocated CPU on this instance.

This metric is reported by the hypervisor for the VM and can differ from agent.googleapis.com/cpu/utilization, which is reported from inside the VM.

Preprocessing

• JSON Path: $.utilization

• Custom multiplier: 100

Total VM memory size.

This metric is only available for VMs that belong to the e2 family; returns empty value for different instance types.

Preprocessing

• JSON Path: $.ram_size

  ⛔️Custom on fail: Discard value

Memory currently used in the VM.

This metric is only available for VMs that belong to the e2 family; returns empty value for different instance types.

Preprocessing

• JSON Path: $.ram_used

  ⛔️Custom on fail: Discard value

Memory usage Percentage.

This metric is only available for VMs that belong to the e2 family; returns empty value for different instance types.

Preprocessing

• JSON Path: $.ram_pused

  ⛔️Custom on fail: Discard value

The amount of memory read into the guest from its own swap space.

This metric is only available for VMs that belong to the e2 family; returns empty value for different instance types.

Preprocessing

• JSON Path: $.swap_in_bytes_count

  ⛔️Custom on fail: Discard value

The amount of memory written from the guest to its own swap space.

This metric is only available for VMs that belong to the e2 family; returns empty value for different instance types.

Preprocessing

• JSON Path: $.swap_out_bytes_count

  ⛔️Custom on fail: Discard value

Count of bytes received from the network without load-balancing.

Preprocessing

• JSON Path: $.received_bytes_count.false

Whether traffic was received by an L3 loadbalanced IP address assigned to the VM.

Traffic that is externally routed to the VM's standard internal or external IP address, such as L7 loadbalanced traffic, is not considered to be loadbalanced in this metric.

The value is empty when load-balancing is not used.

Preprocessing

• JSON Path: $.received_bytes_count.true

  ⛔️Custom on fail: Discard value

Count of packets received from the network without load-balancing.

Preprocessing

• JSON Path: $.received_packets_count.false

Whether traffic was received by an L3 loadbalanced IP address assigned to the VM.

Traffic that is externally routed to the VM's standard internal or external IP address, such as L7 loadbalanced traffic, is not considered to be loadbalanced in this metric.

The value is empty when load-balancing is not used.

Preprocessing

• JSON Path: $.received_packets_count.true

  ⛔️Custom on fail: Discard value

Count of bytes sent over the network without load-balancing.

Preprocessing

• JSON Path: $.sent_bytes_count.false

Whether traffic was received by an L3 loadbalanced IP address assigned to the VM.

Traffic that is externally routed to the VM's standard internal or external IP address, such as L7 loadbalanced traffic, is not considered to be loadbalanced in this metric.

The value is empty when load-balancing is not used.

Preprocessing

• JSON Path: $.sent_bytes_count.true

  ⛔️Custom on fail: Discard value

Count of packets sent over the network without load-balancing.

Preprocessing

• JSON Path: $.sent_packets_count.false

Whether traffic was received by an L3 loadbalanced IP address assigned to the VM.

Traffic that is externally routed to the VM's standard internal or external IP address, such as L7 loadbalanced traffic, is not considered to be loadbalanced in this metric.

The value is empty when load-balancing is not used.

Preprocessing

• JSON Path: $.sent_packets_count.true

  ⛔️Custom on fail: Discard value

The count of mirrored bytes.

Preprocessing

• JSON Path: $.mirrored_bytes_count

The count of mirrored packets.

Preprocessing

• JSON Path: $.mirrored_packets_count

The count of mirrored packets dropped.

Reason - out of quota.

Preprocessing

• JSON Path: $.out_of_quota

The count of mirrored packets dropped.

Reason - unknown.

Preprocessing

• JSON Path: $.unknown

The count of mirrored packets dropped.

Reason - invalid.

Preprocessing

• JSON Path: $.invalid

The validation status of early boot integrity policy.

Empty value if integrity monitoring isn't enabled.

Preprocessing

• JSON Path: $.early_boot_validation_status

  ⛔️Custom on fail: Discard value

• JavaScript: The text is too long. Please see the template.

The validation status of late boot integrity policy.

Empty value if integrity monitoring isn't enabled.

Preprocessing

• JSON Path: $.late_boot_validation_status

  ⛔️Custom on fail: Discard value

• JavaScript: The text is too long. Please see the template.

Elapsed time since the VM was started, in seconds.

Preprocessing

• JSON Path: $.uptime_total

GCP Compute Engine instance state.

Preprocessing

• JSON Path: $.status

  ⛔️Custom on fail: Set value to: 10

• JavaScript: The text is too long. Please see the template.

• Discard unchanged with heartbeat: 10m

Disk entities and metrics related to a particular instance.

Preprocessing

• Check for not supported value

  ⛔️Custom on fail: Discard value

The CPU utilization is too high. The system might be slow to respond.

RAM utilization is too high. The system might be slow to respond.

The VM is in a suspended state. You can resume the VM or delete it.

The VM is being repaired.
Repairing occurs when the VM encounters an internal error or the underlying machine is unavailable due to maintenance.
During this time, the VM is unusable.

The VM is stopped. You stopped the VM, or the VM encountered a failure.

Failed to get the instance state.
Check access permissions to GCP API or service account.

GCP Compute Engine: Physical disks discovery.

Preprocessing

• Discard unchanged with heartbeat: 3h

Data in raw format for the disk with the name [{#GCE.DISK.NAME}].

Preprocessing

• JSON Path: $[?(@.disk_name == "{#GCE.DISK.NAME}")].metrics.first()

Count of bytes read from [{#GCE.DISK.NAME}] disk.

Preprocessing

• JSON Path: $.read_bytes_count

Count of read IO operations from [{#GCE.DISK.NAME}] disk.

Preprocessing

• JSON Path: $.read_ops_count

Count of bytes written to {#GCE.DISK.NAME}] disk.

Preprocessing

• JSON Path: $.write_bytes_count

Count of write IO operations to [{#GCE.DISK.NAME}] disk.

Preprocessing

• JSON Path: $.write_ops_count

A response timeout for an API.

Time interval for the data requests.

Supported usage type:

1. The default update interval for most of the items.

2. The minimal time window for the data requested in the Monitoring Query Language REST API request.

GCP Cloud SQL MySQL instance warning disk usage threshold.

GCP Cloud SQL MySQL instance critical disk usage threshold.

GCP Cloud SQL MySQL instance CPU usage threshold.

GCP Cloud SQL MySQL instance RAM usage threshold.

MySQL metrics in raw format.

Preprocessing

• Check for not supported value

  ⛔️Custom on fail: Discard value

Number of cores reserved for the database.

Preprocessing

• JSON Path: $.base_reserved_cores

Cumulative CPU usage time in seconds.

Preprocessing

• JSON Path: $.base_usage_time

Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.

Preprocessing

• JSON Path: $.base_utilization

• Custom multiplier: 100

Maximum data disk size in bytes.

Preprocessing

• JSON Path: $.mysql_quota

Data utilization in bytes.

Preprocessing

• JSON Path: $.mysql_bytes_used

Delta count of data disk read I/O operations.

Preprocessing

• JSON Path: $.base_read_ops_count

Delta count of data disk write I/O operations.

Preprocessing

• JSON Path: $.base_write_ops_count

The fraction of the disk quota that is currently in use.

Shown as percentage.

Preprocessing

• JSON Path: $.mysql_utilization

• Custom multiplier: 100

Maximum RAM size in bytes.

Preprocessing

• JSON Path: $.base_quota

Total RAM usage in bytes.

This metric reports the RAM usage of the database process, including the buffer/cache.

Preprocessing

• JSON Path: $.base_total_usage

The RAM usage in bytes.

This metric reports the RAM usage of the server, excluding the buffer/cache.

Preprocessing

• JSON Path: $.base_usage

The fraction of the memory quota that is currently in use.

Shown as percentage.

Preprocessing

• JSON Path: $.base_ram_pused

Delta count of bytes received through the network.

Preprocessing

• JSON Path: $.base_received_bytes_count

Delta count of bytes sent through the network.

Preprocessing

• JSON Path: $.base_sent_bytes_count

Number of connections to the databases on the Cloud SQL instance.

Preprocessing

• JSON Path: $.base_connections

GCP Cloud SQL MySQL Current instance state.

Preprocessing

• JSON Path: $.timeSeriesData[0].pointData[0].values[0].stringValue

  ⛔️Custom on fail: Set value to: 10

• JavaScript: The text is too long. Please see the template.

• Discard unchanged with heartbeat: 10m

GCP Cloud SQL MySQL DB Engine State.

Preprocessing

• Check for not supported value

  ⛔️Custom on fail: Discard value

• JSON Path: $.timeSeriesData[0].pointData[0].values[0].int64Value

  ⛔️Custom on fail: Discard value

• Discard unchanged with heartbeat: 10m

Number of unflushed pages in the InnoDB buffer pool.

Preprocessing

• JSON Path: $.mysql_innodb_buffer_pool_pages_dirty

Number of unused pages in the InnoDB buffer pool.

Preprocessing

• JSON Path: $.mysql_innodb_buffer_pool_pages_free

Total number of pages in the InnoDB buffer pool.

Preprocessing

• JSON Path: $.mysql_innodb_buffer_pool_pages_total

Delta count of InnoDB fsync() calls.

Preprocessing

• JSON Path: $.mysql_innodb_data_fsyncs

Delta count of InnoDB fsync() calls to the log file.

Preprocessing

• JSON Path: $.mysql_innodb_os_log_fsyncs

Delta count of InnoDB pages read.

Preprocessing

• JSON Path: $.mysql_innodb_pages_read

Delta count of InnoDB pages written.

Preprocessing

• JSON Path: $.mysql_innodb_pages_written

The number of tables that are currently open.

Preprocessing

• JSON Path: $.mysql_open_tables

The number of table definitions that are currently cached.

Preprocessing

• JSON Path: $.mysql_open_table_definitions

Delta of statements executed by the server.

Preprocessing

• JSON Path: $.mysql_queries

Delta of statements executed by the server sent by the client.

Preprocessing

• JSON Path: $.mysql_questions

Delta count of bytes received by MySQL process.

Preprocessing

• JSON Path: $.mysql_received_bytes_count

Delta count of bytes sent by MySQL process.

Preprocessing

• JSON Path: $.mysql_sent_bytes_count

The CPU utilization is too high. The system might be slow to respond.

High utilization of the storage space.

• GCP Cloud SQL MySQL: Disk space is critically low

Critical utilization of the disk space.

RAM utilization is too high. The system might be slow to respond.

The instance is in suspended state.
It is not available, for example, due to problems with billing.

The instance has been stopped by the owner.
It is not currently running, but it's ready to be restarted.

The instance is down for maintenance.

The instance creation failed, or an operation left the instance in an own bad state.

The state of the instance is unknown.

Failed to get the instance state.
Check access permissions to GCP API or service account.

Database engine is down.
If an instance experiences unplanned (non-maintenance) downtime, the instance state will still be RUNNING, but the database engine state metric will report 0.

• GCP Cloud SQL MySQL: Instance is stopped by the owner
• GCP Cloud SQL MySQL: Instance is in suspended state
• GCP Cloud SQL MySQL: Instance is in maintenance
• GCP Cloud SQL MySQL: Instance is in failed state
• GCP Cloud SQL MySQL: Instance is in unknown state
• GCP Cloud SQL MySQL: Failed to get the instance state

A response timeout for an API.

Time interval for the data requests.

Supported usage type:

1. The default update interval for most of the items.

2. The minimal time window for the data requested in the Monitoring Query Language REST API request.

MySQL replication metrics data in raw format.

Preprocessing

• Check for not supported value

  ⛔️Custom on fail: Discard value

The error number of the most recent error that caused the I/O thread to stop.

Preprocessing

• JSON Path: $.last_io_errno

The error number of the most recent error that caused the SQL thread to stop.

Preprocessing

• JSON Path: $.last_sql_errno

Number of seconds the read replica is behind its primary (approximation).

Preprocessing

• JSON Path: $.replica_lag

Indicates time taken from primary binary log to IO thread on replica.

Preprocessing

• JSON Path: $.network_lag

The current serving state of replication.

This metric is only available for the MySQL/PostgreSQL instances.

Preprocessing

• JSON Path: $.state

• JavaScript: The text is too long. Please see the template.

Indicates whether the I/O thread for reading the primary's binary log is running.

Possible values are Yes, No and Connecting.

Preprocessing

• JSON Path: $.slave_io_running

• JavaScript: The text is too long. Please see the template.

Indicates whether the SQL thread for executing events in the relay log is running.

Preprocessing

• JSON Path: $.slave_sql_running

• Boolean to decimal

A response timeout for an API.

Time interval for the data requests.

Supported usage type:

1. The default update interval for most of the items.

2. The minimal time window for the data requested in the Monitoring Query Language REST API request.

The filter to include GCP Cloud SQL PostgreSQL databases by namespace.

The filter to exclude GCP Cloud SQL PostgreSQL databases by namespace.

GCP Cloud SQL PostgreSQL instance warning disk usage threshold.

GCP Cloud SQL PostgreSQL instance critical disk usage threshold.

GCP Cloud SQL PostgreSQL instance CPU usage threshold.

GCP Cloud SQL PostgreSQL instance RAM usage threshold.

PostgreSQL metrics data in raw format.

Preprocessing

• Check for not supported value

  ⛔️Custom on fail: Discard value

Number of cores reserved for the database.

Preprocessing

• JSON Path: $.base_reserved_cores

Cumulative CPU usage time in seconds.

Preprocessing

• JSON Path: $.base_usage_time

Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.

Preprocessing

• JSON Path: $.base_utilization

• Custom multiplier: 100

Maximum data disk size in bytes.

Preprocessing

• JSON Path: $.pgsql_quota

Data utilization in bytes.

Preprocessing

• JSON Path: $.pgsql_bytes_used

Delta count of data disk read I/O operations.

Preprocessing

• JSON Path: $.base_read_ops_count

Delta count of data disk write I/O operations.

Preprocessing

• JSON Path: $.base_write_ops_count

The fraction of the disk quota that is currently in use.

Shown as percentage.

Preprocessing

• JSON Path: $.pgsql_utilization

• Custom multiplier: 100

Maximum RAM size in bytes.

Preprocessing

• JSON Path: $.base_quota

Total RAM usage in bytes.

This metric reports the RAM usage of the database process, including the buffer/cache.

Preprocessing

• JSON Path: $.base_total_usage

The RAM usage in bytes.

This metric reports the RAM usage of the server, excluding the buffer/cache.

Preprocessing

• JSON Path: $.base_usage

The fraction of the memory quota that is currently in use.

Shown as percentage.

Preprocessing

• JSON Path: $.base_ram_pused

Delta count of bytes received through the network.

Preprocessing

• JSON Path: $.base_received_bytes_count

Delta count of bytes sent through the network.

Preprocessing

• JSON Path: $.base_sent_bytes_count

GCP Cloud SQL PostgreSQL Current instance state.

Preprocessing

• JSON Path: $.timeSeriesData[0].pointData[0].values[0].stringValue

  ⛔️Custom on fail: Set value to: 10

• JavaScript: The text is too long. Please see the template.

• Discard unchanged with heartbeat: 10m

GCP Cloud SQL PostgreSQL DB Engine State.

Preprocessing

• Check for not supported value

  ⛔️Custom on fail: Discard value

• JSON Path: $.timeSeriesData[0].pointData[0].values[0].int64Value

  ⛔️Custom on fail: Discard value

• Discard unchanged with heartbeat: 10m

Current utilization represented as a percentage of transaction IDs consumed by the Cloud SQL PostgreSQL instance.

Preprocessing

• JSON Path: $.pgsql_transaction_id_utilization

• Custom multiplier: 100

Delta count of assigned transaction IDs.

Preprocessing

• JSON Path: $.pgsql_assigned

Delta count of frozen transaction IDs.

Preprocessing

• JSON Path: $.pgsql_frozen

Total data size (in bytes) written to temporary files by the queries.

Preprocessing

• JSON Path: $.pgsql_temp_bytes_written_count

Total number of temporary files used for writing data while performing algorithms such as join and sort.

Preprocessing

• JSON Path: $.pgsql_temp_files_written_count

Age of the oldest running transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction.

Empty value when there is no such transaction type.

Preprocessing

• JSON Path: $.pgsql_running

  ⛔️Custom on fail: Discard value

Age of the oldest prepared transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction.

Empty value when there is no such transaction type.

Preprocessing

• JSON Path: $.pgsql_prepared

  ⛔️Custom on fail: Discard value

Age of the oldest replication slot transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction.

Empty value when there is no such transaction type.

Preprocessing

• JSON Path: $.pgsql_replication_slot

  ⛔️Custom on fail: Discard value

Age of the oldest replica transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction.

Empty value when there is no such transaction type.

Preprocessing

• JSON Path: $.pgsql_replica

  ⛔️Custom on fail: Discard value

The number of the connections to the Cloud SQL PostgreSQL instance.

Includes connections to the system databases, which aren't visible by default.

Preprocessing

• JSON Path: $.pgsql_num_backends

The CPU utilization is too high. The system might be slow to respond.

High utilization of the storage space.

• GCP Cloud SQL PostgreSQL: Disk space is critically low

Critical utilization of the disk space.

RAM utilization is too high. The system might be slow to respond.

The instance is in suspended state.
It is not available, for example, due to problems with billing.

The instance has been stopped by the owner.
It is not currently running, but it's ready to be restarted.

The instance is down for maintenance.

The instance creation failed, or an operation left the instance in an own bad state.

The state of the instance is unknown.

Failed to get the instance state.
Check access permissions to GCP API or service account.

Database engine is down.
If an instance experiences unplanned (non-maintenance) downtime, the instance state will still be RUNNING, but the database engine state metric will report 0.

• GCP Cloud SQL PostgreSQL: Instance is stopped by the owner
• GCP Cloud SQL PostgreSQL: Instance is in suspended state
• GCP Cloud SQL PostgreSQL: Instance is in maintenance
• GCP Cloud SQL PostgreSQL: Instance is in failed state
• GCP Cloud SQL PostgreSQL: Instance is in unknown state
• GCP Cloud SQL PostgreSQL: Failed to get the instance state

Databases discovery for the particular PostgreSQL instance.

Preprocessing

• JSON Path: $.items

• Discard unchanged with heartbeat: 3h

PostgreSQL metrics in raw format.

Preprocessing

• Check for not supported value

  ⛔️Custom on fail: Discard value

Number of deadlocks detected in the [{#PGSQL.DB.NAME}] database.

Preprocessing

• JSON Path: $.deadlock_count

Total number of rows scanned while processing the queries of the [{#PGSQL.DB.NAME}] database.

Preprocessing

• JSON Path: $.tuples_returned_count

Total number of rows fetched as a result of queries to the [{#PGSQL.DB.NAME}] database.

Preprocessing

• JSON Path: $.tuples_fetched_count

Delta count of number of committed transactions to the [{#PGSQL.DB.NAME}] database.

Preprocessing

• JSON Path: $.commit

Delta count of number of rolled-back transactions in the [{#PGSQL.DB.NAME}] database.

Preprocessing

• JSON Path: $.rollback

Number of buffer cache blocks read by the [{#PGSQL.DB.NAME}] database.

Preprocessing

• JSON Path: $.buffer_cache

Number of disk blocks read by the [{#PGSQL.DB.NAME}] database.

Preprocessing

• JSON Path: $.disk

Number of tuples(rows) processed for insert operations for the database with the name [{#PGSQL.DB.NAME}].

Preprocessing

• JSON Path: $.insert

Number of tuples(rows) processed for delete operations for the database with the name [{#PGSQL.DB.NAME}].

Preprocessing

• JSON Path: $.delete

Number of tuples(rows) processed for update operations for the database with the name [{#PGSQL.DB.NAME}].

Preprocessing

• JSON Path: $.update

Number of live tuples(rows) in the [{#PGSQL.DB.NAME}] database.

Preprocessing

• JSON Path: $.live

Number of live tuples(rows) in the [{#PGSQL.DB.NAME}] database.

Preprocessing

• JSON Path: $.dead

A response timeout for an API.

Time interval for the data requests.

Supported usage type:

1. The default update interval for most of the items.

2. The minimal time window for the data requested in the Monitoring Query Language REST API request.

PostgreSQL replica metrics data in raw format.

Preprocessing

• Check for not supported value

  ⛔️Custom on fail: Discard value

Indicates time taken from primary binary log to IO thread on replica.

Preprocessing

• JSON Path: $.network_lag

Number of seconds the read replica is behind its primary (approximation).

Preprocessing

• JSON Path: $.replica_lag

The current serving state of replication.

This metric is only available for the MySQL/PostgreSQL instances.

Preprocessing

• JSON Path: $.state

• JavaScript: The text is too long. Please see the template.

Replay location replication lag in bytes.

Preprocessing

• JSON Path: $.replay_location

Write location replication lag in bytes.

Preprocessing

• JSON Path: $.write_location

Flush location replication lag in bytes.

Preprocessing

• JSON Path: $.flush_location

Sent location replication lag in bytes.

Preprocessing

• JSON Path: $.sent_location

Number of failed attempts for archiving replication log files.

Preprocessing

• JSON Path: $.log_archive_failure_count

Number of failed attempts for archiving replication log files.

Preprocessing

• JSON Path: $.log_archive_success_count

A response timeout for an API.

Time interval for the data requests.

Supported usage type:

1. The default update interval for most of the items.

2. The minimal time window for the data requested in the Monitoring Query Language REST API request.

The filter to include GCP Cloud SQL MSSQL resources by namespace.

The filter to exclude GCP Cloud SQL MSSQL resources by namespace.

The filter to include GCP Cloud SQL MSSQL databases by namespace.

The filter to exclude GCP Cloud SQL MSSQL databases by namespace.

The filter to include GCP Cloud SQL MSSQL schedulers by namespace.

The filter to exclude GCP Cloud SQL MSSQL schedulers by namespace.

GCP Cloud SQL MSSQL instance warning disk usage threshold.

GCP Cloud SQL MSSQL instance critical disk usage threshold.

GCP Cloud SQL MSSQL instance CPU usage threshold.

GCP Cloud SQL MSSQL instance RAM usage threshold.

MSSQL metrics data in raw format.

Preprocessing

• Check for not supported value

  ⛔️Custom on fail: Discard value

Number of cores reserved for the database.

Preprocessing

• JSON Path: $.base_reserved_cores

Cumulative CPU usage time in seconds.

Preprocessing

• JSON Path: $.base_usage_time

Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.

Preprocessing

• JSON Path: $.base_utilization

• Custom multiplier: 100

Maximum data disk size in bytes.

Preprocessing

• JSON Path: $.mssql_quota

Data utilization in bytes.

Preprocessing

• JSON Path: $.mssql_bytes_used

Delta count of data disk read I/O operations.

Preprocessing

• JSON Path: $.base_read_ops_count

Delta count of data disk write I/O operations.

Preprocessing

• JSON Path: $.base_write_ops_count

The fraction of the disk quota that is currently in use.

Shown as percentage.

Preprocessing

• JSON Path: $.mssql_utilization

• Custom multiplier: 100

Maximum RAM size in bytes.

Preprocessing

• JSON Path: $.base_quota

Total RAM usage in bytes.

This metric reports the RAM usage of the database process, including the buffer/cache.

Preprocessing

• JSON Path: $.base_total_usage

The RAM usage in bytes.

This metric reports the RAM usage of the server, excluding the buffer/cache.

Preprocessing

• JSON Path: $.base_usage

The fraction of the memory quota that is currently in use.

Shown as percentage.

Preprocessing

• JSON Path: $.base_ram_pused

Delta count of bytes received through the network.

Preprocessing

• JSON Path: $.base_received_bytes_count

Delta count of bytes sent through the network.

Preprocessing

• JSON Path: $.base_sent_bytes_count

Number of connections to the databases on the Cloud SQL instance.

Preprocessing

• JSON Path: $.base_connections

GCP Cloud SQL MSSQL Current instance state.

Preprocessing

• JSON Path: $.timeSeriesData[0].pointData[0].values[0].stringValue

  ⛔️Custom on fail: Set value to: 10

• JavaScript: The text is too long. Please see the template.

• Discard unchanged with heartbeat: 10m

GCP Cloud SQL MSSQL DB Engine State.

Preprocessing

• Check for not supported value

  ⛔️Custom on fail: Discard value

• JSON Path: $.timeSeriesData[0].pointData[0].values[0].int64Value

  ⛔️Custom on fail: Discard value

• Discard unchanged with heartbeat: 10m

Total number of login operations started from the connection pool since the last restart of SQL Server service.

Preprocessing

• JSON Path: $.mssql_connection_reset_count

Total number of login attempts since the last restart of SQL Server service.

This does not include pooled connections.

Preprocessing

• JSON Path: $.mssql_login_attempt_count

Total number of logout operations since the last restart of SQL Server service.

Preprocessing

• JSON Path: $.mssql_logout_count

Current number of blocked processes.

Preprocessing

• JSON Path: $.mssql_processes_blocked

Current percentage of pages found in the buffer cache without having to read from disk.

The ratio is the total number of cache hits divided by the total number of cache lookups.

Preprocessing

• JSON Path: $.mssql_buffer_cache_hit_ratio

Total number of pages flushed to disk by a checkpoint or other operation that requires all dirty pages to be flushed.

Preprocessing

• JSON Path: $.mssql_checkpoint_page_count

Total number of requests that had to wait for a free page.

Preprocessing

• JSON Path: $.mssql_free_list_stall_count

Total number of buffers written by the buffer manager's lazy writer.

The lazy writer is a system process that flushes out batches of dirty, aged buffers

(buffers that contain changes that must be written back to disk before the buffer can be reused for a different page)

and makes them available to user processes.

Preprocessing

• JSON Path: $.mssql_lazy_write_count

Current number of processes waiting for a workspace memory grant.

Preprocessing

• JSON Path: $.mssql_memory_grants_pending

Current number of seconds a page will stay in the buffer pool without references.

Preprocessing

• JSON Path: $.mssql_page_life_expectancy

Total number of Transact-SQL command batches received.

Preprocessing

• JSON Path: $.mssql_batch_request_count

Total number of records fetched through forwarded record pointers.

Preprocessing

• JSON Path: $.mssql_forwarded_record_count

Total number of unrestricted full scans.

These can be either base-table or full-index scans.

Preprocessing

• JSON Path: $.mssql_full_scan_count

Total number of page splits that occur as the result of overflowing index pages.

Preprocessing

• JSON Path: $.mssql_page_split_count

Total number of probe scans that are used to find at least one single qualified row in an index or base table directly.

Preprocessing

• JSON Path: $.mssql_probe_scan_count

Total number of SQL compilations.

Preprocessing

• JSON Path: $.mssql_sql_compilation_count

Total number of SQL recompilations.

Preprocessing

• JSON Path: $.mssql_sql_recompilation_count

Total number of physical database page reads.

This metric counts physical page reads across all databases.

Preprocessing

• JSON Path: $.mssql_read

Total number of physical database page writes.

This metric counts physical page writes across all databases.

Preprocessing

• JSON Path: $.mssql_write

Tracks the size in bytes of stored SQLServer audit files on an instance.

Empty value if there are no audits enabled.

Preprocessing

• JSON Path: $.base_audits_size

  ⛔️Custom on fail: Discard value

Tracks the size in bytes of stored SQLServer audit files on an instance.

Empty value if there are no audits enabled.

Preprocessing

• JSON Path: $.mssql_success

  ⛔️Custom on fail: Discard value

MSSQL resources data in raw format.

Preprocessing

• Check for not supported value

  ⛔️Custom on fail: Discard value

MSSQL databases data in raw format.

Preprocessing

• Check for not supported value

  ⛔️Custom on fail: Discard value

MSSQL schedulers data in raw format.

Preprocessing

• Check for not supported value

  ⛔️Custom on fail: Discard value

The CPU utilization is too high. The system might be slow to respond.

High utilization of the storage space.

• GCP Cloud SQL MSSQL: Disk space is critically low

Critical utilization of the disk space.

RAM utilization is too high. The system might be slow to respond.

The instance is in suspended state.
It is not available, for example, due to problems with billing.

The instance has been stopped by the owner.
It is not currently running, but it's ready to be restarted.

The instance is down for maintenance.

The instance creation failed, or an operation left the instance in an own bad state.

The state of the instance is unknown.

Failed to get the instance state.
Check access permissions to GCP API or service account.

Database engine is down.
If an instance experiences unplanned (non-maintenance) downtime, the instance state will still be RUNNING, but the database engine state metric will report 0.

• GCP Cloud SQL MSSQL: Instance is stopped by the owner
• GCP Cloud SQL MSSQL: Instance is in suspended state
• GCP Cloud SQL MSSQL: Instance is in maintenance
• GCP Cloud SQL MSSQL: Instance is in failed state
• GCP Cloud SQL MSSQL: Instance is in unknown state
• GCP Cloud SQL MSSQL: Failed to get the instance state

Resources discovery.

Preprocessing

• Discard unchanged with heartbeat: 3h

Data in raw format for the [{#RESOURCE.NAME}] resource.

Preprocessing

• JSON Path: $[?(@.resource == "{#RESOURCE.NAME}")].metrics.first()

Total number of lock requests that resulted in a deadlock for the [{#RESOURCE.NAME}] resource.

Preprocessing

• JSON Path: $.deadlock_count

Total number of lock requests that required the caller to wait for the [{#RESOURCE.NAME}] resource.

Preprocessing

• JSON Path: $.lock_wait_count

Total time lock requests were waiting for locks for the [{#RESOURCE.NAME}] resource.

Preprocessing

• JSON Path: $.lock_wait_time

Databases discovery.

Preprocessing

• Discard unchanged with heartbeat: 3h

Data in raw format for the [{#DB.NAME}] database.

Preprocessing

• JSON Path: $[?(@.database == "{#DB.NAME}")].metrics.first()

Total number of log bytes flushed for the [{#DB.NAME}] database.

Preprocessing

• JSON Path: $.log_bytes_flushed_count

Total number of transactions started for the [{#DB.NAME}] database.

Preprocessing

• JSON Path: $.transaction_count

Schedulers discovery.

Preprocessing

• Discard unchanged with heartbeat: 3h

Data in raw format associated with the scheduler that goes by its ID [{#SCHEDULER.ID}].

Preprocessing

• JSON Path: $[?(@.scheduler == "{#SCHEDULER.ID}")].metrics.first()

Current number of active workers associated with the scheduler that goes by its ID [{#SCHEDULER.ID}].

An active worker is never preemptive, must have an associated task, and is either running, runnable, or suspended.

Preprocessing

• JSON Path: $.active_workers

Current number of present tasks associated with the scheduler that goes by its ID [{#SCHEDULER.ID}].

This count includes tasks that are waiting for a worker to execute them and tasks that are currently waiting or running (in SUSPENDED or RUNNABLE state).

Preprocessing

• JSON Path: $.current_tasks

Current number of workers associated with the scheduler that goes by its ID [{#SCHEDULER.ID}].

It includes workers that are not assigned any task.

Preprocessing

• JSON Path: $.current_workers

Current number of pending I/Os waiting to be completed that are associated with the scheduler that goes by its ID [{#SCHEDULER.ID}].

Each scheduler has a list of pending I/Os that are checked to determine whether they have been completed every time there is a context switch.

The count is incremented when the request is inserted.

This count is decremented when the request is completed.

This number does not indicate the state of the I/Os.

Preprocessing

• JSON Path: $.pending_disk_io

Current number of workers that are associated with the scheduler that goes by its ID [{#SCHEDULER.ID}] and have assigned tasks waiting to be scheduled on the runnable queue.

Preprocessing

• JSON Path: $.runnable_tasks

Current number of tasks in the pending queue associated with the scheduler that goes by its ID [{#SCHEDULER.ID}].

These tasks are waiting for a worker to pick them up.

Preprocessing

• JSON Path: $.work_queue

A response timeout for an API.

Time interval for the data requests.

Supported usage type:

1. The default update interval for most of the items.

2. The minimal time window for the data requested in the Monitoring Query Language REST API request.

MSSQL replica metrics data in raw format.

Preprocessing

• Check for not supported value

  ⛔️Custom on fail: Discard value

Total number of bytes sent to the remote availability replica.

For an async replica, returns the number of bytes before compression.

For a sync replica without compression, returns the actual number of bytes.

Preprocessing

• JSON Path: $.bytes_sent_to_replica_count

Total count of Always On messages to resend.

This includes messages that were attempted to be sent but failed and require resending.

Preprocessing

• JSON Path: $.resent_message_count

Current number of log blocks that are waiting to be applied to replica.

Preprocessing

• JSON Path: $.log_apply_pending_queue

Total size of log records received by the replica.

Preprocessing

• JSON Path: $.log_bytes_received_count

Current size of log records in bytes in the replica's log files that have not been redone.

Preprocessing

• JSON Path: $.recovery_queue

• Custom multiplier: 1024

Total size in bytes of redone log records.

Preprocessing

• JSON Path: $.redone_bytes_count