We have recently upgraded our application to hibernate 6. After upgrade, its taking double the time (it used to take before upgrade) to run the journey. I have printed the stats and have one observation.

**Before upgrade:**

Session Metrics {

**425000** nanoseconds spent acquiring 1 JDBC connections;

0 nanoseconds spent releasing 0 JDBC connections;

**191800** nanoseconds spent preparing 2 JDBC statements;

**5565500** 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;

0 nanoseconds spent executing 0 flushes (flushing a total of 0 entities and 0 collections);

0 nanoseconds spent executing 0 partial-flushes (flushing a total of 0 entities and 0 collections)

}

**After upgrade:**

Session Metrics {

**485400** nanoseconds spent acquiring 1 JDBC connections;

0 nanoseconds spent releasing 0 JDBC connections;

**159100** nanoseconds spent preparing 2 JDBC statements;

**12265000** 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;

0 nanoseconds spent executing 0 flushes (flushing a total of 0 entities and 0 collections);

0 nanoseconds spent executing 0 partial-flushes (flushing a total of 0 entities and 0 collections)

}

The time taken to acquire JDBC connection and to execute statements has increased after upgrade.

Any thing you can suggest on this? Any leads to investigate this issue further will also be helpful. Please let us know if you need any more information. Thanks.