diff options
| author | Sergei Petrunia <psergey@askmonty.org> | 2020-03-29 13:31:52 +0300 |
|---|---|---|
| committer | Sergei Petrunia <psergey@askmonty.org> | 2020-03-29 13:31:52 +0300 |
| commit | 5c7121f199ea418b2056e08372f6d313b0d8ef85 (patch) | |
| tree | 95469a7b666e578e40246d1d36fa54a089777eff /sql/sql_select.cc | |
| parent | 6297a1026db4032ab7b7e28788d0b5b9a1f32aa3 (diff) | |
| download | mariadb-git-bb-10.5-mdev22014.tar.gz | |
MDEV-22014: Rowid Filtering is not displayed well in the optimizer tracebb-10.5-mdev22014
- 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 'sql/sql_select.cc')
| -rw-r--r-- | sql/sql_select.cc | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/sql_select.cc b/sql/sql_select.cc index 35b5665d1d0..d8d984404cd 100644 --- a/sql/sql_select.cc +++ b/sql/sql_select.cc @@ -7756,6 +7756,8 @@ best_access_path(JOIN *join, filter->get_cmp_gain(rows); tmp-= filter->get_adjusted_gain(rows) - filter->get_cmp_gain(rows); DBUG_ASSERT(tmp >= 0); + trace_access_idx.add("rowid_filter_key", + s->table->key_info[filter->key_no].name); } } trace_access_idx.add("rows", records).add("cost", tmp); |