Query: ec2_instance_security_groups

select
  p ->> 'GroupId' as "Group ID",
  p ->> 'GroupName' as "Group Name"
from
  aws_ec2_instance,
  jsonb_array_elements(security_groups) as p
where
  arn = $1;