Monitor chart performance

To check a chart’s query performance:

1. Hover over the chart.

2. Select More actions () > Review performance.

A pop-up titled Performance breakdown will appear.

There are two tabs in this pop-up that will help you analyze your chart’s performance: stats and logs.

Stats

View aggregated statistics about your query performance:

• Min query duration - The shortest amount of time taken for one of the chart’s queries to complete

• Avg query duration - The average execution time for all queries in the chart. We don’t recommend using this as the sole indicator for your chart’s performance.

• Max query duration - The longest amount of time taken for one of the chart’s queries to complete

• Query performance - A bar line chart showing the chart’s query performance over the last two weeks:

  • Total query times - A sum of the completion times for all queries that were run for the chart that day

  • Average query times - The average execution time for all queries that were run for the chart that day

  • Total number of queries - A line that plots the number of queries that were run for the chart

Logs

View a full list of the queries that were run for the chart. Each record in the log contains the following details:

• Start time - When the query was run

• Duration - The time (in seconds) it took for the query to complete

• Query - The full SQL query that was run

  • Cause - What triggered the query to run

  • Data source - The data source that is queried

  • If the query failed, the log will show the error that the data source returned.

Use these logs to pinpoint any long-running queries that may need some optimization.