Question: I was looking for setup hibernate or log4j to show me, how long are executed queries in hibernate, which are invoked by hql.

Till now i didn't found anything interesting.

Maybe some of you might help me with this issue ?

Answer: 
There is a simple way (built in `hibernate`) to achieve it. It was fixed by [HHH-3659](https://hibernate.atlassian.net/browse/HHH-3659) in `3.5.4` and `3.6.0.Beta1`.

To go for it, use:

* logging on the package: `org.hibernate.stat` at least on `DEBUG` and
* set hibernate property: `hibernate.generate_statistics=true`

Afterwards all the `SQL`s will be logged including the row count fetched and the time the query execution took.

Moreover if interested, it provides statistics on queries. To have them exposed via `JMX` and see them using `JConsole`, you can use `Hibernate JConsole plugin`, available on: <http://hibernate-jcons.sourceforge.net/>
To log queries with its execution time to log file you may try [Craftsman Spy JDBC Driver](http://zer0.free.fr/craftsman/spy.php) which do exactly same things and has simple [integration with Spring](http://java.dzone.com/articles/logging-spring-jdbc-and).

Another way is to using [Spring Insight](http://www.springsource.org/insight) which shows JDBC/Hibernate calls and many more details.

Related links:

* [How to install Spring Insight](http://vard-lokkur.blogspot.com/2010/10/web-application-profiling-spring.html)
* [How to setup filters](http://static.springsource.com/projects/tc-server/2.5/devedition/htmlsingle/devedition.html#using-filtering-trace-details)