turbot/kubernetes_insights

Query: container_cpu_resources

Usage

powerpipe query kubernetes_insights.query.container_cpu_resources

Steampipe Tables

SQL

select
'CPU Limit (m)' as label,
replace(c -> 'resources' -> 'limits' ->> 'cpu', 'm', '') as value
from
kubernetes_pod,
jsonb_array_elements(containers) as c
where
concat(c ->> 'name', name) = $1
union all
select
'CPU Request (m)' as label,
replace(c -> 'resources' -> 'requests' ->> 'cpu', 'm', '') as value
from
kubernetes_pod,
jsonb_array_elements(containers) as c
where
concat(c ->> 'name', name) = $1;

Params

ArgsNameDefaultDescriptionVariable
$1name

    Dashboards

    The query is used in the dashboards: