Azure Database for PostgreSQL is a relational database service based on the open-source Postgres database engine. It is a fully managed database-as-a-service offering that can handle mission-critical workloads with predictable performance, security, high availability, and dynamic scalability.
Use the Azure public cloud integration to discover and collect metrics against the Azure service.
External reference
Setup
To set up the Azure integration and discover the Azure service, go to Azure Integration Discovery Profile and select PostgreSQL Server.
- Supported
- Configurable in OpsRamp Azure Integration Discovery Profile.
Supported metrics
| OpsRamp Metric | Azure Metric | Metric Display Name | Unit | Aggregation Type | Description |
|---|---|---|---|---|---|
| azure_pgsql_active_connections | active_connections | Active Connections | Count | Average | Active Connections |
| azure_pgsql_backup_storage_used | backup_storage_used | Backup Storage Used | Bytes | Average | Backup Storage Used |
| azure_pgsql_connections_failed | connections_failed | Failed Connections | Count | Total | Failed Connections |
| azure_pgsql_cpu_percent | cpu_percent | CPU percent | Percent | Average | CPU percent |
| azure_pgsql_io_consumption_percent | io_consumption_percent | IO percent | Percent | Average | IO percent |
| azure_pgsql_memory_percent | memory_percent | Memory percent | Percent | Average | Memory percent |
| azure_pgsql_network_bytes_egress | network_bytes_egress | Network Out | Bytes | Total | Network Out across active connections |
| azure_pgsql_network_bytes_ingress | network_bytes_ingress | Network In | Bytes | Total | Network In across active connections |
| azure_pgsql_pg_replica_log_delay_in_bytes | pg_replica_log_delay_in_bytes | Max Lag Across Replicas | Bytes | Average | Lag in bytes of the most lagging replica |
| azure_pgsql_pg_replica_log_delay_in_seconds | pg_replica_log_delay_in_seconds | Replica Lag | Seconds | Average | Replica lag in seconds |
| azure_pgsql_serverlog_storage_limit | serverlog_storage_limit | Server Log storage limit | Bytes | Maximum | Server Log storage limit |
| azure_pgsql_serverlog_storage_percent | serverlog_storage_percent | Server Log storage percent | Percent | Average | Server Log storage percent |
| azure_pgsql_serverlog_storage_usage | serverlog_storage_usage | Server Log storage used | Bytes | Average | Server Log storage used |
| azure_pgsql_storage_limit | storage_limit | Storage limit | Bytes | Maximum | Storage limit |
| azure_pgsql_storage_percent | storage_percent | Storage percent | Percent | Average | Storage percent |
| azure_pgsql_storage_used | storage_used | Storage used | Bytes | Average | Storage used |