Hibernate stats

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

Note

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

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

Caution

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

Information provided by Hibernate stats

Information provided by Hibernate stats are shown in several tables:

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

Note

Time columns are finished with 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 miliseconds.

Tip

When the application presents some performance problem, in most cases it will be caused by some query that need a huge time to complete its execution.

On Query statistics are shown, all the database queries executed by application, 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.

• On right top click on? Enable button.

Clear Hibernate stats

• On right top click on? Clear button.

Disable Hibernate stats

Note

This option is only available when Hibernate stats is running.

• On right top click on? Disable button.