doobieLogHandler.scala

  implicit val handler: LogHandler = {
    val sqlLogger = LoggerFactory.getLogger(getClass.getName)
    LogHandler {
      case Success(s, a, e1, e2) =>
        sqlLogger.info(s"""Successful Statement Execution:
            |  ${s.lines.dropWhile(_.trim.isEmpty).mkString("\n  ")}
            |
            | arguments = [${a.mkString(", ")}]
            |   elapsed = ${e1.toMillis} ms exec + ${e2.toMillis} ms processing (${(e1 + e2).toMillis} ms total)
          """.stripMargin)

      case ProcessingFailure(s, a, e1, e2, t) =>
        sqlLogger.warn(s"""Failed Resultset Processing:
            |  ${s.lines.dropWhile(_.trim.isEmpty).mkString("\n  ")}
            |
            | arguments = [${a.mkString(", ")}]
            |   elapsed = ${e1.toMillis} ms exec + ${e2.toMillis} ms processing (failed) (${(e1 + e2).toMillis} ms total)
            |
          """.stripMargin)

      case ExecFailure(s, a, e1, t) =>
        sqlLogger.warn(s"""Failed Statement Execution:
            |  ${s.lines.dropWhile(_.trim.isEmpty).mkString("\n  ")}
            |
            | arguments = [${a.mkString(", ")}]
            |   elapsed = ${e1.toMillis} ms exec (failed)
            |   failure = ${t.getMessage}
          """.stripMargin)
    }
  }