diff options
| author | Luis Eduardo Oliveira Lizardo <108760288+mariadb-LuisLizardo@users.noreply.github.com> | 2022-07-18 17:48:01 +0200 |
|---|---|---|
| committer | Sergei Petrunia <sergey@mariadb.com> | 2022-10-26 09:18:29 +0300 |
| commit | ad7631bdce1c25afa8de32d2062cb27bfaf539da (patch) | |
| tree | 191063a28c94b49f8a29c517a4f10f986e444f56 /mysql-test/main/explain_json_format_partitions.result | |
| parent | f45f60636f9b983e927ae81cf6386624e81af822 (diff) | |
| download | mariadb-git-ad7631bdce1c25afa8de32d2062cb27bfaf539da.tar.gz | |
MDEV-28926 Add time spent on query optimizer to JSON ANALYZE (#2193)
* Add query optimizer timer to ANALYZE FORMAT=JSON
* Adapt tests and results
* Change logic to always close the writer after printing query blocks
Diffstat (limited to 'mysql-test/main/explain_json_format_partitions.result')
| -rw-r--r-- | mysql-test/main/explain_json_format_partitions.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/main/explain_json_format_partitions.result b/mysql-test/main/explain_json_format_partitions.result index f164006d756..b76fe29625e 100644 --- a/mysql-test/main/explain_json_format_partitions.result +++ b/mysql-test/main/explain_json_format_partitions.result @@ -29,6 +29,9 @@ EXPLAIN analyze format=json select * from t1 where a in (2,3,4); ANALYZE { + "query_optimization": { + "r_total_time_ms": "REPLACED" + }, "query_block": { "select_id": 1, "r_loops": 1, @@ -55,6 +58,9 @@ ANALYZE analyze format=json update t1 set a=a+10 where a in (2,3,4); ANALYZE { + "query_optimization": { + "r_total_time_ms": "REPLACED" + }, "query_block": { "select_id": 1, "r_total_time_ms": "REPLACED", @@ -76,6 +82,9 @@ ANALYZE analyze format=json delete from t1 where a in (20,30,40); ANALYZE { + "query_optimization": { + "r_total_time_ms": "REPLACED" + }, "query_block": { "select_id": 1, "r_total_time_ms": "REPLACED", |