Query: ecs_cluster_container_instances

select
  c.ec2_instance_id as "EC2 Instance ID",
  c.registered_at as "Rgeistered At",
  c.arn as "ARN",
  i.arn as "Instance ARN"
from
  aws_ecs_container_instance as c
  left join aws_ec2_instance as i on c.ec2_instance_id = i.instance_id
where
  cluster_arn = $1
  and c.account_id = split_part($1, ':', 5)
  and c.region = split_part($1, ':', 4)
order by
  ec2_instance_id;