When a query runs slowly or returns unexpected results, the execution plan shows you exactly how Hologres processes the SQL statement — which operators run, in what order, and where time is spent. HoloWeb provides two complementary views:
-
Execution plan — compiles the SQL statement and displays the logical and physical plan as a tree diagram, without running the query. Use this to inspect query structure and operator relationships before execution.
-
Run analysis — executes the query and returns the detailed physical execution plan with runtime overhead. Use this to identify which operators consume the most time and resources, and to pinpoint performance bottlenecks.
Choose Execution plan to validate query structure without incurring compute costs. Choose Run analysis when you need actual timing data to diagnose slow queries or fix issues such as full table scans or unintended large joins.
Prerequisites
Before you begin, ensure that you have:
View the execution plan
The execution plan compiles the SQL statement and displays its logical and physical structure without running it.
-
Go to the HoloWeb developer page. For details, see Connect to HoloWeb and run queries.
-
In the top menu bar, click SQL Editor.
-
On the SQL Editor page, click Ad-hoc Query in the upper-left corner.
-
On the Ad-hoc Query page, select your Instance Name and Database, enter the SQL statement in the query editor, and then click Execution Plan. HoloWeb displays the graphical execution plan on the Plan tab.
-
(Optional) On the Plan tab, click the
icon in the upper-right corner to switch to a DAG graph view.
View run analysis
Run analysis executes the SQL statement and returns the detailed physical execution plan with runtime overhead, showing you where the query spends its time.
-
Go to the HoloWeb developer page. For details, see Connect to HoloWeb and run queries.
-
In the top menu bar, click SQL Editor.
-
On the SQL Editor page, click Ad-hoc Query in the upper-left corner.
-
On the Ad-hoc Query page, select your Instance Name and Database, enter the SQL statement in the query editor, and then click Analyze. HoloWeb displays the graphical run analysis on the Analysis tab.
-
(Optional) On the Analysis tab, click the
icon in the upper-right corner to switch to a DAG graph view. Click any operator node to view its details.