Query: ecs_instance_top10_cpu_past_week

  with top_n as (
    select
      instance_id,
      avg(average)
    from
      alicloud_ecs_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
    alicloud_ecs_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;