turbot/aws_insights

Query: ebs_volume_top_10_write_ops_avg

Usage

powerpipe query aws_insights.query.ebs_volume_top_10_write_ops_avg

SQL

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

Dashboards

The query is used in the dashboards: