Azure Integration - Database for PostgreSQL

Mackerel supports obtaining and monitoring Database for PostgreSQL metrics in Azure Integration. Billable targets are determined using the conversion 1 resource = 1 Micro Host. (Currently "Single Server" and "Flexible Server" deployment options are supported.)

Please refer to the following page for Azure Integration configuration methods and a list of supported Azure services.
Azure Integration

Flexible Server

Integration for Flexible Server can be done by selecting "Database for PostgreSQL Flexible Server" in "Metric collecting service" section of the Azure Integration Settings screen.

Obtaining metrics

The following metrics can be retrieved for Database for PostgreSQL flexible servers.

A maximum of 34 metrics (including 16 enhanced metrics) will be retrieved. Enhanced metrics can be retrieved by turning on the server parameter metrics.collector_database_activity. The actual metrics obtained may be reduced depending on the server SKU and role.

For Metric explanations and how to enable enhanced metrics, please refer to the Azure documentation.

Graph name Metric Metric name in Mackerel Unit Aggregation Type Enhanced Metric
Availability is_db_alive azure.db_for_postgresql.availability.db float Average x
Backends numbackends azure.db_for_postgresql.backends.count float Maximum x
Backup Storage used backup_storage_used azure.db_for_postgresql.backup_storage_used.bytes bytes Average
Connections active_connections
connections_succeeded
connections_failed
azure.db_for_postgresql.connections.active
azure.db_for_postgresql.connections.succeeded
azure.db_for_postgresql.connections.failed
float Average
Total
Total
CPU credits Remaining/Consumed cpu_credits_remaining
cpu_credits_consumed
azure.db_for_postgresql.cpu_credits.remaining
azure.db_for_postgresql.cpu_credits.consumed
float Average
CPU percent cpu_percent azure.db_for_postgresql.cpu.percent percentage Average
Deadlocks deadlocks azure.db_for_postgresql.deadlocks.count float Total x
Disk Bandwidth Consumed disk_bandwidth_consumed_percentage azure.db_for_postgresql.disk_bandwidth_consumed.percent percentage Average x
Disk IOPS read_iops
write_iops
azure.db_for_postgresql.disk_iops.read
azure.db_for_postgresql.disk_iops.write
iops Average
Disk IOPS Consumed disk_iops_consumed_percentage azure.db_for_postgresql.disk_ios_consumed.percent percentage Average x
Disk Throughput read_throughput
write_throughput
azure.db_for_postgresql.disk_throughput.read
azure.db_for_postgresql.disk_throughput.write
bytes/sec Average
Logical Replication Lag logical_replication_delay_in_bytes azure.db_for_postgresql.logical_replication_lag_bytes.max bytes Maximum x
Memory percent memory_percent azure.db_for_postgresql.memory.percent percentage Average
Network In/Out network_bytes_egress
network_bytes_ingress
azure.db_for_postgresql.network.out
azure.db_for_postgresql.network.in
bytes Total
Operated Tuples by Queries tup_deleted
tup_fetched
tup_inserted
tup_returned
tup_updated
azure.db_for_postgresql.tuples.deleted
azure.db_for_postgresql.tuples.fetched
azure.db_for_postgresql.tuples.inserted
azure.db_for_postgresql.tuples.returned
azure.db_for_postgresql.tuples.updated
float Total x
Physical Replication Lag physical_replication_delay_in_bytes azure.db_for_postgresql.replication_lag_bytes.max bytes Maximum x
Read Replica Lag physical_replication_delay_in_seconds azure.db_for_postgresql.replication_lag.seconds seconds Maximum x
Storage percent storage_percent azure.db_for_postgresql.storage.percent percentage Average
Storage limit/used storage_limit
storage_used
azure.db_for_postgresql.storage_limit_used.limit
azure.db_for_postgresql.storage_limit_used.used
bytes Maximum
Average
Transactions xact_total
xact_commit
xact_rollback
azure.db_for_postgresql.transactions.total
azure.db_for_postgresql.transactions.commit
azure.db_for_postgresql.transactions.rollback
float Total x
Used Transaction IDs maximum_used_transactionIDs azure.db_for_postgresql.used_transaction_ids.max float Max

Notes

  • Of the graphs / metrics that can be obtained with Azure integration listed above, when obtaining Backup Storage used at the Basic price level, it is done so according to the specifications of the Azure Monitor API used by Azure integration, normally with a 15-minute interval granularity and updates having a latency of up to 30 minutes.

Single Server

Integration for Single Server can be done by selecting "Database for PostgreSQL Single Server" in "Metric collecting service" section of the Azure Integration Settings screen. The old Database for PostgreSQL integration settings have been transferred to Database for PostgreSQL Single Server.

Obtaining metrics

The metrics obtainable with Azure Integration’s Database for PostgreSQL support vary by price level. The metrics for each price level are as follows. For Metric explanations, please refer to the Azure documentation.

Basic

The maximum number of metrics obtainable is 15.

