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 ( ), right-click a database object and select .
Show execution plans
Execution plan is a set of steps that were used to access data in a database. IntelliJ IDEA 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 () 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 ().