Query: ec2_top10_cpu_past_week

  with top_n as (
  select
    instance_id,
    avg(average)
  from
    aws_ec2_instance_metric_cpu_utilization_daily
  where
    timestamp  >= CURRENT_DATE - INTERVAL '7 day'
  group by
    instance_id
  order by
    avg desc
  limit 10
)
select
    timestamp,
    instance_id,
    average
  from
    aws_ec2_instance_metric_cpu_utilization_hourly
  where
    timestamp  >= CURRENT_DATE - INTERVAL '7 day'
    and instance_id in (select instance_id from top_n)
  order by
    timestamp;