turbot/alicloud

steampipe plugin install alicloudsteampipe plugin install alicloud

Table: alicloud_ecs_disk_metric_write_iops_daily

Alicloud Monitoring metrics provide data about the performance of your systems. The alicloud_ecs_disk_metric_write_iops_daily table provides metric statistics at 24 hour intervals for the most recent 30 days.

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

Examples

Basic info

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

Intervals where operation exceed 1000 average write 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_write_iops_daily
where average > 1000
order by
instance_id,
timestamp;

.inspect alicloud_ecs_disk_metric_write_iops_daily

Alicloud ECS Disk Cloud Monitor Metrics - Write IOPS (Daily)

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.