turbot/kubernetes_insights

Query: pod_container_memory_detail

Usage

powerpipe query kubernetes_insights.query.pod_container_memory_detail

Steampipe Tables

SQL

select
c ->> 'name' as "Name",
replace(c -> 'resources' -> 'limits' ->> 'memory','Mi','') as "Memory Limit (Mi)",
replace(c -> 'resources' -> 'requests' ->> 'memory','Mi','') as "Memory Request (Mi)"
from
kubernetes_pod,
jsonb_array_elements(containers) as c
where
uid = $1
order by
c ->> 'name';

Params

ArgsNameDefaultDescriptionVariable
$1uid

    Dashboards

    The query is used in the dashboards: