Query: rds_db_instance_top10_cpu_past_week

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