turbot/oci_insights

Query: nosql_table_top_10_read_throttle_count_avg

Usage

powerpipe query oci_insights.query.nosql_table_top_10_read_throttle_count_avg

SQL

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

Dashboards

The query is used in the dashboards: