Query: cronjob_pods_detail

select
  pod.name as "Name",
  pod.uid as "UID",
  pod.restart_policy as "Restart Policy",
  pod.node_name as "Node Name"
from
  kubernetes_job as j,
  jsonb_array_elements(j.owner_references) as j_owner,
  kubernetes_pod as pod,
  jsonb_array_elements(pod.owner_references) as pod_owner
where
  j_owner ->> 'uid' = $1
  and pod_owner ->> 'uid' = j.uid
  and j.context_name = pod.context_name
order by
  pod.name;