Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.1Mb
PDF (A4) - 43.2Mb
Man Pages (TGZ) - 295.4Kb
Man Pages (Zip) - 400.6Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  ...  /  The statements_with_runtimes_in_95th_percentile and x$statements_with_runtimes_in_95th_percentile Views

30.4.3.38 The statements_with_runtimes_in_95th_percentile and x$statements_with_runtimes_in_95th_percentile Views

These views list statements with runtimes in the 95th percentile. By default, rows are sorted by descending average latency.

Both views use two helper views, x$ps_digest_avg_latency_distribution and x$ps_digest_95th_percentile_by_avg_us.

The statements_with_runtimes_in_95th_percentile and x$statements_with_runtimes_in_95th_percentile views have these columns:

  • query

    The normalized statement string.

  • db

    The default database for the statement, or NULL if there is none.

  • full_scan

    The total number of full table scans performed by occurrences of the statement.

  • exec_count

    The total number of times the statement has executed.

  • err_count

    The total number of errors produced by occurrences of the statement.

  • warn_count

    The total number of warnings produced by occurrences of the statement.

  • total_latency

    The total wait time of timed occurrences of the statement.

  • max_latency

    The maximum single wait time of timed occurrences of the statement.

  • avg_latency

    The average wait time per timed occurrence of the statement.

  • rows_sent

    The total number of rows returned by occurrences of the statement.

  • rows_sent_avg

    The average number of rows returned per occurrence of the statement.

  • rows_examined

    The total number of rows read from storage engines by occurrences of the statement.

  • rows_examined_avg

    The average number of rows read from storage engines per occurrence of the statement.

  • first_seen

    The time at which the statement was first seen.

  • last_seen

    The time at which the statement was most recently seen.

  • digest

    The statement digest.