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;