AWS Redshift metrics

Once you’ve integrated with AWS CloudWatch, you have access to metrics from AWS Redshift, which is a petabyte-scale, complete managed data warehouse solution.

See all AWS integrations.

To verify metrics are reporting, search for the metrics in the Metric details section of the Settings page.

The following table shows the Redshift metrics ingested by Cloud Observability.

Metric Name Unit Description
aws.redshift.commit_queue_length count The total transactions awaiting confirmation at any given moment.
aws.redshift.concurrency_scaling_active_clusters count The total concurrent scaling clusters currently working on answering inquiries.
aws.redshift.concurrency_scaling_seconds count The time concurrent scaling clusters consume when there is active query processing activity.
aws.redshift.cpu_utilization percent The CPU utilization rate. For clusters this is an accumulation of all node (leader and compute) CPU utilization data.
aws.redshift.database_connections count The databases connected to a cluster.
aws.redshift.health_status count The cluster's condition.
aws.redshift.maintenance_mode count The cluster's maintenance mode indicated.
aws.redshift.max_configured_concurrency_scaling_clusters count The clusters designed for concurrent scaling in the parameter group.
aws.redshift.network_receive_throughput bytes The data transfer rate to the node or cluster.
aws.redshift.network_transmit_throughput bytes The node's or cluster's capacity to write data.
aws.redshift.percentage_disk_space_used percent The percentage of available storage space.
aws.redshift.queries_completed_per_second count The rate at which requests are answered in a second.
aws.redshift.query_duration microseconds The time needed to finish a query.
aws.redshift.query_runtime_breakdown milliseconds The total time that each query stage took to execute.
aws.redshift.read_iops count The average read operations per second from disks.
aws.redshift.read_latency seconds The average time required for disk read I/O operations.
aws.redshift.read_throughput bytes The data read from disk each second.
aws.redshift.redshift_managed_storage_total_capacity megabytes The total controlled storage.
aws.redshift.total_table_count count The active user tables at any given moment.
aws.redshift.wlm_queue_length count The requests awaiting entry into a workload management (WLM) queue.
aws.redshift.wlm_queue_wait_time milliseconds The total time that queries were held in the workload management (WLM) queue.
aws.redshift.wlm_queries_completed_per_second count The successfully completed inquiries per second for workload management (WLM) queue.
aws.redshift.wlm_query_duration microseconds The time it takes a query for a workload management (WLM) queue to finish.
aws.redshift.wlm_running_queries count The active inquiries per WLM queue coming from both the main cluster and the concurrency scaling cluster.
aws.redshift.write_iops count The write operations per second on average.
aws.redshift.write_latency seconds The average time required for disk write I/O operations.
aws.redshift.write_throughput bytes The data written to disk each second in bytes.
aws.redshift.schema_quota megabytes The quota that has been set up for a schema.
aws.redshift.num_exceeded_schema_quotas count The schemas exceeded their quotas.
aws.redshift.storage_used megabytes The disk or storage area that a schema occupies.
aws.redshift.percentage_quota_used percent The proportion of disk or storage space consumed in relation to the defined schema quota.

See also

Ingest metrics from Amazon

Create and manage dashboards

Create alerts

Updated Dec 9, 2022