Slick 3.0 Logging Query Performance

3
votes

Currently I have enabled DEBUG logging on:

slick.backend

It logs the transaction start/end, compiled sql query being run by slick, and success/results.

Can slick provide me information about query running time? Which package should I enable DEBUG mode on, to get this information?

Edit:

I found this link which talks about this not being possible. Does this still hold true?

1
slickslick-3.0

1 Answers

9
votes

Found answer to the question with help of @szeiger. Enable logging on the following package to get timing information on execution of SQL queries in Slick 3.0:

slick.jdbc.JdbcBackend.benchmark

Other useful packages to enable DEBUG logging on:

slick.jdbc.JdbcBackend.statement
slick.jdbc.StatementInvoker.result
slick.compiler.QueryCompilerBenchmark

*Reference:*
https://github.com/slick/slick/blob/master/common-test-resources/logback.xml