HoloWeb displays logical and physical execution plans of SQL statements in a tree structure to help you analyze the plans. This topic describes how to use plan execution and analysis features of HoloWeb to view execution plans of SQL statements.

Prerequisites

  • An Alibaba Cloud account is created.
  • The real-name verification is complete.
  • A Hologres instance is purchased. For more information, see Purchase a Hologres instance.

View execution plans

  1. Log on to the HoloWeb console. For more information, see HoloWeb quick start.
  2. In the HoloWeb console, click SQL Editor in the top navigation bar.
  3. On the SQL Editor tab, click the Ad-hoc Query icon in the upper-left corner.
  4. On the Ad-hoc Query page, select the instance and database to use from the Instance and Database drop-down lists, enter the SQL statement whose execution plan you want to view in the SQL editor, and then click Explain.
  5. Optional. On the plan tab, click the DAG icon in the upper-right corner to display the execution plan in a directed acyclic graph (DAG).

View the analysis

HoloWeb analyzes SQL statements and returns the physical execution plan and overhead information.

  1. Log on to the HoloWeb console. For more information, see HoloWeb quick start.
  2. In the HoloWeb console, click SQL Editor in the top navigation bar.
  3. On the SQL Editor tab, click the Ad-hoc Query icon in the upper-left corner.
  4. On the Ad-hoc Query page, select the instance and database to use from the Instance and Database drop-down lists, enter the SQL statement whose execution plan you want to view in the SQL editor, and then click Run for Analysis.
  5. Optional. On the Analysis tab, click the DAG icon in the upper-right corner to display the execution plan in a DAG.
    Note You can click an operator in the DAG to view its details.