turbot/steampipe-mod-gcp-insights

Query: compute_disk_write_throughput

Usage

powerpipe query gcp_insights.query.compute_disk_write_throughput

SQL

select
timestamp,
(sum / 300) as write_throughput_ops
from
gcp_compute_disk_metric_write_ops
where
timestamp >= current_date - interval '7 day'
and name in (
select
name
from
gcp_compute_disk
where
id = (split_part($1, '/', 1)) :: bigint
and project = split_part($1, '/', 2)
)
order by
timestamp;

Dashboards

The query is used in the dashboards: