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_backupalicloud_rds_databasealicloud_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_slb_load_balanceralicloud_vpcalicloud_vpc_dhcp_options_setalicloud_vpc_eipalicloud_vpc_flow_logalicloud_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_rds_instance_metric_cpu_utilization_hourly
Alicloud Monitoring metrics provide data about the performance of your systems. The alicloud_rds_instance_metric_cpu_utilization_hourly table provides metric statistics at 1 hour intervals for the most recent 30 days.
Note: If the instance is not older than 1 hour then we will not get any metric statistics.
Examples
Basic info
select db_instance_id, timestamp, minimum, maximum, averagefrom alicloud_rds_instance_metric_cpu_utilization_hourlyorder by db_instance_id, timestamp;CPU over 80% average
select db_instance_id, timestamp, round(minimum :: numeric, 2) as min_cpu, round(maximum :: numeric, 2) as max_cpu, round(average :: numeric, 2) as avg_cpufrom alicloud_rds_instance_metric_cpu_utilization_hourlywhere average > 80order by db_instance_id, timestamp;Query examples
.inspect alicloud_rds_instance_metric_cpu_utilization_hourly
Alicloud RDS Instance Cloud Monitor Metrics - CPU Utilization (Hourly)
| Name | Type | Description |
|---|---|---|
| _ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
| average | double precision | The average of the metric values that correspond to the data point. |
| db_instance_id | text | The ID of the single instance to query. |
| 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. |
| timestamp | timestamp with time zone | The timestamp used for the data point. |