Query: ecs_cluster_container_insights_status

select
  container_insights_status,
  count(*)
from
  (
    select
      s ->> 'Value',
      case
        when s ->> 'Name' = 'containerInsights'
        and s ->> 'Value' = 'enabled' then 'enabled'
        else 'disabled'
      end container_insights_status
    from
      aws_ecs_cluster as c,
      jsonb_array_elements(settings) as s
  ) as t
group by
  container_insights_status
order by
  container_insights_status desc;