Hibernate stats

With the Hibernate stats feature the administrator can take control of valuable information about database queries, identifying 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 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.

Note

Time columns are suffixed 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.

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.

In Query statistics, all the database queries executed by the application are shown. The most important column 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.

• On the top right click on  Enable button.

Clear Hibernate stats

• On the top right click on  Clear button.

Disable Hibernate stats

Note

This option is only available when Hibernate stats is running.

• On the top right click on  Disable button.