turbot/alicloud

steampipe plugin install alicloudsteampipe plugin install alicloud

Table: alicloud_rds_instance_metric_connections

Alicloud Monitoring metrics provide data about the performance of your systems. The alicloud_rds_instance_metric_connections 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
db_instance_id,
timestamp,
minimum,
maximum,
average
from
alicloud_rds_instance_metric_connections
order by
db_instance_id,
timestamp;

Intervals where connection exceed 1000 average

select
db_instance_id,
timestamp,
round(minimum::numeric,2) as min_conn,
round(maximum::numeric,2) as max_conn,
round(average::numeric,2) as avg_conn
from
alicloud_rds_instance_metric_connections
where
average > 1000
order by
db_instance_id,
timestamp;

.inspect alicloud_rds_instance_metric_connections

Alicloud RDS Instance Cloud Monitor Metrics - Connections

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