druid 打印慢 sql 日志

依赖包

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.1.16</version>
</dependency>

在 application.yml 中配置 StatFilter 相关

debug: false
spring:
  aop:
    proxy-target-class: true
  datasource:
    url: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=bkimDB)))
    username: test
    password: f5AOzZUQ/nGxSSc0iYT0yRlq9+21dzQNHkdv+IKlkIf/I99NZdiAh/3vzUCjRg005FSb0T/LjqwoWuvqzPrv5g==
    druid:
      initial-size: 1
      min-idle: 1
      max-active: 3
      max-wait: 60000
      keep-alive: true
      time-between-eviction-runs-millis: 60000
      min-evictable-idle-time-millis: 300000
      validation-query: SELECT 'x' FROM DUAL
      test-while-idle: true
      test-on-borrow: false
      test-on-return: false
      pool-prepared-statements: true
      max-pool-prepared-statement-per-connection-size: 20
      filter:
        wall:
          enabled: true
        stat:
          enabled: true
          log-slow-sql: true
          slow-sql-millis: 10
        config:
          enabled: true
      stat-view-servlet:
        enabled: false
      web-stat-filter:
        enabled: false
      connection-properties: config.decrypt=true;config.decrypt.key=MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAJqw3NwlMJmXvcUbhlOn7VttbKPegs99ToSlKhlvDf4YD04OaD86/csdIVHgKcaCkYWfY3XIh/vJtUOf/QEwG+0CAwEAAQ==
  jpa:
    database: oracle
    properties:
      hibernate:
        dialect: org.hibernate.dialect.Oracle10gDialect

关键配置是

spring:
  datasource:
    druid:
      filter:
        stat:
          enabled: true
          log-slow-sql: true
          slow-sql-millis: 10

慢 sql 日志

19-04-18 15:09:46 ERROR pool-2-thread-1 com.alibaba.druid.filter.stat.StatFilter.internalAfterStatementExecute(478) | slow sql 20 millis. select * from ( select token0_.id as id1_0_, token0_.curr as curr2_0_, token0_.ip as ip3_0_, token0_.serviceno as serviceno4_0_, token0_.ticket as ticket5_0_, token0_.token as token6_0_, token0_.vtime as vtime7_0_ from im_wx_token token0_ where token0_.curr=? and token0_.serviceno=? ) where rownum <= ?["1","gh_de5f1fdc39ec",1]
19-04-18 15:09:46 ERROR pool-2-thread-1 com.alibaba.druid.filter.stat.StatFilter.internalAfterStatementExecute(478) | slow sql 11 millis. select token0_.id as id1_0_0_, token0_.curr as curr2_0_0_, token0_.ip as ip3_0_0_, token0_.serviceno as serviceno4_0_0_, token0_.ticket as ticket5_0_0_, token0_.token as token6_0_0_, token0_.vtime as vtime7_0_0_ from im_wx_token token0_ where token0_.id=?[303547228245069824]