Table: aws_rds_db_instance_metric_cpu_utilization_hourly

Amazon CloudWatch Metrics provide data about the performance of your systems. The aws_rds_db_instance_metric_cpu_utilization_hourly table provides metric statistics at 1 hour intervals for the most recent 60 days.

Examples

Basic info

select
  db_instance_identifier,
  timestamp,
  minimum,
  maximum,
  average,
  sample_count
from
  aws_rds_db_instance_metric_cpu_utilization_hourly
order by
  db_instance_identifier,
  timestamp;

CPU Over 80% average

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

CPU hourly average < 2%

select
  db_instance_identifier,
  timestamp,
  round(minimum :: numeric, 2) as min_cpu,
  round(maximum :: numeric, 2) as max_cpu,
  round(average :: numeric, 2) as avg_cpu,
  sample_count
from
  aws_rds_db_instance_metric_cpu_utilization_hourly
where
  average < 2
order by
  db_instance_identifier,
  timestamp;

Query examples

rds_db_instance_top10_cpu_past_week

.inspect aws_rds_db_instance_metric_cpu_utilization_hourly

AWS RDS DB Instance Cloudwatch Metrics - CPU Utilization (Hourly)

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The AWS Account ID in which the resource is located.
average	double precision	The average of the metric values that correspond to the data point.
db_instance_identifier	text	The friendly name to identify the DB Instance.
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.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text	The AWS Region in which the resource is located.
sample_count	double precision	The number of metric values that contributed to the aggregate value of this data point.
sum	double precision	The sum of the metric values for the data point.
timestamp	timestamp with time zone	The time stamp used for the data point.
unit	text	The standard unit for the data point.

turbot/aws