Java OpenResty Spring Spring Boot MySQL Redis MongoDB PostgreSQL Linux Android Nginx 面试 小程序 Arthas JVM AQS juc Kubernetes Docker 诊断工具


Spring Boot JPA 打印 SQL 执行时间

Spring Boot JPA 大约 997 字

需求

打印出JPA执行SQL语句时花费的时间。

添加配置

generate_statistics设置为true,表示生成统计信息。

spring:
  jpa:
    properties:
      hibernate:
        generate_statistics: true

输出:

2022-11-04 12:14:23.563  INFO 20760 --- [           main] i.StatisticalLoggingSessionEventListener : Session Metrics {
    113700 nanoseconds spent acquiring 1 JDBC connections;
    0 nanoseconds spent releasing 0 JDBC connections;
    1928400 nanoseconds spent preparing 2 JDBC statements;
    556300 nanoseconds spent executing 2 JDBC statements;
    0 nanoseconds spent executing 0 JDBC batches;
    0 nanoseconds spent performing 0 L2C puts;
    0 nanoseconds spent performing 0 L2C hits;
    0 nanoseconds spent performing 0 L2C misses;
    5434600 nanoseconds spent executing 1 flushes (flushing a total of 1 entities and 0 collections);
    0 nanoseconds spent executing 0 partial-flushes (flushing a total of 0 entities and 0 collections)
}

参考

https://docs.jboss.org/hibernate/orm/current/userguide/html_single/Hibernate_User_Guide.html

阅读 1042 · 发布于 2023-03-02

————        END        ————

Give me a Star, Thanks:)

https://github.com/fendoudebb

扫描下方二维码关注公众号和小程序↓↓↓

扫描二维码关注我
昵称:
随便看看 换一批