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

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

30.4.3.37 The statements_with_full_table_scans and x$statements_with_full_table_scans Views

These views display normalized statements that have done full table scans. By default, rows are sorted by descending percentage of time a full scan was done and descending total latency.

The statements_with_full_table_scans and x$statements_with_full_table_scans views have these columns:

  • query

    The normalized statement string.

  • db

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

  • exec_count

    The total number of times the statement has executed.

  • total_latency

    The total wait time of timed statement events for the statement.

  • no_index_used_count

    The total number of times no index was used to scan the table.

  • no_good_index_used_count

    The total number of times no good index was used to scan the table.

  • no_index_used_pct

    The percentage of the time no index was used to scan the table.

  • rows_sent

    The total number of rows returned from the table.

  • rows_examined

    The total number of rows read from the storage engine for the table.

  • rows_sent_avg

    The average number of rows returned from the table.

  • rows_examined_avg

    The average number of rows read from the storage engine for the table.

  • 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.