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/subselect_cache.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/subselect_cache.result')
| -rw-r--r-- | mysql-test/main/subselect_cache.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/main/subselect_cache.result b/mysql-test/main/subselect_cache.result index e859ebbd2e8..5c2fd3e66fc 100644 --- a/mysql-test/main/subselect_cache.result +++ b/mysql-test/main/subselect_cache.result @@ -44,6 +44,9 @@ analyze format=json select a, (select d from t2 where b=c) from t1; ANALYZE { + "query_optimization": { + "r_total_time_ms": "REPLACED" + }, "query_block": { "select_id": 1, "r_loops": 1, @@ -98,6 +101,9 @@ analyze format=json select a, (select d from t2 where b=c), (select d from t2 where b=c union select 1 order by 1 limit 1) from t1; ANALYZE { + "query_optimization": { + "r_total_time_ms": "REPLACED" + }, "query_block": { "select_id": 1, "r_loops": 1, |