Learn how to add Atlassian Analytics to a site and understand what you need to query data and create charts.
Learn how to connect and manage your connected Atlassian data and external data.
Create or build off of dashboard templates to start analyzing your Atlassian data.
Learn how to create insightful charts and dashboards with your organization’s data.
Learn how to use Visual SQL to create queries and transform data for making charts.
Need feedback on data? Learn how to share charts and dashboards with teammates so they can leave comments.
Learn how to grant resource access to the people who need it.
Learn how to manage your workspace and how to monitor your workspace activity.
You must have permission to edit or manage the dashboard to view its charts’ performance data.
To check a chart’s query performance:
Hover over the chart.
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.
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
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.
Was this helpful?