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, CommitPreparedTransaction, DataTransfer, Import, PrepareTransaction, and Query |
| 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. |