From 68ed3a81f2113ecdcd5fce0f0cab636d57ff77da Mon Sep 17 00:00:00 2001 From: Sergei Petrunia Date: Sat, 9 Nov 2019 21:03:23 +0300 Subject: MDEV-20854: ANALYZE for statements: not clear where the time is spent Count the "gap" time between table accesses and display it as r_other_time_ms in the "table" element. * The advantage of this approach is that it doesn't add any new my_timer_cycles() calls. * The disadvantage is that the definition of what is done during "other time" is not that clear: it includes checking the WHERE (for this table), constructing index lookup tuple (for the next table) writing to GROUP BY temporary table (as we dont account for that time separately [yet], etc) --- sql/sql_explain.h | 2 ++ 1 file changed, 2 insertions(+) (limited to 'sql/sql_explain.h') diff --git a/sql/sql_explain.h b/sql/sql_explain.h index 3896636f9fd..bd8c8a4d499 100644 --- a/sql/sql_explain.h +++ b/sql/sql_explain.h @@ -835,6 +835,8 @@ public: /* Tracker for reading the table */ Table_access_tracker tracker; Exec_time_tracker op_tracker; + Gap_time_tracker extra_time_tracker; + Table_access_tracker jbuf_tracker; Explain_rowid_filter *rowid_filter; -- cgit v1.2.1