turbot/kubernetes_insights

Query: statefulset_pods_detail

Usage

powerpipe query kubernetes_insights.query.statefulset_pods_detail

Steampipe Tables

SQL

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

Params

ArgsNameDefaultDescriptionVariable
$1uid

    Dashboards

    The query is used in the dashboards: