Azure Database for PostgreSQL monitoring integration

New Relic's integrations include an integration for reporting your Microsoft Azure Database for PostgreSQL metrics and other data to New Relic. This document explains how to activate the integration and describes the data reported.

Features

New Relic gathers database data from the Azure Database for PostgreSQL service, which provides fully managed, enterprise-ready PostgreSQL Community database as a service. The service provides high availability, elastic scaling, automatic backups, and data protection at-rest and in-motion.

Using New Relic, you can:

View Azure Database for PostgreSQL data in pre-built New Relic dashboards.
Run custom queries and visualize the data.
Create alert conditions to notify you of changes in data.

Activate integration

Follow standard procedures to activate your Azure service in New Relic.

Configuration and polling

New Relic queries your Azure Database services according to a default polling interval, which varies depending on the integration. For Azure Database for PostgreSQL integrations:

Polling interval: 5 minutes (maximum recommended polling frequency: 1 hour)
Resolution: 1 data point per minute

You can change the polling frequency and filter data using configuration options.

View and use data

To explore your integration data: Go to one.newrelic.com > All capabilities > Infrastructure > Azure > (select an integration).

You can query and explore your data using the AzurePostgreSqlServerSample event type, with a provider value of AzurePostgreSqlServer.

Metric data

This integration collects the following metric data:

Database sample metrics

Metric	Description
`activeConnections`	Count of active connections.
`backupStorageUsedBytes`	Backup storage used, in bytes.
`connectionsFailed`	Count of failed connections.
`cpuPercent`	Percentage of CPU used.
`ioConsumptionPercent`	Percentage of I/O consumption used.
`memoryPercent`	Percentage of memory used.
`networkEgressBytes`	Network Out across active connections, in bytes.
`networkIngressBytes`	Network In across active connections, in bytes.
`pgReplicaLogDelayBytes`	Replication lag, in bytes.
`pgReplicaLogDelaySeconds`	Replication lag, in seconds.
`serverlogStorageLimitBytes`	Server log storage limit, in bytes.
`serverlogStoragePercent`	Percentage of server log storage used.
`serverlogStorageUsageBytes`	Server log storage used, in bytes.
`storageLimitBytes`	Amount of storage available, in bytes.
`storagePercent`	Percentage of available storage used.
`storageUsedBytes`	Amount of storage used, in bytes.