Query: rds_db_instance_logging_status

with logging_enabled as (
  select
    db_instance_identifier as name
  from
    aws_rds_db_instance
  where
    (engine like any (array ['mariadb', '%mysql']) and enabled_cloudwatch_logs_exports ?& array ['audit','error','general','slowquery'] )or
    ( engine like any (array['%postgres%']) and enabled_cloudwatch_logs_exports ?& array ['postgresql','upgrade'] ) or
    ( engine like 'oracle%' and enabled_cloudwatch_logs_exports ?& array ['alert','audit', 'trace','listener'] ) or
    ( engine = 'sqlserver-ex' and enabled_cloudwatch_logs_exports ?& array ['error'] ) or
    ( engine like 'sqlserver%' and enabled_cloudwatch_logs_exports ?& array ['error','agent'] )
),
logging_status as (
  select
    case
      when l.name is not null  then 'enabled'
      else 'disabled' end as db_instance_logging_status
  from
    aws_rds_db_instance as i
    left join logging_enabled as l on i.db_instance_identifier = l.name
)
select
  db_instance_logging_status,
  count(*)
from
  logging_status
group by
  db_instance_logging_status;