terraform/ecc-aws-305-postgresql_log_planner_stats_flag_disabled/red/rds.tf

resource "random_password" "this" {
  length           = 12
  special          = true
  override_special = "!#$%*()-_=+[]{}:?"
}

resource "aws_db_instance" "this" {
  identifier                      = "database-305-red"
  engine                          = "postgres"
  engine_version                  = "13.14"
  instance_class                  = "db.t3.micro"
  allocated_storage               = 10
  storage_type                    = "gp2"
  db_name                         = "red305"
  username                        = "root"
  password                        = random_password.this.result
  skip_final_snapshot             = true
  parameter_group_name            = aws_db_parameter_group.this.id
  enabled_cloudwatch_logs_exports = ["postgresql"]
  depends_on = [aws_db_parameter_group.this]
}

resource "aws_db_parameter_group" "this" {
  name   = "parameter-group-305-red"
  family = "postgres13"

  parameter {
    name  = "log_planner_stats"
    value = "1"
  }
}