Select the Add execution plan button and browse out to the saved plan to which you want to compare. The current plan will open in the top half of a new window, with the Add execution plan button in the bottom half. Plan comparisonĬomparing query plans can be useful when troubleshooting differences in plan performance, and this can be accomplished in Azure Data Studio by right-clicking on the plan and selecting Compare execution plan. For example, it may be helpful to find all Nested Loop operators in a plan that access a specific database object, or filter on specific values for a given attribute.įor any operator in the list, select the operator name to jump to that operator's location in the query plan (a green box will surround the operator). Within the Top Operations tab, in addition to sorting columns, the Filter window on the right can be used to find operators with a common field value. Toggle to enable or disable tooltips when mousing over operators in the plan Identify the most expensive operator in the plan based on the specified attribute Search for nodes in a plan based on specific attribute valuesĬompare the current execution plan to another plan in a new window View the query plan in XML format in a new window These options are accessed by right-clicking anywhere in the plan, or from the right menu bar. Query plan menu optionsįrom the context of a query plan there are multiple options available for further analysis of a plan.

The Top Operations pane lists the operators in the plan, and sorting is available to identify the most expensive operators based on different attributes. The Plan Tree displays the plan in text format, including sortable columns. The Query Plan tab displays the plan(s) and provides multiple menu options, available on the right side menu bar and via the right-click menu. These tabs are Query Plan, Plan Tree, and Top Operations.

When viewing an estimated or actual plan, three tabs are available in addition to the Results and Messages tab. If you do not select a query and select Run or F5, it will display the actual plans for all queries in the query window.

Postgres query plan