Query: vpc_cidr_blocks

select
  cidr_block as "CIDR Block",
  power(2, 32 - masklen(cidr_block)) as "Total IPs"
from
  alicloud_vpc
where
  vpc_id = $1
union all
select
  b :: cidr as "CIDR Block",
  power(2, 32 - masklen(b :: cidr)) as "Total IPs"
from
  alicloud_vpc,
  jsonb_array_elements_text(secondary_cidr_blocks) as b
where
  vpc_id = $1
union all
select
  (b ->> 'Ipv6CidrBlock') :: cidr as "CIDR Block",
  power(2, 128 - masklen((b ->> 'Ipv6CidrBlock') :: cidr)) as "Total IPs"
from
  alicloud_vpc,
  jsonb_array_elements(ipv6_cidr_blocks) as b
where
  vpc_id = $1;