| title | description | services | author | ms.author | manager | editor | ms.service | ms.topic | ms.date |
|---|---|---|---|---|---|---|---|---|---|
Monitoring in Azure Database for PostgreSQL | Microsoft Docs |
This article describes the metrics for monitoring and alerting for Azure Database for PostgreSQL, including CPU, limits, storage, and connection statistics. |
postgresql |
rachel-msft |
raagyema |
jhubbard |
jasonwhowell |
postgresql |
article |
10/24/2017 |
Monitoring data about your servers helps you troubleshoot and optimize for your workload. Azure Database for PostgreSQL provides various metrics that give insight into the behavior of the resources supporting the PostgreSQL server.
All Azure metrics have a one-minute frequency, and each metric provides 30 days of history.
You can configure alerts on the metrics. For step by step guidance, see How to set up alerts.
Other tasks include setting up automated actions, performing advanced analytics, and archiving history. For more information, see the Azure Metrics Overview.
These metrics are available for Azure Database for PostgreSQL:
|Metric|Metric Display Name|Unit|Description| |---|---|---|---|---| |cpu_percent|CPU percent|Percent|The percentage of CPU in use.| |compute_limit|Compute Unit limit|Count|This server's maximum number of compute units| |compute_consumption_percent|Compute Unit percentage|Percent|The percentage of compute units used out of the server's maximum.| |memory_percent|Memory percent|Percent|The percentage of memory in use.| |io_consumption_percent|IO percent|Percent|The percentage of IO in use.| |storage_percent|Storage percentage|Percent|The percentage of storage used out of the server's maximum.| |storage_used|Storage used|Bytes|The amount of storage in use. The storage used by the service includes the database files, transaction logs, and the server logs.| |storage_limit|Storage limit|Bytes|The maximum storage for this server.| |active_connections|Total active connections|Count|The number of active connections to the server.| |connections_failed|Total failed connections|Count|The number of failed connections to the server.|
Note
Compute Unit is composed of Memory and CPU. The Compute Unit percentage is max(memory%, cpu%). Examine the memory and cpu charts to pinpoint which is contributing to Compute Unit percentage changes. For more information, see compute units.
- For step by step guidance, see How to set up alerts.
- For more information on how to access and export metrics using the Azure portal, REST API, or CLI, see the Azure Metrics Overview.