Query: CPU daily average < 2%

Description

This example helps to identify instances where the average daily CPU utilization is less than 2% in your AWS Redshift clusters. This can be useful to pinpoint underutilized resources, potentially leading to cost savings by downsizing or eliminating these clusters.

Query

Tables used in this query:

• aws_redshift_cluster_metric_cpu_utilization_daily

SQL