turbot/kubernetes_insights

Query: container_memory_resources

Usage

powerpipe query kubernetes_insights.query.container_memory_resources

Steampipe Tables

SQL

select
'Memory Limit (Mi)' as label,
replace(c -> 'resources' -> 'limits' ->> 'memory','Mi','') as value
from
kubernetes_pod,
jsonb_array_elements(containers) as c
where
concat(c ->> 'name',name) = $1
union all
select
'Memory Request (Mi)' as label,
replace(c -> 'resources' -> 'requests' ->> 'memory','Mi','') 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: