Hibernate stats

The Hibernate Stats feature provides administrators with detailed information about database queries, helping to identify performance problems and their 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 previous analysis data is removed. Ensure the application is not stopped while collecting data.

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).
Avg 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.