Hi,
I am working on a task in which I need to gather info. on all the SQLs (CRUD) and their execution time per application method call.
My application is developed using play framework, this in turn uses hibernate. I have enabled the Hibernate Statistics, and also in application level I able to retrieve sessionFactory and entity level statistics. But theses statistics are overall count of these many inserts/updates/deletes happened for a specified entity so far. But my requirement is to retrieve the exact SQL/HQL statement and their execution time. Any thoughts on how to get these metrics out of Hibernate?
Please help. Thanks

I really need help on this. Thanks

First I would see if your database-engine provides some profiling tools.
If not, I suggest to use p6spy and/with Jahia JDBC SQL Profiler.
It's both rather old stuff, but I never did find a newer and/or better JDBC SQL Profiler.

Thanks pb00067. I will try out Jahia.
Also I came across "Hibernate Profiler" which gives very detailed metrics. I am set up to develop something similar to that.
Any additional thoughts?
Thanks