Query: backup_plans_for_backup_vault

select
  p.arn as backup_plan_arn
from
  aws_backup_vault as v,
  aws_backup_plan as p,
  jsonb_array_elements(backup_plan -> 'Rules') as r
where
  r ->> 'TargetBackupVaultName' = v.name
  and v.arn = $1