diff options
| author | Sergei Petrunia <sergey@mariadb.com> | 2022-11-19 21:00:23 +0300 |
|---|---|---|
| committer | Sergei Petrunia <sergey@mariadb.com> | 2023-02-03 11:01:24 +0300 |
| commit | ffe0beca2557a31758f50fa53ceb9948b6cd6248 (patch) | |
| tree | c1ed3bb3a4190a2fc0a331dee0bd428cea564a30 /mysql-test/include | |
| parent | 657868f5e726e0a5e78d879e4ae50f1d3b5a8d71 (diff) | |
| download | mariadb-git-ffe0beca2557a31758f50fa53ceb9948b6cd6248.tar.gz | |
MDEV-30032: EXPLAIN FORMAT=JSON output: print costs
Basic printout for join and table execution costs.
Diffstat (limited to 'mysql-test/include')
| -rw-r--r-- | mysql-test/include/analyze-format.inc | 2 | ||||
| -rw-r--r-- | mysql-test/include/analyze-no-filtered.inc | 2 | ||||
| -rw-r--r-- | mysql-test/include/explain-no-costs-filtered.inc | 1 | ||||
| -rw-r--r-- | mysql-test/include/explain-no-costs.inc | 1 |
4 files changed, 5 insertions, 1 deletions
diff --git a/mysql-test/include/analyze-format.inc b/mysql-test/include/analyze-format.inc index f9579555d7b..e65450ff001 100644 --- a/mysql-test/include/analyze-format.inc +++ b/mysql-test/include/analyze-format.inc @@ -1,3 +1,3 @@ # The time on ANALYSE FORMAT=JSON is rather variable ---replace_regex /("(r_total_time_ms|r_table_time_ms|r_other_time_ms|r_buffer_size|r_filling_time_ms|r_query_time_in_progress_ms|r_unpack_time_ms)": )[^, \n]*/\1"REPLACED"/ +--replace_regex /("(r_total_time_ms|r_table_time_ms|r_other_time_ms|r_buffer_size|r_filling_time_ms|r_query_time_in_progress_ms|r_unpack_time_ms|cost)": )[^, \n]*/\1"REPLACED"/ diff --git a/mysql-test/include/analyze-no-filtered.inc b/mysql-test/include/analyze-no-filtered.inc new file mode 100644 index 00000000000..eb1663167b2 --- /dev/null +++ b/mysql-test/include/analyze-no-filtered.inc @@ -0,0 +1,2 @@ +--replace_regex /("(filtered|r_total_time_ms|r_table_time_ms|r_other_time_ms|r_buffer_size|r_filling_time_ms|r_query_time_in_progress_ms|r_unpack_time_ms|cost)": )[^, \n]*/\1"REPLACED"/ + diff --git a/mysql-test/include/explain-no-costs-filtered.inc b/mysql-test/include/explain-no-costs-filtered.inc new file mode 100644 index 00000000000..585d8b3fdcc --- /dev/null +++ b/mysql-test/include/explain-no-costs-filtered.inc @@ -0,0 +1 @@ +--replace_regex /("(cost|filtered)": )[^, \n]*/\1"REPLACED"/ diff --git a/mysql-test/include/explain-no-costs.inc b/mysql-test/include/explain-no-costs.inc new file mode 100644 index 00000000000..f2f362b8cbe --- /dev/null +++ b/mysql-test/include/explain-no-costs.inc @@ -0,0 +1 @@ +--replace_regex /("(cost)": )[^, \n]*/\1"COST_REPLACED"/ |