gcp_compute_instance_metric_cpu_utilization_hourly.md

Table: gcp_compute_instance_metric_cpu_utilization_hourly

GCP Monitoring Metrics provide data about the performance of your systems. The gcp_compute_instance_metric_cpu_utilization_hourly table provides metric statistics at 60 minute intervals for the most recent 5 days.

Examples

Basic info

select
  name,
  timestamp,
  minimum,
  maximum,
  average,
  sample_count
from
  gcp_compute_instance_metric_cpu_utilization_hourly
order by
  name,
  timestamp;

CPU Over 80% average

select
  name,
  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
  gcp_compute_instance_metric_cpu_utilization_hourly
where average > 80
order by
  name,
  timestamp;