diff options
Diffstat (limited to 'mysql-test/main/opt_trace_selectivity.result')
| -rw-r--r-- | mysql-test/main/opt_trace_selectivity.result | 36 |
1 files changed, 17 insertions, 19 deletions
diff --git a/mysql-test/main/opt_trace_selectivity.result b/mysql-test/main/opt_trace_selectivity.result index b56a362feb9..e24cd857882 100644 --- a/mysql-test/main/opt_trace_selectivity.result +++ b/mysql-test/main/opt_trace_selectivity.result @@ -54,7 +54,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) "index": "a", "used_range_estimates": true, "rows": 104, - "cost": 78.54062004, + "cost": 0.057629638, "chosen": true }, @@ -63,7 +63,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) "index": "b", "used_range_estimates": true, "rows": 340, - "cost": 255.6327963, + "cost": 0.14153631, "chosen": false, "cause": "cost" }, @@ -73,7 +73,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) "index": "c", "used_range_estimates": true, "rows": 632, - "cost": 475.2468449, + "cost": 0.241743894, "chosen": false, "cause": "cost" }, @@ -81,23 +81,23 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) { "access_type": "index_merge", "rows": 7, - "rows_after_scan": 7, "rows_after_filter": 7, - "cost": 13.79559815, + "rows_out": 7, + "cost": 0.045367017, "chosen": true } ], "chosen_access_method": { "type": "index_merge", - "records_read": 7, - "records_out": 7, - "cost": 13.79559815, + "rows_read": 7, + "rows_out": 7, + "cost": 0.045367017, "uses_join_buffering": false } }, "rows_for_plan": 7, - "cost_for_plan": 13.79559815 + "cost_for_plan": 0.045367017 } ] ] @@ -150,7 +150,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) "index": "a", "used_range_estimates": true, "rows": 6, - "cost": 5.002343464, + "cost": 0.004077342, "chosen": true }, @@ -159,7 +159,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) "index": "b", "used_range_estimates": true, "rows": 232, - "cost": 174.5906139, + "cost": 0.104637894, "chosen": false, "cause": "cost" }, @@ -169,7 +169,7 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) "index": "c", "used_range_estimates": true, "rows": 293, - "cost": 220.3644392, + "cost": 0.125478666, "chosen": false, "cause": "cost" }, @@ -183,16 +183,14 @@ JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) "chosen_access_method": { "type": "ref", - "records_read": 6, - "records_out": 0.6, - "cost": 5.002343464, + "rows_read": 6, + "rows_out": 0.6, + "cost": 0.004077342, "uses_join_buffering": false } }, - "rows_for_plan": 6, - "cost_for_plan": 5.002343464, - "selectivity": 0.1, - "estimated_join_cardinality": 0.6 + "rows_for_plan": 0.6, + "cost_for_plan": 0.004077342 } ] ] |