[MDEV-22014] Rowid Filtering is not displayed well in the optimizer trace - Jira

XML

Word

Printable

Optimizer trace doesn't show much information about Rowid Filtering. The only thing one can see is the chosen ref access method in best_access_path:

+                  "chosen_access_method": {

+                    "type": "ref",

+                    "records": 138,

+                    "cost": 91,

+                    "uses_join_buffering": false,

+                    "filter_used": true

+                  }

Note that if one looks above, it is not even shown for the considered methods:

+                    {

+                      "access_type": "ref",

+                      "index": "ux_pk1_fd5",

+                      "used_range_estimates": true,

+                      "rows": 138,

+                      "cost": 91,

+                      "chosen": true

+                    },

This task is about fixing this.

Estimated:

Not Specified

Remaining:

Logged:

0.75h

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.