Philippe Marschall (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%...
) *created* an issue
Hibernate ORM (
https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYjM3MDVmMzVk...
) / New Feature (
https://hibernate.atlassian.net/browse/HHH-13928?atlOrigin=eyJpIjoiYjM3MD...
) HHH-13928 (
https://hibernate.atlassian.net/browse/HHH-13928?atlOrigin=eyJpIjoiYjM3MD...
) Allow listening to query execution and execution times (
https://hibernate.atlassian.net/browse/HHH-13928?atlOrigin=eyJpIjoiYjM3MD...
)
Issue Type: New Feature Affects Versions: 5.4.13 Assignee: Unassigned Components:
hibernate-core Created: 05/Apr/2020 04:51 AM Priority: Major Reporter: 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 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
* `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 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 )