Explo offers a dashboard debugger and also dataset debugger to help with your dashboard building experience. To access the debugger panel, select the right panel button at the top of the dashboard editor or choose the debugger view for the dataset editor.
- Connection time: time it took to connect to your database, before the query itself is run
- If this is long, you should consider performance improvements, like increasing the number of available connections to your database. Reach out to Explo support for suggestions and help.
- Querying time: time it took to run the query in your database
- If this is long, you should consider looking at your datasets in Explo to see if they can be optimized.
- Processing time: time it took for Explo to read the results of the query
- Total runtime: total runtime it took to run and return the query
cache hit: If cache is missed, the query will run in your database and the metrics above will be returned. If cache is hit, the metrics above are not shown as the resulting data is pulled directly from the cache.
The same debugger view is available on the dataset editor right of the preview tab. This view will show you the query that was run with variables inserted and the same statistics as above.
The variables tab shows all the variables you have available to use throughout your dashboard. Variables will automatically show up on this tab when they are created
Create and manage custom variables here, or set test values for those variables by selecting the Edit option.
This tab shows the data returned from the query or cache. The data tab is a great way to double check if the results that are returned are expected. Most of the time, these are the same values that will be reflected on your visualization, but there are certain cases where some light calculations are computed on the frontend after the data is returned.