schema/history/container/cpu.sql from ssube/prometheus-sql-adapter

schema/history/container/cpu.sql

Summary

Maintainability

Test Coverage

Issues
Source
Stats

Issues

SELECT
  a.bucket AS time,
  MAX(a.delta_usage) AS value,
  CONCAT(l.labels->>'namespace', '/', l.labels->>'pod_name') AS metric
FROM agg_container_cpu AS a
JOIN metric_labels AS l
ON l.lid = a.lid
WHERE
  $__timeFilter(bucket) AND
  l.labels->>'__name__' = 'container_cpu_usage_seconds_total' AND
  l.labels ?& array['namespace', 'pod_name'] AND
  l.labels->>'namespace' IN ($namespace)
GROUP BY bucket, metric
ORDER BY bucket, metric;