The dashboard profile is the starting point to understand the set of queries that run for any dashboard within Arcadia.
To obtain the profile you can simply type : CTRL+SHIFT+G
For an overview you can refer to this online doc:
Example dashboard profile
Here’s an example of the profile within Arcadia 4.5 release. When queries run on the back-end engine they will include pink bars which indicate status. Red vertical line indicates the result sets have been received.
If you hover over the pink status line right before the red line, you will get the statistics about the query including a link to the query profile.
Example query profile
The query profile provides important statistics about the query:
- Execution profile
- Timing statistics
- Memory usage
Note: this will access port 35000 on arcengine process running on the cluster.
If you notice long query times or high memory usage, you might want to consider using Arcadia’s analytical views to optimize.
To enable and start using our “Smart Acceleration” read more here: