Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. An Amazon Redshift data warehouse is a collection of computing resources called nodes, organized into a cluster.

Use OpsRamp AWS Public Cloud Integration to discover and collect metrics against AWS Redshift Cluster Node.

Setup

If you have not already done so, set up the OpsRamp AWS Integration. Select Redshift in the AWS Integration Discovery Profile to discover AWS Redshift Cluster Node resources.

Event support

CloudTrail event support

  • Supported
  • Configurable in OpsRamp AWS Integration Discovery Profile.

CloudWatch alarm support

  • Supported
  • Configurable in OpsRamp AWS Integration Discovery Profile.

Supported metrics

OpsRamp MetricAWS MetricMetric Display NameUnitAggregation TypeDescription
aws_redshift_CPUUtilizationCPUUtilizationCPU UtilizationPercentAveragePercentage of CPU utilization. For clusters, represents aggregation of all nodes (leader and compute)
aws_redshift_NetworkReceiveThroughputNetworkReceiveThroughputNetwork Receive ThroughputBytes/SecondAverageRate at which the node or cluster receives data
aws_redshift_NetworkTransmitThroughputNetworkTransmitThroughputNetwork Transmit ThroughputBytes/SecondAverageRate at which the node or cluster writes/transmits data
aws_redshift_PercentageDiskSpaceUsedPercentageDiskSpaceUsedPercentage Disk Space UsedPercentAveragePercent of disk space used
aws_redshift_ReadThroughputReadThroughputRead ThroughputBytesAverageAverage number of bytes read from disk per second
aws_redshift_WriteThroughputWriteThroughputWrite ThroughputBytesAverageAverage number of bytes written to disk per second
aws_redshift_ReadIOPSReadIOPSRead IOPSCount/SecondAverageAverage number of disk read operations per second
aws_redshift_ReadLatencyReadLatencyRead LatencySecondsAverageAverage time taken for disk read I/O operations
aws_redshift_WriteIOPSWriteIOPSWrite IOPSCount/SecondAverageAverage number of write operations per second
aws_redshift_WriteLatencyWriteLatencyWrite LatencySecondsAverageAverage time taken for disk write I/O operations
aws_redshift_QueryDurationQueryDurationQuery DurationMicrosecondsAverageAverage time to complete a query
aws_redshift_QueryRuntimeBreakdownQueryRuntimeBreakdownQuery Runtime BreakdownMillisecondsAverageTotal time queries spent running by query stage

External reference

Amazon Redshift