steampipe plugin install awssteampipe plugin install aws

Table: aws_ebs_volume_metric_read_ops_hourly

Amazon CloudWatch Metrics provide data about the performance of your systems. The aws_ebs_volume_metric_read_ops_hourly table provides metric statistics at 1 hour intervals for the most recent 60 days.

Examples

Basic info

select
  volume_id,
  timestamp,
  minimum,
  maximum,
  average,
  sum,
  sample_count
from
  aws_ebs_volume_metric_read_ops_hourly
order by
  volume_id,
  timestamp;

Intervals where volumes exceed 1000 average read ops

select
  volume_id,
  timestamp,
  minimum,
  maximum,
  average,
  sum,
  sample_count
from
  aws_ebs_volume_metric_read_ops_hourly
where
  average > 1000
order by
  volume_id,
  timestamp;

Intervals where volumes exceed 8000 max read ops

select
  volume_id,
  timestamp,
  minimum,
  maximum,
  average,
  sum,
  sample_count
from
  aws_ebs_volume_metric_read_ops_hourly
where
  maximum > 8000
order by
  volume_id,
  timestamp;

Intervals where volume average iops exceeds provisioned iops

select
  r.volume_id,
  r.timestamp,
  v.iops as provisioned_iops,
  round(r.average) + round(w.average) as iops_avg,
  round(r.average) as read_ops_avg,
  round(w.average) as write_ops_avg
from
  aws_ebs_volume_metric_read_ops_hourly as r,
  aws_ebs_volume_metric_write_ops_hourly as w,
  aws_ebs_volume as v
where
  r.volume_id = w.volume_id
  and r.timestamp = w.timestamp
  and v.volume_id = r.volume_id
  and r.average + w.average > v.iops
order by
  r.volume_id,
  r.timestamp;

Read, Write, and Total IOPS

select
  r.volume_id,
  r.timestamp,
  round(r.average) + round(w.average) as iops_avg,
  round(r.average) as read_ops_avg,
  round(w.average) as write_ops_avg,
  round(r.maximum) + round(w.maximum) as iops_max,
  round(r.maximum) as read_ops_max,
  round(w.maximum) as write_ops_max,
  round(r.minimum) + round(w.minimum) as iops_min,
  round(r.minimum) as read_ops_min,
  round(w.minimum) as write_ops_min
from
  aws_ebs_volume_metric_read_ops_hourly as r,
  aws_ebs_volume_metric_write_ops_hourly as w
where
  r.volume_id = w.volume_id
  and r.timestamp = w.timestamp
order by
  r.volume_id,
  r.timestamp;

Query examples

ebs_volume_top_10_read_ops_avg

.inspect aws_ebs_volume_metric_read_ops_hourly

AWS EBS Volume Cloudwatch Metrics - Read Ops (Hourly)

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The AWS Account ID in which the resource is located.
average	double precision	The average of the metric values that correspond to the data point.
maximum	double precision	The maximum metric value for the data point.
metric_name	text	The name of the metric.
minimum	double precision	The minimum metric value for the data point.
namespace	text	The metric namespace.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text	The AWS Region in which the resource is located.
sample_count	double precision	The number of metric values that contributed to the aggregate value of this data point.
sum	double precision	The sum of the metric values for the data point.
timestamp	timestamp with time zone	The time stamp used for the data point.
unit	text	The standard unit for the data point.
volume_id	text	The EBS Volume ID.

turbot/aws