The Explain tab displays each Explain step of the query and allows you to export the Explain data.
To view all steps and phase details, you can select All from the Show list. To view less Explain data, select Summary.
| Step Information | Description |
|---|---|
| Step Status Icon | Indicates the status of each Explain step. In the Completed Queries portlet, the icon is always black, indicating completed. |
| 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. |