Graph name Metric Metric name in Mackerel Unit Aggregation Type
Active/Failed Connections active_connections
connections_failed
azure.db_for_postgresql.connections.active
azure.db_for_postgresql.connections.failed
float Average
Total
Backup Storage used backup_storage_used azure.db_for_postgresql.backup_storage_used.bytes bytes Average
CPU percent cpu_percent azure.db_for_postgresql.cpu.percent percentage Average
Max Lag Across Replicas pg_replica_log_delay_in_bytes azure.db_for_postgresql.replica_log_delay_in_bytes.bytes bytes Maximum
Memory percent memory_percent azure.db_for_postgresql.memory.percent percentage Average
Network In/Out network_bytes_egress
network_bytes_ingress
azure.db_for_postgresql.network.out
azure.db_for_postgresql.network.in
bytes Total
Replica Lag pg_replica_log_delay_in_seconds azure.db_for_postgresql.replica_log_delay_in_seconds.seconds float Maximum
Server Log storage limit/used serverlog_storage_limit
serverlog_storage_usage
azure.db_for_postgresql.server_log_storage_limit_used.limit
azure.db_for_postgresql.server_log_storage_limit_used.used
bytes Maximum
Average
Server Log storage percent serverlog_storage_percent azure.db_for_postgresql.server_log_storage.percent percentage Average
Storage limit/used storage_limit
storage_used
azure.db_for_postgresql.storage_limit_used.limit
azure.db_for_postgresql.storage_limit_used.used
bytes Maximum
Average
Storage percent storage_percent azure.db_for_postgresql.storage.percent percentage Average

General Purpose

The maximum number of metrics obtainable is 15.

Graph name Metric Metric name in Mackerel Unit Aggregation Type
Active/Failed Connections active_connections
connections_failed
azure.db_for_postgresql.connections.active
azure.db_for_postgresql.connections.failed
float Average
Total
CPU percent cpu_percent azure.db_for_postgresql.cpu.percent percentage Average
IO percent io_consumption_percent azure.db_for_postgresql.io.percent percentage Average
Max Lag Across Replicas pg_replica_log_delay_in_bytes azure.db_for_postgresql.replica_log_delay_in_bytes.bytes bytes Maximum
Memory percent memory_percent azure.db_for_postgresql.memory.percent percentage Average
Network In/Out network_bytes_egress
network_bytes_ingress
azure.db_for_postgresql.network.out
azure.db_for_postgresql.network.in
bytes Total
Replica Lag pg_replica_log_delay_in_seconds azure.db_for_postgresql.replica_log_delay_in_seconds.seconds float Maximum
Server Log storage limit/used serverlog_storage_limit
serverlog_storage_usage
azure.db_for_postgresql.server_log_storage_limit_used.limit
azure.db_for_postgresql.server_log_storage_limit_used.used
bytes Maximum
Average
Server Log storage percent serverlog_storage_percent azure.db_for_postgresql.server_log_storage.percent percentage Average
Storage limit/used storage_limit
storage_used
azure.db_for_postgresql.storage_limit_used.limit
azure.db_for_postgresql.storage_limit_used.used
bytes Maximum
Average
Storage percent storage_percent azure.db_for_postgresql.storage.percent percentage Average

Memory Optimized

The maximum number of metrics obtainable is 15.

Graph name Metric Metric name in Mackerel Unit Aggregation Type
Active/Failed Connections active_connections
connections_failed
azure.db_for_postgresql.connections.active
azure.db_for_postgresql.connections.failed
float Average
Total
CPU percent cpu_percent azure.db_for_postgresql.cpu.percent percentage Average
IO percent io_consumption_percent azure.db_for_postgresql.io.percent percentage Average
Max Lag Across Replicas pg_replica_log_delay_in_bytes azure.db_for_postgresql.replica_log_delay_in_bytes.bytes bytes Maximum
Memory percent memory_percent azure.db_for_postgresql.memory.percent percentage Average
Network In/Out network_bytes_egress
network_bytes_ingress
azure.db_for_postgresql.network.out
azure.db_for_postgresql.network.in
bytes Total
Replica Lag pg_replica_log_delay_in_seconds azure.db_for_postgresql.replica_log_delay_in_seconds.seconds float Maximum
Server Log storage limit/used serverlog_storage_limit
serverlog_storage_usage
azure.db_for_postgresql.server_log_storage_limit_used.limit
azure.db_for_postgresql.server_log_storage_limit_used.used
bytes Maximum
Average
Server Log storage percent serverlog_storage_percent azure.db_for_postgresql.server_log_storage.percent percentage Average
Storage limit/used storage_limit
storage_used
azure.db_for_postgresql.storage_limit_used.limit
azure.db_for_postgresql.storage_limit_used.used
bytes Maximum
Average
Storage percent storage_percent azure.db_for_postgresql.storage.percent percentage Average

Notes

  • Of the graphs / metrics that can be obtained with Azure integration listed above, when obtaining Backup Storage used at the Basic price level, it is done so according to the specifications of the Azure Monitor API used by Azure integration, normally with a 15-minute interval granularity and updates having a latency of up to 30 minutes.
    Additionally, it is not graphed in replica servers.

  • pg_replica_log_delay_in_bytes only counts up on the master server.
    As a result, Max Lag Across Replicas is not graphed in replica servers.

  • pg_replica_log_delay_in_seconds only counts up on replica servers.
    As a result, Replica Lag is not graphed in the master server.