[hibernate-issues] [JIRA] (HHH-13928) Allow listening to query execution and execution times

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 )