Introduction
Azure Database for PostgreSQL is a relational database service based on the open-source Postgres database engine. It’s a fully managed database-as-a-service offering that can handle mission-critical workloads with predictable performance, security, high availability, and dynamic scalability.
Note
Use the OpsRamp Azure public cloud integration to discover and collect metrics against the Azure service.Setup
To set up the OpsRamp Azure integration and discover the Azure service,
go to Azure Integration Discovery Profile and select PostgreSQL Server.
Metrics
| OpsRamp Metric | Metric Display Name | Unit | Aggregation Type | Description |
|---|---|---|---|---|
| azure_sql_database_cpu_percent | n/a | Percent | Average | CPU percent |
| azure_memory_percent | n/a | Percent | Average | Memory percent |
| azure_io_consumption_percent | n/a | Percent | Average | IO percent |
| azure_sql_database_storage_percent | n/a | Percent | Average | Storage percent |
| azure_storage_used | n/a | Bytes | Average | Storage used |
| azure_storage_limit | n/a | Bytes | Average | Storage limit |
| azure_active_connections | n/a | Count | Average | Active Connections |
| azure_connections_failed | n/a | Count | Average | Failed Connections |
| azure_postgresql_serverlog_storage_percent | Server Log storage percent | Percent | Average | Server Log storage percent |
| azure_postgresql_serverlog_storage_usage | Server Log storage used | Bytes | Average | Server Log storage used |
| azure_postgresql_serverlog_storage_limit | Server Log storage limit | Bytes | Average | Server Log storage limit |
| azure_postgresql_network_bytes_egress | Network Out | Bytes | Total | Network Out across active connections |
| azure_postgresql_network_bytes_ingress | Network In | Bytes | Total | Network In across active connections |
| azure_postgresql_pg_replica_log_delay_seconds | Replica Lag | Seconds | Maximum | Replica lag in seconds |
| azure_postgresql_pg_replica_log_delay_bytes | Max Lag Across Replicas | Bytes | Maximum | Lag in bytes of the most lagging replica |
| cloud_instance_state | Status/state | n/a | n/a | Express Route Status/state |
Event support
- Supported
- Configurable in OpsRamp Azure Integration Discovery Profile.