Philippe Marschall (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%...
) *updated* an issue
Hibernate ORM (
https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYTg3NDg1YzFj...
) / New Feature (
https://hibernate.atlassian.net/browse/HHH-13928?atlOrigin=eyJpIjoiYTg3ND...
) HHH-13928 (
https://hibernate.atlassian.net/browse/HHH-13928?atlOrigin=eyJpIjoiYTg3ND...
) Allow listening to query execution and execution times (
https://hibernate.atlassian.net/browse/HHH-13928?atlOrigin=eyJpIjoiYTg3ND...
)
Change By: Philippe Marschall (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%...
)
When analyzing performance issues it is helpful to know which SQL queries have been
executed and how log they took. The current mechanisms offered by Hibernate are inadequate
for building custom tools.
* slow Slow query logging is not extensible, if you want to have access to the information
you need to write a custom log appender and parse the log message, see [
https://discourse.hibernate.org/t/custom-sqlstatementlogger/3881
|https://discourse.hibernate.org/t/custom-sqlstatementlogger/3881].
* `StatementInspector` does not have access to the execution time
.
In our specific case we would like the generate a JFR event recording the query and
it's its execution time. This can then be combined with other JFR events to find you
which queries for executed for processing a single request, how often they were executed
and how long their execution took.
(
https://hibernate.atlassian.net/browse/HHH-13928#add-comment?atlOrigin=ey...
) Add Comment (
https://hibernate.atlassian.net/browse/HHH-13928#add-comment?atlOrigin=ey...
)
Get Jira notifications on your phone! Download the Jira Cloud app for Android (
https://play.google.com/store/apps/details?id=com.atlassian.android.jira....
) or iOS (
https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em...
) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100124- sha1:7217f9f )