Query: container_memory_resources

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;