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. Debugger Panel

​
Query

  • Connection time: time it took to connect to your database, before the query itself is run
    • If this is too much time, 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 too much time, you should consider looking at your datasets in Explo to see if they can be optimized. If AI is enabled for your account, you can also use it for help with query optimization.
  • 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 miss or 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.

Dataset Debugger
The same debugger view is available on the dataset editor’s query tab in the “Executed Query” section. This view will show you the query that was run with variables inserted and the same statistics as above.

​
Data

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.