turbot/kubernetes_insights

Query: pod_by_phase

Usage

powerpipe query kubernetes_insights.query.pod_by_phase

SQL

select
p.phase,
count(p.name) as "pods"
from
kubernetes_pod as p,
kubernetes_namespace as n
where
p.namespace = n.name
and p.context_name = n.context_name
and n.uid = $1
group by
p.phase
order by
p.phase;

Params

ArgsNameDefaultDescriptionVariable
$1uid

    Dashboards

    The query is used in the dashboards: