How to use HoloWeb to view execution plans and run analysis - Hologres

HoloWeb displays logical and physical execution plans for SQL queries as tree diagrams to help you analyze them more easily. This topic describes how to use the execution plan and run analysis features in HoloWeb to view the execution plan of an SQL statement.

Prerequisites

Purchase a Hologres instance and create a database.

View execution plans

Go to the HoloWeb developer page. For more information, see Connect to HoloWeb and run queries.
In the menu bar at the top of the HoloWeb developer page, click SQL Editor.
On the SQL Editor page, click Ad-hoc Query in the upper-left corner.
On the new Ad-hoc Query page, select the created Instance Name and Database. In the SQL query editor, enter the SQL statement whose execution plan you want to view, then click Execution Plan to view the graphical execution plan.
(Optional) On the Plan tab, click the icon in the upper-right corner to switch the execution plan view to a DAG graph.

View run analysis

Run analysis executes and analyzes an SQL statement, returning its detailed physical execution plan and runtime overhead.

Go to the HoloWeb developer page. For more information, see Connect to HoloWeb and run queries.
In the menu bar at the top of the HoloWeb developer page, click SQL Editor.
On the SQL Editor page, click Ad-hoc Query in the upper-left corner.
On the new Ad-hoc Query page, select the created Instance Name and Database. In the SQL query editor, enter the SQL statement whose execution plan you want to view, then click Analyze to view the graphical run analysis.
(Optional) On the Analysis tab, click the icon in the upper-right corner to switch the execution plan view to a DAG graph.

Note
Click an operator on the DAG graph to view its details.