Table: aws_ecs_container_instance

select
  arn,
  ec2_instance_id,
  status,
  status_reason,
  running_tasks_count,
  pending_tasks_count
from
  aws_ecs_container_instance;

select
  arn,
  status,
  status_reason
from
  aws_ecs_container_instance
where
  status = 'REGISTRATION_FAILED';

select
  arn,
  attachment ->> 'id' as attachment_id,
  attachment ->> 'status' as attachment_status,
  attachment ->> 'type' as attachment_type
from
  aws_ecs_container_instance,
  jsonb_array_elements(attachments) as attachment;

select
  arn,
  setting ->> 'Name' as name,
  setting ->> 'Value' as value
from
  aws_ecs_container_instance,
  jsonb_array_elements(attributes) as setting
where
  setting ->> 'Name' = 'ecs.ami-id'
  and setting ->> 'Value' = 'ami-0babb0c4a4e5769b8';