Log history

Dashboard filters and Visualizer provide access to both the raw system logs and to the BQL query logs.

These logs can help you identify:

• What queries were run in order to render the dashboard
• Were queries run against the cache or against the database
• The time it took to receive results

This information can help you optimize your reports and queries.

To use Log History in the dashboard filter, your user account must belong to a group that has Edit Dashboard privileges. To use Log History in Visualizer, your user account must belong to a group that has Visualizer Access privileges.

In Log History you can:

• Set a start and end date for the time frame of the logs you want to view.
• Sort by:

  Timestamp

  Newest to oldest or vice versa.

  Source

  The source of what is tracked in the logs, such as a Visualizer report, KPI, and so on.

  Runtime

  The duration in milliseconds of how long it took the submitted report query to return results.

  Cache Hit

  Whether or not the query was run against the cache, or against the database. In some cases the report or filter was changed, and those results are in cache. Subsequent queries may be executed against the cached results.

• Search by type of source or report name.
• View the BQL query definition.
• View the raw DEBUG and INFO log files.
• Refresh the log list to see the most recent logs.