diff options
| author | Sergei Petrunia <psergey@askmonty.org> | 2020-04-02 11:50:47 +0300 |
|---|---|---|
| committer | Sergei Petrunia <psergey@askmonty.org> | 2020-04-02 11:50:47 +0300 |
| commit | a21900663626647a7b6f4904fa564f05df38ff5f (patch) | |
| tree | f7eb060b1e191b1ba450681290e362c701d569f0 /mysql-test/main/opt_trace.result | |
| parent | bdcecfa22cc2eb255610f5574ff0a91c8d247066 (diff) | |
| download | mariadb-git-a21900663626647a7b6f4904fa564f05df38ff5f.tar.gz | |
MDEV-22014: Rowid Filtering is not displayed well in the optimizer trace
- Print the rowid filters that are available for use with each table.
- Make print_best_access_for_table() print which filter it has picked.
- Make best_access_path() print the filter for considered ref accesses.
Diffstat (limited to 'mysql-test/main/opt_trace.result')
| -rw-r--r-- | mysql-test/main/opt_trace.result | 410 |
1 files changed, 161 insertions, 249 deletions
diff --git a/mysql-test/main/opt_trace.result b/mysql-test/main/opt_trace.result index 110ce60edfd..08c0895e839 100644 --- a/mysql-test/main/opt_trace.result +++ b/mysql-test/main/opt_trace.result @@ -140,8 +140,7 @@ select * from v1 { "type": "scan", "records": 1, "cost": 2.2044, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 1, @@ -286,8 +285,7 @@ select * from (select * from t1 where t1.a=1)q { "type": "scan", "records": 1, "cost": 2.2044, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 1, @@ -438,8 +436,7 @@ select * from v2 { "type": "scan", "records": 1, "cost": 2.2044, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 1, @@ -505,8 +502,7 @@ select * from v2 { "type": "scan", "records": 2, "cost": 2, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 2, @@ -645,8 +641,7 @@ explain select * from v2 { "type": "scan", "records": 10, "cost": 2.022, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 10, @@ -765,8 +760,7 @@ explain select * from v1 { "type": "scan", "records": 10, "cost": 2.022, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 10, @@ -832,8 +826,7 @@ explain select * from v1 { "type": "scan", "records": 10, "cost": 10, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 10, @@ -1004,8 +997,7 @@ explain select * from t1,t2 where t1.a=t2.b+2 and t2.a= t1.b { "type": "scan", "records": 100, "cost": 2.3174, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 100, @@ -1036,8 +1028,7 @@ explain select * from t1,t2 where t1.a=t2.b+2 and t2.a= t1.b { "type": "ref", "records": 1, "cost": 200, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 100, @@ -1062,8 +1053,7 @@ explain select * from t1,t2 where t1.a=t2.b+2 and t2.a= t1.b { "type": "scan", "records": 100, "cost": 2.3174, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 100, @@ -1094,8 +1084,7 @@ explain select * from t1,t2 where t1.a=t2.b+2 and t2.a= t1.b { "type": "ref", "records": 1, "cost": 200, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 100, @@ -1265,8 +1254,7 @@ EXPLAIN SELECT DISTINCT a FROM t1 { "type": "index_merge", "records": 5, "cost": 6.75, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 5, @@ -1456,8 +1444,7 @@ EXPLAIN SELECT MIN(d) FROM t1 where b=2 and c=3 group by a { "type": "scan", "records": 0.5849, "cost": 3.3121, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 0.5849, @@ -1658,8 +1645,7 @@ EXPLAIN SELECT id,MIN(a),MAX(a) FROM t1 WHERE a>=20010104e0 GROUP BY id { "type": "scan", "records": 16, "cost": 2.0312, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 16, @@ -1849,8 +1835,7 @@ EXPLAIN SELECT * FROM t1 WHERE a = 20010104e0 GROUP BY id { "type": "scan", "records": 16, "cost": 2.0312, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 16, @@ -2077,6 +2062,21 @@ explain select * from t1 where a=1 and b=2 order by c limit 1 { } }, { + "table": "t1", + "rowid_filters": [ + { + "key": "a_b", + "build_cost": 2.989, + "rows": 21 + }, + { + "key": "a_c", + "build_cost": 23.969, + "rows": 180 + } + ] + }, + { "selectivity_for_indexes": [ { "index_name": "a_b", @@ -2130,8 +2130,7 @@ explain select * from t1 where a=1 and b=2 order by c limit 1 { "type": "ref", "records": 21, "cost": 22, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 21, @@ -2371,8 +2370,7 @@ select t1.a from t1 left join t2 on t1.a=t2.a { "type": "scan", "records": 4, "cost": 2.0068, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 4, @@ -2498,8 +2496,7 @@ explain select * from t1 left join t2 on t2.a=t1.a { "type": "scan", "records": 4, "cost": 2.0068, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 4, @@ -2528,8 +2525,7 @@ explain select * from t1 left join t2 on t2.a=t1.a { "type": "eq_ref", "records": 1, "cost": 4, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 4, @@ -2689,8 +2685,7 @@ explain select t1.a from t1 left join (t2 join t3 on t2.b=t3.b) on t2.a=t1.a and "type": "scan", "records": 4, "cost": 2.0068, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 4, @@ -2892,8 +2887,7 @@ explain extended select * from t1 where a in (select pk from t10) { "type": "scan", "records": 10, "cost": 2.022, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 10, @@ -2923,8 +2917,7 @@ explain extended select * from t1 where a in (select pk from t10) { "type": "scan", "records": 3, "cost": 2.0066, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 3, @@ -2947,8 +2940,7 @@ explain extended select * from t1 where a in (select pk from t10) { "type": "scan", "records": 10, "cost": 2.022, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 30, @@ -2993,8 +2985,7 @@ explain extended select * from t1 where a in (select pk from t10) { "type": "scan", "records": 10, "cost": 2.022, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 10, @@ -3285,6 +3276,26 @@ explain select * from t1 where pk = 2 and a=5 and b=1 { } }, { + "table": "t1", + "rowid_filters": [ + { + "key": "pk", + "build_cost": 1.1823, + "rows": 1 + }, + { + "key": "pk_a", + "build_cost": 1.1833, + "rows": 1 + }, + { + "key": "pk_a_b", + "build_cost": 1.1843, + "rows": 1 + } + ] + }, + { "selectivity_for_indexes": [ { "index_name": "pk_a_b", @@ -3347,8 +3358,7 @@ explain select * from t1 where pk = 2 and a=5 and b=1 { "type": "ref", "records": 1, "cost": 1.0043, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 1, @@ -3472,8 +3482,7 @@ select f1(a) from t1 { "type": "scan", "records": 4, "cost": 2.0068, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 4, @@ -3571,8 +3580,7 @@ select f2(a) from t1 { "type": "scan", "records": 4, "cost": 2.0068, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 4, @@ -3624,7 +3632,7 @@ a 2 select length(trace) from INFORMATION_SCHEMA.OPTIMIZER_TRACE; length(trace) -2205 +2163 set optimizer_trace_max_mem_size=100; select * from t1; a @@ -3638,7 +3646,7 @@ select * from t1 { "join_preparation": { "select_id": 1, "steps": [ - 2105 0 + 2063 0 set optimizer_trace_max_mem_size=0; select * from t1; a @@ -3646,7 +3654,7 @@ a 2 select * from INFORMATION_SCHEMA.OPTIMIZER_TRACE; QUERY TRACE MISSING_BYTES_BEYOND_MAX_MEM_SIZE INSUFFICIENT_PRIVILEGES -select * from t1 2205 0 +select * from t1 2163 0 drop table t1; set optimizer_trace='enabled=off'; set @@optimizer_trace_max_mem_size= @save_optimizer_trace_max_mem_size; @@ -3954,8 +3962,7 @@ explain delete t0,t1 from t0, t1 where t0.a=t1.a and t1.a<3 { "type": "range", "records": 3, "cost": 1.407, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 3, @@ -3985,8 +3992,7 @@ explain delete t0,t1 from t0, t1 where t0.a=t1.a and t1.a<3 { "type": "ref", "records": 1, "cost": 3.007, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 3, @@ -4011,8 +4017,7 @@ explain delete t0,t1 from t0, t1 where t0.a=t1.a and t1.a<3 { "type": "range", "records": 3, "cost": 1.407, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 3, @@ -4042,8 +4047,7 @@ explain delete t0,t1 from t0, t1 where t0.a=t1.a and t1.a<3 { "type": "ref", "records": 2, "cost": 3.014, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 6, @@ -4182,8 +4186,7 @@ explain select * from (select rand() from t1)q { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 3, @@ -4249,8 +4252,7 @@ explain select * from (select rand() from t1)q { "type": "scan", "records": 3, "cost": 3, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 3, @@ -4458,8 +4460,7 @@ explain select * from t1 where a in (select t_inner_1.a from t1 t_inner_1, t1 t_ "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 3, @@ -4481,8 +4482,7 @@ explain select * from t1 where a in (select t_inner_1.a from t1 t_inner_1, t1 t_ "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 9, @@ -4507,8 +4507,7 @@ explain select * from t1 where a in (select t_inner_1.a from t1 t_inner_1, t1 t_ "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 3, @@ -4538,8 +4537,7 @@ explain select * from t1 where a in (select t_inner_1.a from t1 t_inner_1, t1 t_ "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 3, @@ -4562,8 +4560,7 @@ explain select * from t1 where a in (select t_inner_1.a from t1 t_inner_1, t1 t_ "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 9, @@ -4586,8 +4583,7 @@ explain select * from t1 where a in (select t_inner_1.a from t1 t_inner_1, t1 t_ "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 27, @@ -4632,8 +4628,7 @@ explain select * from t1 where a in (select t_inner_1.a from t1 t_inner_1, t1 t_ "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 9, @@ -4659,8 +4654,7 @@ explain select * from t1 where a in (select t_inner_1.a from t1 t_inner_1, t1 t_ "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 3, @@ -4684,8 +4678,7 @@ explain select * from t1 where a in (select t_inner_1.a from t1 t_inner_1, t1 t_ "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 3, @@ -4993,8 +4986,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 3, @@ -5017,8 +5009,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 9, @@ -5041,8 +5032,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 81, @@ -5079,8 +5069,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 27, @@ -5108,8 +5097,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 81, @@ -5138,8 +5126,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 729, @@ -5184,8 +5171,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 243, @@ -5211,8 +5197,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 9, @@ -5240,8 +5225,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 81, @@ -5270,8 +5254,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 729, @@ -5311,8 +5294,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 81, @@ -5338,8 +5320,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 27, @@ -5365,8 +5346,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 81, @@ -5389,8 +5369,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 729, @@ -5427,8 +5406,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 81, @@ -5457,8 +5435,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 729, @@ -5498,8 +5475,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 243, @@ -5525,8 +5501,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 243, @@ -5554,8 +5529,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 2187, @@ -5584,8 +5558,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 2187, @@ -5611,8 +5584,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 729, @@ -5640,8 +5612,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 2187, @@ -5679,8 +5650,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 6561, @@ -5708,8 +5678,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 27, @@ -5732,8 +5701,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 243, @@ -5761,8 +5729,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 2187, @@ -5791,8 +5758,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 2187, @@ -5818,8 +5784,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 243, @@ -5843,8 +5808,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 243, @@ -5870,8 +5834,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 81, @@ -5894,8 +5857,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 729, @@ -5923,8 +5885,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 2187, @@ -5953,8 +5914,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 6561, @@ -5980,8 +5940,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 243, @@ -6009,8 +5968,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 2187, @@ -6039,8 +5997,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 2187, @@ -6066,8 +6023,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 729, @@ -6095,8 +6051,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 27, @@ -6120,8 +6075,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 27, @@ -6145,8 +6099,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 9, @@ -6170,8 +6123,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 27, @@ -6197,8 +6149,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 3, @@ -6222,8 +6173,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 9, @@ -6247,8 +6197,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 9, @@ -6272,8 +6221,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 3, @@ -6297,8 +6245,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 9, @@ -6612,8 +6559,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 3, @@ -6635,8 +6581,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 27, @@ -6661,8 +6606,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 9, @@ -6689,8 +6633,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 3, @@ -6712,8 +6655,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 27, @@ -6738,8 +6680,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 9, @@ -6769,8 +6710,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 3, @@ -6793,8 +6733,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 9, @@ -6817,8 +6756,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 81, @@ -6860,8 +6798,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 27, @@ -6889,8 +6826,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 81, @@ -6919,8 +6855,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 729, @@ -6970,8 +6905,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 243, @@ -6997,8 +6931,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 9, @@ -7026,8 +6959,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 81, @@ -7056,8 +6988,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 81, @@ -7083,8 +7014,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 27, @@ -7110,8 +7040,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 81, @@ -7135,8 +7064,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 27, @@ -7160,8 +7088,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 81, @@ -7187,8 +7114,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 27, @@ -7212,8 +7138,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 27, @@ -7237,8 +7162,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 9, @@ -7262,8 +7186,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": true, - "filter_used": false + "uses_join_buffering": true } }, "rows_for_plan": 27, @@ -7289,8 +7212,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 3, @@ -7314,8 +7236,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 9, @@ -7339,8 +7260,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 9, @@ -7364,8 +7284,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 3, @@ -7389,8 +7308,7 @@ t_outer_2.a in (select t_inner_3.a from t2 t_inner_3, t1 t_inner_4) { "type": "scan", "records": 9, "cost": 2.0154, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 9, @@ -8083,8 +8001,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) "type": "scan", "records": 5.9375, "cost": 2.8296, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 5.9375, @@ -8115,8 +8032,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) "type": "scan", "records": 804.69, "cost": 256.85, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 4777.8, @@ -8148,8 +8064,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) "type": "scan", "records": 804.69, "cost": 43.26, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 804.69, @@ -8192,8 +8107,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) "type": "scan", "records": 10, "cost": 2.0171, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 10, @@ -8234,8 +8148,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) "type": "ref", "records": 1, "cost": 20, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 10, @@ -8268,8 +8181,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) "type": "scan", "records": 804.69, "cost": 43.26, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 804.69, |