diff options
author | Luis Eduardo Oliveira Lizardo <108760288+mariadb-LuisLizardo@users.noreply.github.com> | 2022-07-18 17:48:01 +0200 |
---|---|---|
committer | GitHub <noreply@github.com> | 2022-07-18 17:48:01 +0200 |
commit | 2ccdfba8ee1af02ab17d4aff366a1c9d1883425b (patch) | |
tree | 03f090e9fe85d673e39453c06d22e2580e78ba26 /mysql-test/suite/federated | |
parent | 88b22356e623fd63aa87273a895521a6e6667bc7 (diff) | |
download | mariadb-git-2ccdfba8ee1af02ab17d4aff366a1c9d1883425b.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/suite/federated')
-rw-r--r-- | mysql-test/suite/federated/federatedx_create_handlers.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/suite/federated/federatedx_create_handlers.result b/mysql-test/suite/federated/federatedx_create_handlers.result index 6dcd53e77c7..8a82df0ddfc 100644 --- a/mysql-test/suite/federated/federatedx_create_handlers.result +++ b/mysql-test/suite/federated/federatedx_create_handlers.result @@ -117,6 +117,9 @@ ANALYZE FORMAT=JSON SELECT id FROM federated.t1 WHERE id < 5; ANALYZE { + "query_optimization": { + "r_total_time_ms": "REPLACED" + }, "query_block": { "select_id": 1, "table": { @@ -223,6 +226,9 @@ FROM federated.t2 GROUP BY name)) t WHERE federated.t3.name=t.name; ANALYZE { + "query_optimization": { + "r_total_time_ms": "REPLACED" + }, "query_block": { "select_id": 1, "r_loops": 1, |