Query: ecs_instance_network_interfaces

select
  p ->> 'NetworkInterfaceId' as "Network Interface ID",
  p ->> 'Type' as "Interface Type",
  p ->> 'PrimaryIpAddress' as "Primary Ip Address",
  private_ip_address as "Private IP Address",
  public_ip_address as "Public IP Address",
  vpc_id as "VPC ID"
from
  alicloud_ecs_instance,
  jsonb_array_elements(network_interfaces) as p
where
  arn = $1
  and account_id = split_part($1, ':', 5)
  and region = split_part($1, ':', 4);