turbot/azure_insights

Query: compute_disk_top_10_read_ops_avg

Usage

powerpipe query azure_insights.query.compute_disk_top_10_read_ops_avg

SQL

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

Dashboards

The query is used in the dashboards: