Azure Database for PostgreSQL - Flexible Server is a fully managed PostgreSQL database as a service offering that can handle mission-critical workloads with predictable performance and dynamic scalability. Develop applications with Azure Database for PostgreSQL leveraging the open-source tools and platform of your choice. Learn how to use Flexible servers with our quickstarts, tutorials, and samples.

Use OpsRamp Azure Public Cloud Integration to discover and collect metrics against Azure PostgreSQL Flexible Server.

Setup

To set up the Azure integration and discover the Target Group 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 Azure Resources.

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

  3. Select PostgreSQL Flexible Server 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 Target Group resources under Infrastructure > Resources > Microsoft Azure category.

  7. Create a template with collector type Google and applicable for Interconnect. 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 PostgreSQL Flexible Server as shown below:

Event support

OpsRamp supports Azure events for Azure PostgreSQL Flexible Server. 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 MetricMetric Display NameUnitDescriptionAggregation Type
azure_dbforpostgresql_flexibleservers_active_connectionsActive ConnectionsCountActive ConnectionsAverage
azure_dbforpostgresql_flexibleservers_backup_storage_usedBackup Storage UsedBytesBackup Storage UsedAverage
azure_dbforpostgresql_flexibleservers_connections_failedFailed ConnectionsCountFailed ConnectionsTotal
azure_dbforpostgresql_flexibleservers_connections_succeededSucceeded ConnectionsCountSucceeded ConnectionsTotal
azure_dbforpostgresql_flexibleservers_cpu_credits_consumedCPU Credits ConsumedCountTotal number of credits consumed by the database serverAverage
azure_dbforpostgresql_flexibleservers_cpu_credits_remainingCPU Credits RemainingCountTotal number of credits available to burst.Average
azure_dbforpostgresql_flexibleservers_cpu_percentCPU percentPresentCPU percentAverage
azure_dbforpostgresql_flexibleservers_disk_queue_depthDisk Queue DepthCountNumber of outstanding I/O operations to the data disk.Average
azure_dbforpostgresql_flexibleservers_iopsIOPSCountIO Operations per secondAverage
azure_dbforpostgresql_flexibleservers_maximum_used_transactionIDsMaximum Used Transaction IDsCountMaximum Used Transaction IDsAverage
azure_dbforpostgresql_flexibleservers_memory_percentMemory percentPercentMemory percentAverage
azure_dbforpostgresql_flexibleservers_network_bytes_egressNetwork OutBytesNetwork Out across active connectionsTotal
azure_dbforpostgresql_flexibleservers_network_bytes_ingressNetwork InBytesNetwork In across active connectionsTotal
azure_dbforpostgresql_flexibleservers_read_iopsRead IOPSCountNumber of data disk I/O read operations per second.Average
azure_dbforpostgresql_flexibleservers_read_throughputRead Throughput Bytes/SecCountBytes read per second from the data disk during monitoring periodAverage
azure_dbforpostgresql_flexibleservers_storage_freeStorage FreeBytesStorage FreeAverage
azure_dbforpostgresql_flexibleservers_storage_percentStorage percentPercentStorage percentAverage
azure_dbforpostgresql_flexibleservers_storage_usedStorage usedBytesStorage usedAverage
azure_dbforpostgresql_flexibleservers_txlogs_storage_usedTransaction Log Storage UsedBytesTransaction Log Storage UsedAverage
azure_dbforpostgresql_flexibleservers_write_iopsWrite IOPSCountNumber of data disk I/O write operations per secondAverage
azure_dbforpostgresql_flexibleservers_write_throughputWrite Throughput Bytes/SecBytesBytes written per second to the data disk during monitoring period.Average

External reference

Azure PostgreSQL Flexible Server