diff options
author | Sergei Petrunia <psergey@askmonty.org> | 2015-03-07 22:47:28 +0300 |
---|---|---|
committer | Sergei Petrunia <psergey@askmonty.org> | 2015-03-07 22:47:28 +0300 |
commit | 1626e0d3d48f56bd91239c4fcbc24595ee3a34e3 (patch) | |
tree | 6d92530c4d9c2f47030be63f9cfc851636107ae5 /mysql-test/r/analyze_format_json.result | |
parent | 2288b84df46501b89a70d7dc3b46020e0af9a95e (diff) | |
download | mariadb-git-1626e0d3d48f56bd91239c4fcbc24595ee3a34e3.tar.gz |
MDEV-7648: Extra data in ANALYZE FORMAT=JSON $stmt
Show total execution time (r_total_time_ms) for various parts of the
query:
1. time spent in SELECTs
2. time spent reading rows from storage engines
#2 currently gets the data from P_S.
Diffstat (limited to 'mysql-test/r/analyze_format_json.result')
-rw-r--r-- | mysql-test/r/analyze_format_json.result | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/r/analyze_format_json.result b/mysql-test/r/analyze_format_json.result index 26625cbb75e..f3694b4278a 100644 --- a/mysql-test/r/analyze_format_json.result +++ b/mysql-test/r/analyze_format_json.result @@ -7,12 +7,15 @@ EXPLAIN { "query_block": { "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", "table": { "table_name": "t0", "access_type": "ALL", "r_loops": 1, "rows": 10, "r_rows": 10, + "r_total_time_ms": "REPLACED", "filtered": 100, "r_filtered": 30, "attached_condition": "(t0.a < 3)" @@ -32,12 +35,15 @@ EXPLAIN { "query_block": { "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", "table": { "table_name": "t0", "access_type": "ALL", "r_loops": 1, "rows": 10, "r_rows": 10, + "r_total_time_ms": "REPLACED", "filtered": 100, "r_filtered": 0, "attached_condition": "((t0.a > 9) and (t0.a is not null))" @@ -69,12 +75,15 @@ EXPLAIN { "query_block": { "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", "table": { "table_name": "t0", "access_type": "ALL", "r_loops": 1, "rows": 10, "r_rows": 10, + "r_total_time_ms": "REPLACED", "filtered": 100, "r_filtered": 100, "attached_condition": "(t0.a is not null)" @@ -90,6 +99,7 @@ EXPLAIN "r_loops": 10, "rows": 1, "r_rows": 1, + "r_total_time_ms": "REPLACED", "filtered": 100, "r_filtered": 40, "attached_condition": "(t1.b < 4)" @@ -107,12 +117,15 @@ EXPLAIN { "query_block": { "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", "table": { "table_name": "tbl1", "access_type": "ALL", "r_loops": 1, "rows": 100, "r_rows": 100, + "r_total_time_ms": "REPLACED", "filtered": 100, "r_filtered": 20, "attached_condition": "(tbl1.b < 20)" @@ -124,6 +137,7 @@ EXPLAIN "r_loops": 1, "rows": 100, "r_rows": 100, + "r_total_time_ms": "REPLACED", "filtered": 100, "r_filtered": 60, "attached_condition": "(tbl2.b < 60)" @@ -140,12 +154,15 @@ EXPLAIN { "query_block": { "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", "table": { "table_name": "tbl1", "access_type": "ALL", "r_loops": 1, "rows": 100, "r_rows": 100, + "r_total_time_ms": "REPLACED", "filtered": 100, "r_filtered": 20, "attached_condition": "(tbl1.b < 20)" @@ -157,6 +174,7 @@ EXPLAIN "r_loops": 1, "rows": 100, "r_rows": 100, + "r_total_time_ms": "REPLACED", "filtered": 100, "r_filtered": 60, "attached_condition": "(tbl2.b < 60)" @@ -182,12 +200,15 @@ EXPLAIN { "query_block": { "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", "table": { "table_name": "t1", "access_type": "ALL", "r_loops": 1, "rows": 10, "r_rows": 10, + "r_total_time_ms": "REPLACED", "filtered": 100, "r_filtered": 100, "attached_condition": "(t1.a is not null)" @@ -203,6 +224,7 @@ EXPLAIN "r_loops": 10, "rows": 2, "r_rows": 0.2, + "r_total_time_ms": "REPLACED", "filtered": 100, "r_filtered": 100, "using_index": true @@ -226,12 +248,15 @@ EXPLAIN { "query_block": { "select_id": 1, + "r_loops": 1, + "r_total_time_ms": "REPLACED", "table": { "table_name": "t1", "access_type": "ALL", "r_loops": 1, "rows": 10, "r_rows": 10, + "r_total_time_ms": "REPLACED", "filtered": 100, "r_filtered": 50, "attached_condition": "(test.t1.a < 5)" |