RubyMine 2019.2 Help

Creating diagrams

Generate a diagram for a database object

You can create a diagram for a data source, a schema, or a table.

In the Database tool window (View | Tool Windows | Database), right-click a database object and select Diagrams | Show Visualization.

Generate a diagram for a database object

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. RubyMine 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: 5 August 2019