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. These nodes are organized into a group called a cluster and each cluster runs an Amazon Redshift engine and includes one or more databases.
Use the AWS public cloud integration to discover and collect metrics against the AWS service.
External reference
Monitoring Amazon Redshift using CloudWatch metrics
Setup
To set up the AWS integration and discover the AWS service, go to AWS Integration Discovery Profile and select Redshift.
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
Standard metrics
| OpsRamp Metric | AWS Metric | Metric Display Name | Unit | Aggregation Type | Description |
|---|---|---|---|---|---|
| aws_redshift_CommitQueueLength | CommitQueueLength | Commit Queue Length | Count | Average | Number of transactions waiting to commit at a given point in time |
| aws_redshift_ConcurrencyScalingActiveClusters | ConcurrencyScalingActiveClusters | Concurrency Scaling Active Clusters | Count | Average | Number of concurrency scaling clusters actively processing queries at any given time |
| aws_redshift_ConcurrencyScalingSeconds | ConcurrencyScalingSeconds | Concurrency Scaling Seconds | Count | Average | Number of seconds used by concurrency scaling clusters with active query processing activity |
| aws_redshift_CPUUtilization | CPUUtilization | CPU Utilization | Percent | Average | Percentage of CPU utilization. For clusters, represents aggregation of all nodes (leader and compute) |
| aws_redshift_DatabaseConnections | DatabaseConnections | Database Connections | Count | Average | Number of database connections to a cluster |
| aws_redshift_HealthStatus | HealthStatus | Health Status | Count | Average | Indicates cluster health. 1 = HEALTHY, 0 = UNHEALTHY |
| aws_redshift_MaintenanceMode | MaintenanceMode | Maintenance Mode | Count | Average | Indicates whether the cluster is in maintenance mode. 1 = ON, 0 = OFF |
| aws_redshift_MaxConfiguredConcurrencyScalingClusters | MaxConfiguredConcurrencyScalingClusters | Max Configured Concurrency Scaling Clusters | Count | Average | Maximum number of concurrency scaling clusters configured from the parameter group |
| aws_redshift_NetworkReceiveThroughput | NetworkReceiveThroughput | Network Receive Throughput | Bytes/Second | Average | Rate at which the node or cluster receives data |
| aws_redshift_NetworkTransmitThroughput | NetworkTransmitThroughput | Network Transmit Throughput | Bytes/Second | Average | Rate at which the node or cluster writes/transmits data |
| aws_redshift_PercentageDiskSpaceUsed | PercentageDiskSpaceUsed | Percentage Disk Space Used | Percent | Average | Percent of disk space used |
| aws_redshift_ReadIOPS | ReadIOPS | Read IOPS | Count/Second | Average | Average number of disk read operations per second |
| aws_redshift_ReadLatency | ReadLatency | Read Latency | Seconds | Average | Average time taken for disk read I/O operations |
| aws_redshift_ReadThroughput | ReadThroughput | Read Throughput | Bytes | Average | Average number of bytes read from disk per second |
| aws_redshift_RedshiftManagedStorageTotalCapacity | RedshiftManagedStorageTotalCapacity | Redshift Managed Storage Total Capacity | Megabytes | Average | Total managed storage capacity |
| aws_redshift_TotalTableCount | TotalTableCount | Total Table Count | Count | Average | Number of user tables open at a particular point in time |
| aws_redshift_WriteIOPS | WriteIOPS | Write IOPS | Count/Second | Average | Average number of write operations per second |
| aws_redshift_WriteLatency | WriteLatency | Write Latency | Seconds | Average | Average time taken for disk write I/O operations |
| aws_redshift_WriteThroughput | WriteThroughput | Write Throughput | Bytes | Average | Average number of bytes written to disk per second |
| aws_redshift_QueriesCompletedPerSecond | QueriesCompletedPerSecond | Queries Completed Per Second | Count/Second | Average | Average number of queries completed per second |
| aws_redshift_QueryDuration | QueryDuration | Query Duration | Microseconds | Average | Average time to complete a query |
| aws_redshift_QueryRuntimeBreakdown | QueryRuntimeBreakdown | Query Runtime Breakdown | Milliseconds | Average | Total time queries spent running by query stage |
| aws_redshift_WLMQueueLength | WLMQueueLength | WLM Queue Length | Count | Average | Number of queries waiting to enter a WLM queue |
| aws_redshift_WLMQueueWaitTime | WLMQueueWaitTime | WLM Queue Wait Time | Milliseconds | Average | Total time queries spent waiting in the WLM queue |
| aws_redshift_WLMQueriesCompletedPerSecond | WLMQueriesCompletedPerSecond | WLM Queries Completed Per Second | Count/Second | Average | Average number of queries completed per second for a WLM queue |
| aws_redshift_WLMQueryDuration | WLMQueryDuration | WLM Query Duration | Microseconds | Average | Average length of time to complete a query for a WLM queue |
| aws_redshift_WLMRunningQueries | WLMRunningQueries | WLM Running Queries | Count | Average | Number of queries running from both the main cluster and concurrency scaling cluster per WLM queue |
| aws_redshift_SchemaQuota | SchemaQuota | Schema Quota | Megabytes | Average | The configured quota for a schema |
| aws_redshift_NumExceededSchemaQuotas | NumExceededSchemaQuotas | Num Exceeded Schema Quotas | Count | Average | Number of schemas with exceeded quotas |
| aws_redshift_StorageUsed | StorageUsed | Storage Used | Megabytes | Average | Disk/storage space used by a schema |
| aws_redshift_PercentageQuotaUsed | PercentageQuotaUsed | Percentage Quota Used | Percent | Average | Percentage of disk/storage space used relative to the configured schema quota |
| aws_redshift_UsageLimitAvailable | UsageLimitAvailable | Usage Limit Available | Count | Average | Total available capacity depending on FeatureType |
| aws_redshift_UsageLimitConsumed | UsageLimitConsumed | Usage Limit Consumed | Count | Average | Total consumed capacity depending on FeatureType |
Cluster metrics
| OpsRamp Metric | Metric Display Name | Unit | Aggregation Type |
|---|---|---|---|
| cloud.instance.state Redshift status metric. | Status/State | n/a | n/a |
| aws_redshift_CPUUtilization Percentage of allocated EC2 compute units that are currently in use on the instance. This metric identifies the processing power required to run an application On a selected instance. | CPU utilization | Percent | Maximum |
| aws_redshift_DatabaseConnections Number of database connections in use. | DatabaseConnections | Count | Average |
| aws_redshift_NetworkReceiveThroughput Incoming (receive) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication. | NetworkReceiveThroughput | Average | |
| aws_redshift_NetworkTransmitThroughput Outgoing (transmit) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication. | NetworkTransmitThroughput | Average | |
| aws_redshift_PercentageDiskSpaceUsed The percent of disk space used. | PercentageDiskSpaceUsed | Percent | Average |
| aws_redshift_ReadThroughput Average number of bytes read from disk per second. | ReadThroughput | Average | |
| aws_redshift_WriteThroughput Average number of bytes written to disk per second. | WriteThroughput | Average | |
| aws_redshift_ReadIOPS Average number of disk read operations per second | ReadIOPS | Count/Sec | Average |
| aws_redshift_WriteIOPS Average number of write operations per second. | WriteIOPS | Count/Sec | Average |
| aws_redshift_ReadLatency Average amount of time taken for disk read I/O operations. | ReadLatency | Seconds | Average |
| aws_redshift_WriteLatency Average amount of time taken for disk write I/O operations. | WriteLatency | Seconds | Average |
| aws_redshift_HealthStatus Indicates the health of the cluster. | HealthStatus | Average | |
| aws_redshift_MaintenanceMode Indicates whether the cluster is in maintenance mode. | MaintenanceMode | Average |