The Explain tab displays the Explain text that shows the progress of a query. Each Explain step has a colored box that indicates the status of the step. This information is read-only. You can also export Explain data.
To view all steps and phase details, click Show all. Alternatively, click Show summary to view a shortened version of the Explain data.
Step Information | Description |
---|---|
Step Status Icon | Indicates the status of each Explain step:
|
Time | Duration of the step |
Type | Category of step, such as Command, Query, SQLMR, and DataTransfer |
Phase/Detail | Summarized or full explanation of query that executes in this step. Can be used to diagnose the cause of the failure or slowness. |