This topic describes how to retrieve a graphical execution plan by using the Visual Explain feature in the Data Management (DMS) console.

Connect to an AnalyticDB for MySQL database by using DMS. On the page as displayed in the following figure, view the execution plan.

图片tp

In the preceding figure, the query execution flow is displayed from the bottom up, following the arrows. The execution plan is decomposed into several substages, as framed in the figure. Data shuffling is required across substages. Each substage contains the operators that are used in the query and the number of rows examined and produced.

The execution plan displayed in the DMS console includes the join order, and some main operators including the join type, join method, access method, data shuffle, and aggregation.