JetBrains Rider 2019.1 Help

Creating diagrams

Build a query plan

  1. Right-click an SQL statement, and select Explain plan.

  2. In the Output pane, click Plan.

  3. By default, you see the tree representation of the query. To see the query plan, click Show Visualization (the Show Visualization button), or press Ctrl+Shift+Alt+U.

Show execution plans

Execution plan is a set of steps that were used to access data in a database. JetBrains Rider supports two types of execution plans:

  • Explain Plan: the result is shown in a mixed tree and table format on a dedicated Plan tab. You can click the Show Visualization icon (the Show Visualization icon) to create a diagram that visualizes the query execution.

  • Explain Plan (Raw): the result is shown in a table format.

To create an execution plan, right-click a query in the database console and select Explain Plan. If you want to create a diagram for the query, click the Show Visualization icon (the Show Visualization icon).

Last modified: 11 June 2019