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:

  1. 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.

  2. Create a discovery profile. For more information on how to create a discovery profile, refer to Create Discovery Profile.

  3. Select Cosmos DB for PostgreSQL Clusters under the Filter Criteria in the Edit Discovery Profile page.

    Azure Integration Discovery Profile

    Azure Integration Discovery Profile

  4. Save the discovery profile to make them available in the list of Discovery Profiles.

  5. Scan to discover the resources at any time independent of the predefined schedule.

  6. Once the scan is completed, you can view the Cosmos DB for PostgreSQL Clusters resources under Infrastructure > Resources > Microsoft Azure category.

  7. 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.

  8. Refer to Assign a Template on how to assign a template to a resource.

  9. 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 MetricAzure MetricMetric Display NameUnitDescriptionAggregation Type
azure_cosmosdb_postgresql_cluster_active_connectionsactive_connectionsActive ConnectionsCountIndicates the number of active connections.Average
azure_cosmosdb_postgresql_cluster_apps_reserved_memory_percentapps_reserved_memory_percentReserved Memory percentPercentIndicates percentage of commit memory limit reserved by applications.Average
azure_cosmosdb_postgresql_cluster_cpu_credits_consumedcpu_credits_consumedCPU Credits ConsumedCountTotal number of credits consumed by the node. Only available when burstable compute is provisioned on the node.Average
azure_cosmosdb_postgresql_cluster_cpu_credits_remainingcpu_credits_remainingCPU Credits RemainingCountTotal number of credits available to burst. Only available when burstable compute is provisioned on the node.Average
azure_cosmosdb_postgresql_cluster_cpu_percentcpu_percentCPU percentPercentPercentage of CPU available.Average
azure_cosmosdb_postgresql_cluster_iopsiopsIOPSCountIndicates number of IO operations per second.Average
azure_cosmosdb_postgresql_cluster_memory_percentmemory_percentMemory percentPercentIndicates memory percentage.Average
azure_cosmosdb_postgresql_cluster_network_bytes_egressnetwork_bytes_egressNetwork OutBytesNetwork out across active connections.Total
azure_cosmosdb_postgresql_cluster_network_bytes_ingressnetwork_bytes_ingressNetwork InBytesNetwork in across active connections.Total
azure_cosmosdb_postgresql_cluster_replication_lagreplication_lagReplication lagMilliSecondsAllows to see how much read replica nodes are behind their counterparts in the primary cluster.Average
azure_cosmosdb_postgresql_cluster_storage_percentstorage_percentStorage percentPercentIndicates storage percentage.Average
azure_cosmosdb_postgresql_cluster_storage_usedstorage_usedStorage usedBytesIndicates amount storage used.Average
azure_cosmosdb_postgresql_cluster_vm_cached_bandwidth_percentvm_cached_bandwidth_percentVM Cached Bandwidth Consumed PercentagePercentPercentage of cached disk bandwidth consumed by the VM.Average
azure_cosmosdb_postgresql_cluster_vm_cached_iops_percentvm_cached_iops_percentVM Cached IOPS Consumed PercentagePercentPercentage of cached disk IOPS consumed by the VM.Average
azure_cosmosdb_postgresql_cluster_vm_uncached_bandwidth_percentvm_uncached_bandwidth_percentVM Uncached Bandwidth Consumed PercentagePercentPercentage of uncached disk bandwidth consumed by the VM.Average
azure_cosmosdb_postgresql_cluster_vm_uncached_iops_percentvm_uncached_iops_percentVM Uncached IOPS Consumed PercentagePercentPercentage of uncached disk IOPS consumed by the VM.Average

External reference

PostgreSQL Introduction