Explain Plan Visualization

The Explain Plan functionality equips you with invaluable insights into your query's performance, offering the key information you need to enhance its efficiency. Additionally, a design advisor is at your disposal, providing recommendations for structural adjustments that can boost the performance of one or more queries.

Please note that, currently, Explain Plan Visualization is supported for Redshift, Snowflake and Trino databases. However, we have plans to expand its availability to more databases shortly.


How to Use Explain Plan Visualization?

Begin by clicking the "Explain Plan" button before executing your query to assess its performance.

Screenshot 2023-09-26 at 10.00.41.png


Resize Explain Plan Visualization

Upon receiving the Explain Plan graphical view, you can enlarge it by clicking the "Full Screen View" button.

Screenshot 2023-09-26 at 10.53.37.png


Node Summaries

Easily pinpoint the most resource-intensive or extensive nodes by selecting either the "Costliest Node" or "Largest Node" in the summary. This action will direct you to the nodes causing the most issues. Furthermore, these nodes are conveniently tagged, making them effortless to locate within the graphical plan representation.

Screenshot 2023-09-26 at 10.56.26.png


Extended Node Information

If you want more details about each node, click the info Screenshot 2023-10-24 at 14.20.59.png icon, which will open a sidebar with additional information. By clicking on the AI Explanation tab, you can access an even more detailed explanation of each node. To achieve this, you need to establish a connection to one of our supported generative AIs. For instructions on how to do that, please refer to the Using the AI Assistant.

Screenshot 2023-11-23 at 14.13.01.png



Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request