Table: aws_globalaccelerator_listener

select
  title,
  client_affinity,
  port_ranges,
  protocol
from
  aws_globalaccelerator_listener;

select
  title,
  client_affinity,
  port_ranges,
  protocol
from
  aws_globalaccelerator_listener
where
  accelerator_arn = 'arn:aws:globalaccelerator::012345678901:accelerator/1234abcd';

select
  a.name as accelerator_name,
  a.status as accelerator_status,
  l.title as listener_title,
  l.client_affinity as listener_client_affinity,
  l.port_ranges as listener_port_ranges,
  l.protocol as listener_protocol
from
  aws_globalaccelerator_accelerator a,
  aws_globalaccelerator_listener l
where
  l.accelerator_arn = a.arn;

select
  a.name as accelerator_name,
  a.status as accelerator_status,
  l.protocol,
  port_range -> 'FromPort' as from_port,
  port_range -> 'ToPort' as to_port
from
  aws_globalaccelerator_accelerator a,
  aws_globalaccelerator_listener l,
  jsonb_array_elements(l.port_ranges) as port_range
where
  l.accelerator_arn = a.arn
  and l.protocol = 'TCP'
  and (port_range -> 'FromPort') :: int <= 443
  and (port_range -> 'ToPort') :: int >= 443;