turbot/oci_insights

Query: blockstorage_boot_volume_top_10_write_ops_avg

Usage

powerpipe query oci_insights.query.blockstorage_boot_volume_top_10_write_ops_avg

SQL

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

Dashboards

The query is used in the dashboards: