Microsoft Azure DB for PostgreSQL
Overview
Microsoft Azure Database for PostgreSQL is a fully-managed, cloud-based relational database service provided by Microsoft Azure. It is based on the popular open-source PostgreSQL database management system and offers a scalable and high-performance solution for hosting PostgreSQL databases in the Azure cloud environment.
Prerequisites
You can check the list of prerequisites required for Azure SQL DB here. These are the same for any other Azure service that you need to monitor using AIOps. Move to the section Adding Azure resources for Monitoring on the above link to view the prerequisites for Azure resource monitoring.
List of Supported KPIs
| Name | Description | Type |
|---|---|---|
| azure.postgresql.server | Azure PostgreSQL server | Percent |
| azure.postgresql.server.id | ID of the Azure PostgreSQL server | Bytes |
| azure.postgresql.server.resource.group | Resource group of the Azure PostgreSQL server | Bytes |
| azure.status | Status of the Azure services | Bytes |
| status | Status of the Azure PostgreSQL database | Count |
| azure.postgresql.server.replica.lag.seconds | Average lag in seconds behind the master | Count |
| azure.postgresql.server.active.connections | Average count of active connections | Count |
| azure.postgresql.server.cpu.percent | CPU usage percentage | Percent |
| azure.postgresql.server.log.storage.capacity.bytes | Maximum capacity of server log storage | Bytes |
| azure.postgresql.server.log.storage.used.bytes | Average usage of server log storage | Bytes |
| azure.postgresql.server.log.storage.used.percent | Percentage of used server log storage | Bytes |
| azure.postgresql.server.memory.percent | Memory usage percentage | Percent |
| azure.postgresql.server.storage.capacity.bytes | Average storage capacity | Bytes |
| azure.postgresql.server.storage.used.bytes | Average usage of storage | Percent |
| azure.postgresql.server.storage.used.percent | Percentage of used storage | Bytes |
| azure.postgresql.server.failed.connections | Average count of failed connections | Count |
| event.timestamp | Event timestamp | Count |
| azure.postgresql.server.network.out.bytes | Average egress network traffic | Bytes |
| azure.postgresql.server.network.in.bytes | Average ingress network traffic | Bytes |