Query: compute_instance_security_groups

select
  sg.display_name as "Group Name",
  nid as "Group ID",
  jsonb_array_length(sg.rules) as "Rules"
from
  oci_core_vnic_attachment,
  jsonb_array_elements_text(nsg_ids) as nid
  left join oci_core_network_security_group as sg on sg.id = nid
where
  instance_id = $1;