MySQL Enterprise Monitor 8.0.16 Manual

31.4 Detailed Query Information

Click on an individual query to see more detailed information about the individual query in the Details view.

For more information on Normalization and Statement Digests, see Performance Schema Statement Digests and Sampling.

Note

If you change the context, by selecting another MySQL instance from the All Targets menu, and the selected instance does not contain the statement digest of the originally selected query, an error is displayed.

The details page contains the following elements:

Normalized SQL Statement and Statistics

The Normalized SQL Statement displays the normalized version of the SQL statement, while the Statistics displays useful information on the execution of that statement.

Figure 31.2 Normalized Queries and Statistics

Example of the normalized queries and statistics frames.

Graphs

The statement graph displays the average execution time, number of executions, and the number of rows affected.

Figure 31.3 Statement Detail Graphs

Example of the query details graphs.

Example Statements, Details, and EXPLAIN

The Example Statements distribution chart graphically represents the statement by execution time and time and date. Each point on the chart represents a specific example statement execution time.

Figure 31.4 Example Statements Distribution Chart

Example of the example statements distribution chart.

Statements with an associated EXPLAIN plan are represented by a circle in the Distribution Chart. Squares have no EXPLAIN plan. The red circle or square is the SQL statement with the longest execution time for the specified period. Clicking on a circle or square displays its query text in the original form, execution details, and its EXPLAIN plan, if EXPLAIN is enabled. Selecting one of the points loads the data for that point in the Example details frames:

Figure 31.5 Example Statement and Details

Example of the example statement and details frames.

Figure 31.6 Example EXPLAIN

Example of the EXPLAIN plan.