turbot/alicloud

steampipe plugin install alicloudsteampipe plugin install alicloud

Table: alicloud_ecs_disk_metric_read_iops

Alicloud Monitoring metrics provide data about the performance of your systems. The alicloud_ecs_disk_metric_read_iops table provides metric statistics at 5 minute intervals for the most recent 5 days.

Note: If the instance is not older than 5 minute then we will not get any metric statistics.

Examples

Basic info

select
instance_id,
timestamp,
minimum,
maximum,
average
from
alicloud_ecs_disk_metric_read_iops
order by
instance_id,
timestamp;

Intervals where operation exceed 1000 average read iops

select
instance_id,
timestamp,
round(minimum::numeric,2) as min_ops,
round(maximum::numeric,2) as max_ops,
round(average::numeric,2) as avg_ops
from
alicloud_ecs_disk_metric_read_iops
where average > 1000
order by
instance_id,
timestamp;

.inspect alicloud_ecs_disk_metric_read_iops

Alicloud ECS Disk Cloud Monitor Metrics - Read IOPS

NameTypeDescription
averagedouble precisionThe average of the metric values that correspond to the data point.
instance_idtextAn unique identifier for the resource.
maximumdouble precisionThe maximum metric value for the data point.
metric_nametextThe name of the metric.
minimumdouble precisionThe minimum metric value for the data point.
namespacetextThe metric namespace.
timestamptimestamp without time zoneThe timestamp used for the data point.