Explain Plan Page
The table on the Explain Plan page of the Top Sessions drilldown displays the current results for the SELECT statement running during the selected session.
To open the Explain Plan page
- Select the Spotlight on MySQL connection in the Spotlight Browser.
-
Click Top Sessions Page.
- Select a row in the Top Sessions grid.
- Click Explain Plan.
Grid
| Column | Description |
|---|---|
|
ID |
The ID that identifies the specified SELECT statement. |
|
Select Type |
The type of SELECT statement executed. |
|
Table |
The table to which the SELECT statement applies. |
|
Type |
The join type for the SELECT statement. |
|
Possible Keys |
The keys (indexes) that MySQL can use for the SELECT statement. |
|
Key |
The key that MySQL did use for the SELECT statement. |
|
Key Length |
The length of the key that MySQL used. |
|
Ref |
The columns or constants used with the chosen key. |
|
Rows |
The number of table rows that MySQL may examine to execute the query. |