Hibernate stats

With the Hibernate stats feature the administrator can take control of valuable information about database queries, finding out performance problems and the possible causes.

By default, the Hibernate stats feature is disabled because log analysis consumes hardware resources.

This feature should only be enabled by an administrator in order to investigate possible performance problems with the application.

Each time the application is restarted all the previous analysis is removed. It's important that when the administrator enables this feature, he or she takes into consideration that the application should not be stopped.

Information provided by Hibernate stats

Information provided by Hibernate stats is shown in several tables:

General data.
Query statistics.
Entity statistics.
Collection statistics.
2nd level cache statistics.

Time columns end with the 'dur.' name:

Max dur (Maximum duration).
Min dur (Minimum duration).
Avr dur (Average duration).
Total dur (Accumulated total time).

Columns with time values are in milliseconds.

When the application experiences a performance problem, in most cases it will be caused by a query that needs a long time to complete its execution.

On Query statistics, all the database queries executed by the application are shown. The most important column value is Max dur., which indicates the maximum duration of the query.