• /
  • EnglishEspañol日本語한국어Português
  • Log inStart now

Amazon Redshift integration

Important

Enable the AWS CloudWatch Metric Streams integration to monitor all CloudWatch metrics from your AWS services, including custom namespaces. Individual integrations are no longer our recommended option.

New Relic infrastructure integrations include an integration for reporting your Amazon Redshift data to New Relic. This document explains how to activate the integration and describes the data reported.

Features

Amazon Redshift is a fully managed data warehouse that makes it simple and cost-effective to analyze all your data using standard SQL and your existing Amazon Business Intelligence (BI) tools. New Relic's Redshift integration gathers metric and configuration data for the relational databases associated with your Amazon Redshift account.

Reported data includes bytes received and bytes transmitted, health status, database connections, latency, and other metrics). Your Redshift data is available in pre-built and you can also create custom queries and charts.

Activate integration

To enable this integration, follow standard procedures to Connect AWS services to New Relic.

To allow New Relic to access Redshift data, your AWS account must have the ReadOnly policy associated with it, or the following permissions must be granted to your New Relic account:

  • describeClusters
  • describeClusterParameters

Configuration and polling

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

Default polling information for the Amazon RedShift integration:

  • New Relic polling interval: 5 minutes
  • Amazon CloudWatch data interval: 1 minute

Find and use data

To find your integration data, go to one.newrelic.com > All capabilities > Infrastructure > AWS and select one of the Redshift integration links.

You can query and explore your data using the DatastoreSample event type, with a provider value of RedshiftNode for Redshift nodes, or RedshiftCluster for Redshift clusters.

For more on how to use your data, see Understand and use integration data.

Metric data

New Relic collects the following Amazon Redshift data. For full descriptions of each metric, see Amazon's Redshift documentation.

Name

Data type

Dimension

CPUUtilization

percent

NodeID, ClusterIdentifier

DatabaseConnections

count

ClusterIdentifier

HealthStatus

1/0 (HEALTHY/UNHEALTHY in the Amazon CloudWatch console)

ClusterIdentifier

MaintenanceMode

1/0 (ON/OFF in the Amazon CloudWatch console)

ClusterIdentifier

NetworkReceiveThroughput

bytes/seconds (MB/s in the Amazon CloudWatch console)

NodeID, ClusterIdentifier

NetworkTransmitThroughput

bytes/seconds (MB/s in the Amazon CloudWatch console)

NodeID, ClusterIdentifier

PercentageDiskSpaceUsed

percent

NodeID, ClusterIdentifier

QueriesCompletedPerSecond

count/second (for multi-node clusters)

latency, ClusterIdentifier

QueryDuration

microseconds (for multi-node clusters)

latency, ClusterIdentifier

ReadIOPS

count/second

NodeID, ClusterIdentifier

ReadLatency

seconds

NodeID

ReadThroughput

bytes (GB/s in the Amazon CloudWatch console)

NodeID

WLMQueriesCompletedPerSecond

count/second (for multi-node clusters)

ClusterIdentifier

WLMQueryDuration

Microseconds (for multi-node clusters)

ClusterIdentifier

WriteIOPS

count/seconds

NodeID

WriteLatency

seconds

NodeID

WriteThroughput

bytes (GB/s in the Amazon CloudWatch console)

NodeID

Dimensions Amazon Redshift metrics

Amazon Redshift data can be filtered along any of the following dimensions:

Dimension

Description

NodeID

Filters requested data that is specific to the nodes of a cluster. NodeID will be either Leader, Shared, or Compute-N, where N is 0, 1, etc. for the number of nodes in the cluster.

Shared means that the cluster has only one node. The Leader node and Compute node are combined.

ClusterIdentifier

Filters requested data that is specific to the cluster. Metrics that are specific to clusters include HealthStatus, MaintenanceMode, and DatabaseConnections.

In general, metrics for this dimension (for example, ReadIOPS) that are also metrics of nodes represent an aggregate of the node metric data. Take care in interpreting these metrics, because they aggregate behavior of Leader and Compute nodes.

Copyright © 2024 New Relic Inc.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.