Subscribed unsubscribe Subscribe Subscribe

AWS Integration - Redshift

Mackerel supports obtaining and monitoring Amazon Redshift metrics in AWS Integration.

Please refer to the following page for AWS Integration configuration methods and a list of supported AWS services.
AWS Integration

Obtaining metrics

The metrics obtainable with AWS Integration’s Redshift support are as follows. For Metric explanations, refer to the AWS help page.

Metrics per Cluster

Graph name Metric Metric name in Mackerel Unit Statistics
CPU CPUUtilization redshift.cpu.used percentage Average
Database Connections DatabaseConnections redshift.database_connections.used integer Average
Cluster Status HealthStatus
MaintenanceMode
redshift.cluster_status.health
redshift.cluster_status.maintenance
integer Average
Network Throughput NetworkReceiveThroughput
NetworkTransmitThroughput
redshift.network_throughput.receive
redshift.network_throughput.transmit
bytes/sec Average
Disk Space PercentageDiskSpaceUsed redshift.disk.used percentage Average

Metrics per Node

Since there can be multiple Nodes per cluster in Redshift, each metric is grouped as follows. The metric name’s NODE_ROLE will contain the Role of the Node. (Example: leader, compute_0 etc.)

Graph name Metric Metric name in Mackerel Unit Statistics
CPU per Node CPUUtilization redshift.cpu_per_node.NODE_ROLE.used percentage Average
Network Throughput per Node NetworkReceiveThroughput
NetworkTransmitThroughput
redshift.network_throughput_per_node.NODE_ROLE.receive
redshift.network_throughput_per_node.NODE_ROLE.transmit
bytes/sec Average
Disk Space per Node PercentageDiskSpaceUsed redshift.disk_per_node.NODE_ROLE.used percentage Average
Disk IOPS ReadIOPS
WriteIOPS
redshift.diskiops.NODE_ROLE.read
redshift.diskiops.NODE_ROLE.write
iops Average
Disk Latency ReadLatency
WriteLatency
redshift.latency.NODE_ROLE.read
redshift.latency.NODE_ROLE.write
float Average
Disk Throughput ReadThroughput
WriteThroughput
redshift.throughput.NODE_ROLE.read
redshift.throughput.NODE_ROLE.write
bytes/sec Average