Azure Cosmos DB for PostgreSQL is a managed service for PostgreSQL extended with the Citus open source superpower of distributed tables. This superpower enables you to build highly scalable relational applications.
You can start building apps on a single node cluster, the same way you would with PostgreSQL. As your app’s scalability and performance requirements grow, you can seamlessly scale to multiple nodes by transparently distributing your tables.
Setup
To set up the Azure integration and discover the Cosmos DB for PostgreSQL Clusters resources, do the following:
Create an Azure Integration if not available in your installed integrations. For more information on how to install the Azure Integration, refer to Install Azure integration.
Create a discovery profile. For more information on how to create a discovery profile, refer to Create Discovery Profile.
Select
Cosmos DB for PostgreSQL Clustersunder the Filter Criteria in the Edit Discovery Profile page.
Azure Integration Discovery Profile
Save the discovery profile to make them available in the list of Discovery Profiles.
Scan to discover the resources at any time independent of the predefined schedule.
Once the scan is completed, you can view the Cosmos DB for PostgreSQL Clusters resources under Infrastructure > Resources > Microsoft Azure category.
Create a template with collector type Azure and applicable for Cosmos DB for PostgreSQL Clusters. See Create a Template for more information on how to create a template.
Refer to Assign a Template on how to assign a template to a resource.
Click the Metrics tab to view the monitoring data of Cosmos DB for PostgreSQL Clusters as shown below:
Event support
OpsRamp supports Azure events for Azure Cosmos DB for PostgreSQL Clusters. Configure Azure Events in OpsRamp Azure integration discovery profile.
See Process Azure Events for more information on how to configure Azure events.
Supported metrics
| OpsRamp Metric | Azure Metric | Metric Display Name | Unit | Description | Aggregation Type |
|---|---|---|---|---|---|
| azure_cosmosdb_postgresql_cluster_active_connections | active_connections | Active Connections | Count | Indicates the number of active connections. | Average |
| azure_cosmosdb_postgresql_cluster_apps_reserved_memory_percent | apps_reserved_memory_percent | Reserved Memory percent | Percent | Indicates percentage of commit memory limit reserved by applications. | Average |
| azure_cosmosdb_postgresql_cluster_cpu_credits_consumed | cpu_credits_consumed | CPU Credits Consumed | Count | Total number of credits consumed by the node. Only available when burstable compute is provisioned on the node. | Average |
| azure_cosmosdb_postgresql_cluster_cpu_credits_remaining | cpu_credits_remaining | CPU Credits Remaining | Count | Total number of credits available to burst. Only available when burstable compute is provisioned on the node. | Average |
| azure_cosmosdb_postgresql_cluster_cpu_percent | cpu_percent | CPU percent | Percent | Percentage of CPU available. | Average |
| azure_cosmosdb_postgresql_cluster_iops | iops | IOPS | Count | Indicates number of IO operations per second. | Average |
| azure_cosmosdb_postgresql_cluster_memory_percent | memory_percent | Memory percent | Percent | Indicates memory percentage. | Average |
| azure_cosmosdb_postgresql_cluster_network_bytes_egress | network_bytes_egress | Network Out | Bytes | Network out across active connections. | Total |
| azure_cosmosdb_postgresql_cluster_network_bytes_ingress | network_bytes_ingress | Network In | Bytes | Network in across active connections. | Total |
| azure_cosmosdb_postgresql_cluster_replication_lag | replication_lag | Replication lag | MilliSeconds | Allows to see how much read replica nodes are behind their counterparts in the primary cluster. | Average |
| azure_cosmosdb_postgresql_cluster_storage_percent | storage_percent | Storage percent | Percent | Indicates storage percentage. | Average |
| azure_cosmosdb_postgresql_cluster_storage_used | storage_used | Storage used | Bytes | Indicates amount storage used. | Average |
| azure_cosmosdb_postgresql_cluster_vm_cached_bandwidth_percent | vm_cached_bandwidth_percent | VM Cached Bandwidth Consumed Percentage | Percent | Percentage of cached disk bandwidth consumed by the VM. | Average |
| azure_cosmosdb_postgresql_cluster_vm_cached_iops_percent | vm_cached_iops_percent | VM Cached IOPS Consumed Percentage | Percent | Percentage of cached disk IOPS consumed by the VM. | Average |
| azure_cosmosdb_postgresql_cluster_vm_uncached_bandwidth_percent | vm_uncached_bandwidth_percent | VM Uncached Bandwidth Consumed Percentage | Percent | Percentage of uncached disk bandwidth consumed by the VM. | Average |
| azure_cosmosdb_postgresql_cluster_vm_uncached_iops_percent | vm_uncached_iops_percent | VM Uncached IOPS Consumed Percentage | Percent | Percentage of uncached disk IOPS consumed by the VM. | Average |