turbot/alicloud

steampipe plugin install alicloudsteampipe plugin install alicloud

Table: alicloud_ecs_instance_metric_cpu_utilization_daily

Alicloud Monitoring metrics provide data about the performance of your systems. The alicloud_ecs_instance_metric_cpu_utilization_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_instance_metric_cpu_utilization_daily
order by
instance_id,
timestamp;

CPU Over 80% average

select
instance_id,
timestamp,
round(minimum::numeric,2) as min_cpu,
round(maximum::numeric,2) as max_cpu,
round(average::numeric,2) as avg_cpu
from
alicloud_ecs_instance_metric_cpu_utilization_daily
where average > 80
order by
instance_id,
timestamp;

.inspect alicloud_ecs_instance_metric_cpu_utilization_daily

Alicloud ECS Instance Cloud Monitor Metrics - CPU Utilization (Daily)

NameTypeDescription
averagedouble precisionThe average of the metric values that correspond to the data point.
instance_idtextThe ID of the instance.
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.