Query: rds_db_instance_logging_table

select
  i.db_instance_identifier as "DB Instance Identifier",
  case
    when (
      i.engine like any (array [ 'mariadb', '%mysql' ])
      and i.enabled_cloudwatch_logs_exports ? & array [ 'audit',
      'error',
      'general',
      'slowquery' ]
    )
    or (
      i.engine like any (array [ '%postgres%' ])
      and i.enabled_cloudwatch_logs_exports ? & array [ 'postgresql',
      'upgrade' ]
    )
    or (
      i.engine like 'oracle%'
      and i.enabled_cloudwatch_logs_exports ? & array [ 'alert',
      'audit',
      'trace',
      'listener' ]
    )
    or (
      i.engine = 'sqlserver-ex'
      and i.enabled_cloudwatch_logs_exports ? & array [ 'error' ]
    )
    or (
      i.engine like 'sqlserver%'
      and i.enabled_cloudwatch_logs_exports ? & array [ 'error',
      'agent' ]
    ) then 'Enabled'
    else null
  end as "Logging",
  i.engine as "Engine",
  i.enabled_cloudwatch_logs_exports as "Enabled CW Logs Exports",
  a.title as "Account",
  i.account_id as "Account ID",
  i.region as "Region",
  i.arn as "ARN"
from
  aws_rds_db_instance as i,
  aws_account as a
where
  i.account_id = a.account_id
order by
  i.db_instance_identifier;