The Slow Query Log The  Handler_read_next  value for the statement. The  Handler_read_prev  value for the statement. The  Handler_read_rnd  value for the statement. The  Handler_read_rnd_next  value for the statement. The  Sort_merge_passes  value for the statement. The  Sort_range  value for the statement. The  Sort_rows  value for the statement. The  Sort_scan  value for the statement. The  Created_tmp_disk_tables  value for the statement. The  Created_tmp_tables  value for the statement. The statement execution start time. The statement execution end time. A given slow query log file may contain a mix of lines with and without the extra fields added by enabling log_slow_extra . Log file analyzers can determine whether a line contains the additional fields by the field count. Each statement written to the slow query log file is preceded by a  SET  statement that includes a timestamp. As of MySQL 8.0.14, the timestamp indicates when the slow statement began executing. Prior to 8.0.14, the timestamp indicates when the slow statement was logged (which occurs after the statement finishes executing). Passwords in statements written to the slow query log are rewritten by the server not to occur literally in plain text. See Section 6.1.2.3, “Passwords and Logging” . 1066 • Read_next:  N • Read_prev:  N • Read_rnd:  N • Read_rnd_next:  N • Sort_merge_passes:  N • Sort_range_count:  N • Sort_rows:  N • Sort_scan_count:  N • Created_tmp_disk_tables:  N • Created_tmp_tables:  N • Start:  timestamp • End:  timestamp