HoloWeb provides a visual, tree-based representation of both logical and physical execution plans for SQL queries to help you analyze them more easily.
Prerequisites
You have purchased a Hologres instance and created a database.
View an execution plan
Go to the HoloWeb development page. For details, see Connect to HoloWeb and run queries.
In the top navigation bar, 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 your Instance Name and Database. In the SQL editor, enter the SQL statement you want to analyze and click Execution Plan.
Optional: On the Plan tab, click the
icon in the upper-right corner to switch to the DAG view.
View analysis results
The Run for Analysis feature analyzes a SQL statement and returns its detailed physical execution plan and runtime costs.
Go to the HoloWeb development page. For details, see Connect to HoloWeb and run queries.
In the top navigation bar, 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 your Instance Name and Database. In the SQL editor, enter the SQL statement and click Analyze.
Optional: On the Analysis tab, click the
icon in the upper-right corner to switch to the DAG view.NoteClick an operator in the DAG to view its details.