Query: ecs_disk_top_10_read_ops_avg

with top_n as (
  select
    instance_id,
    avg(average)
  from
    alicloud_ecs_disk_metric_read_iops_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_disk_metric_read_iops_hourly
where
  timestamp >= CURRENT_DATE - INTERVAL '7 day'
  and instance_id in (
    select
      instance_id
    from
      top_n
  );