turbot/alicloud

steampipe plugin install alicloudsteampipe plugin install alicloud

Table: alicloud_rds_instance_metric_connections_daily

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

Control examples

.inspect alicloud_rds_instance_metric_connections_daily

Alicloud RDS Instance Cloud Monitor Metrics - Connections (Daily)

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.