Logging for workbooks during creation/use (query logger)

The query logger can be used to explicitly activate the logging of certain characteristic values during the creation or use of a workbook or data view, for example the duration of the database queries performed. The results can then be displayed in the browser. The analysis of these values and any SQL statements that are also logged can help to optimize the settings for views or filters of the workbook or to correct errors and thus improve the performance and stability of the workbook.

The logged values correspond to some of the parameters that can be logged during performance logging.

You can make the query logger available to users.

Configuration and requirements

The following requirements must be met in order to use the Query Logger:

  • The Performance-Logging plug-in (PerformanceLogging) must be activated. No further configuration is required!

  • The “Query Logging” application right must be granted.