turbot/alicloud

GitHub
steampipe plugin install alicloudsteampipe plugin install alicloud
alicloud_accountalicloud_action_trailalicloud_cas_certificatealicloud_cms_monitor_hostalicloud_cs_kubernetes_clusteralicloud_cs_kubernetes_cluster_nodealicloud_ecs_auto_provisioning_groupalicloud_ecs_autoscaling_groupalicloud_ecs_diskalicloud_ecs_disk_metric_read_iopsalicloud_ecs_disk_metric_read_iops_dailyalicloud_ecs_disk_metric_read_iops_hourlyalicloud_ecs_disk_metric_write_iopsalicloud_ecs_disk_metric_write_iops_dailyalicloud_ecs_disk_metric_write_iops_hourlyalicloud_ecs_imagealicloud_ecs_instancealicloud_ecs_instance_metric_cpu_utilization_dailyalicloud_ecs_instance_metric_cpu_utilization_hourlyalicloud_ecs_key_pairalicloud_ecs_launch_templatealicloud_ecs_network_interfacealicloud_ecs_regionalicloud_ecs_security_groupalicloud_ecs_snapshotalicloud_ecs_zonealicloud_kms_keyalicloud_kms_secretalicloud_oss_bucketalicloud_ram_access_keyalicloud_ram_credential_reportalicloud_ram_groupalicloud_ram_password_policyalicloud_ram_policyalicloud_ram_rolealicloud_ram_security_preferencealicloud_ram_useralicloud_rds_instancealicloud_rds_instance_metric_connectionsalicloud_rds_instance_metric_connections_dailyalicloud_rds_instance_metric_cpu_utilizationalicloud_rds_instance_metric_cpu_utilization_dailyalicloud_rds_instance_metric_cpu_utilization_hourlyalicloud_security_center_field_statisticsalicloud_security_center_versionalicloud_vpcalicloud_vpc_dhcp_options_setalicloud_vpc_eipalicloud_vpc_nat_gatewayalicloud_vpc_network_aclalicloud_vpc_route_entryalicloud_vpc_route_tablealicloud_vpc_ssl_vpn_client_certalicloud_vpc_ssl_vpn_serveralicloud_vpc_vpn_connectionalicloud_vpc_vpn_customer_gatewayalicloud_vpc_vpn_gatewayalicloud_vpc_vswitch

Table: alicloud_ecs_disk_metric_write_iops

Alicloud Monitoring metrics provide data about the performance of your systems. The alicloud_ecs_disk_metric_write_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_write_iops
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
where average > 1000
order by
instance_id,
timestamp;

.inspect alicloud_ecs_disk_metric_write_iops

Alicloud ECS Disk Cloud Monitor Metrics - Write IOPS

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
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 with time zoneThe timestamp used for the data point.