Azure Database for PostgreSQL monitoring integration

Access to this feature depends on your subscription level. Requires Infrastructure Pro.

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

Features

New Relic Infrastructure 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 Infrastructure dashboards.
  • Run custom queries and visualize the data in New Relic Insights.
  • Create alert conditions to notify you of changes in data.

Activate integration

Anyone can view and explore the Azure data reporting to your New Relic Infrastructure account.

Only Owner, Admins, or Infrastructure add-on managers can manage the Azure integrations.

Follow standard procedures to activate your Azure service in New Relic Infrastructure, using the generic Reader role.

Configuration and polling

New Relic Infrastructure integrations query 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 in Infrastructure: Go to infrastructure.newrelic.com > Azure > (select an integration).

In New Relic Insights, data about a single database is attached to 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.

Inventory data

This integration collects the following inventory data about your system's state and configuration. For more information, see the Microsoft Azure PostgreSQL documentation.

azure/postgresql/server

  • administratorLogin
  • configuration
  • databaseNames
  • databases, including id, name, type, charset, and collation
  • domainName
  • earliestRestoreDate
  • firewalls, including id, name, type, startIpAddress, and endIpAddress
  • geoRedundantBackup
  • isReplica
  • MasterServerid (only for a replica server)
  • maxConnections
  • name
  • regionName
  • replicaCapacity (only for a replica server)
  • replicationRole (only for a replica server)
  • resourceGroupName
  • skuCapacity
  • skuFamily
  • skuName
  • skuTier
  • sslEnforcement
  • storageAutoGrow
  • tags
  • type
  • userVisibleState
  • version

For more help

Recommendations for learning more: