log cost time

[LinWanCen]

like

==> Preparing: select...
==> Parameters: ...
<== Total: 1, cost time: 1130ms

[harawata]

Hello @LinWanCen ,

This can be achieved by writing a custom plugin (a.k.a. interceptor).
Please see https://stackoverflow.com/a/76054558/1261766

[harawata]

I hope my answer was satisfactory.

[LinWanCen]

The system is purchased, and they did not write interceptors.

If the framework itself provides simple time, it would be beneficial for slow SQL analysis of each new system.

Of course, it would be even better if the amount of returned data is added.

[harawata]

@LinWanCen ,

At this point, there is no plan to provide such log.

This is not our doc, but see the following section for various ways to obtain slow query logging
https://github.com/brettwooldridge/HikariCP?tab=readme-ov-file#log-statement-text--slow-query-logging