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/>
If you want a custom solution, you can use the AOP and add an around advice around the hibernate session class if you are executing native queries.