Hibernate stats

The Hibernate Stats feature provides administrators with detailed information about database queries, helping to identify performance problems and their possible causes.

Note

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.

Caution

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.

Note

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.

Tip

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.

Enable Hibernate stats

Note

This option is only available when Hibernate stats is stopped.

• At the top right click on Enable button.

Clear Hibernate stats

• At the top right click on Clear button.

Disable Hibernate stats

Note

This option is only available when Hibernate stats is running.

• At the top right click on Disable button.