Microsoft Azure DB for PostgreSQL

Overview

Azure Database for PostgreSQL provides fully managed, enterprise-ready community PostgreSQL database as a service.

Get metrics from Azure DB for PostgreSQL to:

  • Visualize the performance of your PostgreSQL databases.
  • Correlate the performance of your PostgreSQL databases with your applications.

Setup

Installation

If you haven’t already, set up the Microsoft Azure integration first. There are no other installation steps that need to be performed.

Data Collected

Metrics

azure.dbforpostgresql_flexibleservers.active_connections
(gauge)		Active Connections
Shown as connection
azure.dbforpostgresql_flexibleservers.backup_storage_used
(gauge)		Backup Storage used
Shown as byte
azure.dbforpostgresql_flexibleservers.connections_failed
(count)		Failed Connections
Shown as connection
azure.dbforpostgresql_flexibleservers.core_count
(gauge)		Core count
azure.dbforpostgresql_flexibleservers.count
(gauge)		The count of Azure DB for PostgreSQL flexible servers resources
azure.dbforpostgresql_flexibleservers.cpu_credits_consumed
(gauge)		Number of CPU credits consumed by the database server
azure.dbforpostgresql_flexibleservers.cpu_credits_remaining
(gauge)		Number of CPU credits available to the database server
azure.dbforpostgresql_flexibleservers.cpu_percent
(gauge)		CPU percent
Shown as percent
azure.dbforpostgresql_flexibleservers.disk_queue_depth
(gauge)		Number of outstanding I/O operations to the disk
azure.dbforpostgresql_flexibleservers.iops
(count)		IO Operations per second
Shown as operation
azure.dbforpostgresql_flexibleservers.maximum_used_transactionids
(gauge)		Maximum used transaction IDs
azure.dbforpostgresql_flexibleservers.memory_percent
(gauge)		Memory percent
Shown as percent
azure.dbforpostgresql_flexibleservers.network_bytes_egress
(count)		Network Out across active connections
Shown as byte
azure.dbforpostgresql_flexibleservers.network_bytes_ingress
(count)		Network In across active connections
Shown as byte
azure.dbforpostgresql_flexibleservers.read_iops
(count)		Read IO Operations per second
Shown as operation
azure.dbforpostgresql_flexibleservers.read_throughput
(count)		Bytes read per second from the disk
Shown as byte
azure.dbforpostgresql_flexibleservers.storage_free
(gauge)		Storage free
Shown as byte
azure.dbforpostgresql_flexibleservers.storage_percent
(gauge)		Storage percent
Shown as percent
azure.dbforpostgresql_flexibleservers.storage_used
(gauge)		Storage used
Shown as byte
azure.dbforpostgresql_flexibleservers.txlogs_storage_used
(gauge)		Transaction log storage used
Shown as byte
azure.dbforpostgresql_flexibleservers.write_iops
(count)		Write IO Operations per second
Shown as operation
azure.dbforpostgresql_flexibleservers.write_throughput
(count)		Bytes written per second from the disk
Shown as byte
azure.dbforpostgresql_servergroups.count
(gauge)		The count of Azure DB for PostgreSQL server groups resources
azure.dbforpostgresql_servers.active_connections
(gauge)		Active Connections
Shown as connection
azure.dbforpostgresql_servers.backup_storage_used
(gauge)		Backup Storage used
Shown as byte
azure.dbforpostgresql_servers.connections_failed
(count)		Failed Connections
Shown as connection
azure.dbforpostgresql_servers.core_count
(gauge)		Core count
azure.dbforpostgresql_servers.count
(gauge)		The count of Azure DB for PostgreSQL resources
azure.dbforpostgresql_servers.cpu_percent
(gauge)		CPU percent
Shown as percent
azure.dbforpostgresql_servers.cpu_percent.max
(gauge)		Maximum CPU percent (Max Aggregated)
Shown as percent
azure.dbforpostgresql_servers.io_consumption_percent
(gauge)		IO percent
Shown as percent
azure.dbforpostgresql_servers.io_consumption_percent.max
(gauge)		Maximum IO percent (Max Aggregated)
Shown as percent
azure.dbforpostgresql_servers.memory_percent
(gauge)		Memory percent
Shown as percent
azure.dbforpostgresql_servers.memory_percent.max
(gauge)		Maximum Memory percent (Max Aggregated)
Shown as percent
azure.dbforpostgresql_servers.network_bytes_egress
(count)		Network Out across active connections
Shown as byte
azure.dbforpostgresql_servers.network_bytes_ingress
(count)		Network In across active connections
Shown as byte
azure.dbforpostgresql_servers.pg_replica_log_delay_in_bytes
(gauge)		Lag in bytes of the most lagging replica
Shown as byte
azure.dbforpostgresql_servers.pg_replica_log_delay_in_seconds
(gauge)		Replica lag in seconds
Shown as second
azure.dbforpostgresql_servers.serverlog_storage_limit
(gauge)		Server Log storage limit
Shown as byte
azure.dbforpostgresql_servers.serverlog_storage_percent
(gauge)		Server Log storage percent
Shown as percent
azure.dbforpostgresql_servers.serverlog_storage_percent.max
(gauge)		Maximum Server Log storage percent (Max Aggregated)
Shown as percent
azure.dbforpostgresql_servers.serverlog_storage_usage
(gauge)		Server Log storage used
Shown as byte
azure.dbforpostgresql_servers.status
(gauge)		Status of Azure DB for PostgreSQL integration (deprecated)
azure.dbforpostgresql_servers.storage_limit
(gauge)		Storage limit
Shown as byte
azure.dbforpostgresql_servers.storage_percent
(gauge)		Storage percent
Shown as percent
azure.dbforpostgresql_servers.storage_percent.max
(gauge)		Maximum Storage percent (Max Aggregated)
Shown as percent
azure.dbforpostgresql_servers.storage_used
(gauge)		Storage used
Shown as byte
azure.dbforpostgresql_serversv2.active_connections
(gauge)		Active Connections
Shown as connection
azure.dbforpostgresql_serversv2.count
(gauge)		The count of Azure DB for PostgreSQL resources
azure.dbforpostgresql_serversv2.cpu_percent
(gauge)		CPU percent
Shown as percent
azure.dbforpostgresql_serversv2.iops
(count)		IO Operations per second
Shown as operation
azure.dbforpostgresql_serversv2.memory_percent
(gauge)		Memory percent
Shown as percent
azure.dbforpostgresql_serversv2.network_bytes_egress
(count)		Network Out across active connections
Shown as byte
azure.dbforpostgresql_serversv2.network_bytes_ingress
(count)		Network In across active connections
Shown as byte
azure.dbforpostgresql_serversv2.storage_percent
(gauge)		Storage percent
Shown as percent
azure.dbforpostgresql_serversv2.storage_used
(gauge)		Storage used
Shown as byte

Events

The Azure DB for PostgreSQL integration does not include any events.

Service Checks

The Azure DB for PostgreSQL integration does not include any service checks.

Troubleshooting

Need help? Contact Datadog support.