Query: service_by_type

select
  type,
  count(s.name) as "services"
from
  kubernetes_service as s,
  kubernetes_namespace as n
where
  s.namespace = n.name
  and s.context_name = n.context_name
  and n.uid = $1
group by
  type
order by
  type;