Query: service_ip_details

select
  cluster_ip as "Cluster IP",
  l ->> 'ip' as "Load Balancer IP",
  external_ips as "External IPs"
from
  kubernetes_service,
  jsonb_array_elements(load_balancer_ingress) as l
where
  uid = $1
union
select
  cluster_ip as "Cluster IP",
  load_balancer_ingress :: text as "Load Balancer IP",
  external_ips as "External IPs"
from
  kubernetes_service
where
  uid = $1
  and load_balancer_ingress is null;