Table: alicloud_vpc_vswitch

select
  name,
  vswitch_id,
  status,
  cidr_block,
  zone_id,
  is_default
from
  alicloud_vpc_vswitch;

select
  name,
  vswitch_id,
  available_ip_address_count,
  power(2, 32 - masklen(cidr_block :: cidr)) -1 as raw_size
from
  alicloud_vpc_vswitch;

select
  name,
  vswitch_id,
  route_table ->> 'RouteTableId' as route_table_id,
  route_table ->> 'RouteTableType' as route_table_type,
  route_table -> 'RouteEntrys' -> 'RouteEntry' as route_entry
from
  alicloud_vpc_vswitch;

select
  vpc_id,
  count(vswitch_id) as vswitch_count
from
  alicloud_vpc_vswitch
group by
  vpc_id;