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 exclusively supported for Redshift databases. However, we have plans to expand its availability to more databases in the near future.
How to Use Explain Plan Visualization?
Begin by clicking the "Explain Plan" button before executing your query to assess its performance.
Resize Explain Plan Visualization
Upon receiving the Explain Plan graphical view, you can enlarge it by clicking the "Full Screen View" button.
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.
Extended Node Information
If you want more details about each node, click the info 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.