Query: CPU average utilization of an EC2 instance over 80% for the last 5 days

Description

Determine the instances where the average utilization of a specific EC2 instance has exceeded 80% in the past 5 days. This query is useful for monitoring system performance and identifying potential issues with resource allocation.

Query

Tables used in this query:

• aws_cloudwatch_metric_statistic_data_point

SQL