[MDEV-22014] Rowid Filtering is not displayed well in the optimizer trace Created: 2020-03-23  Updated: 2020-04-07  Resolved: 2020-04-02

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Fix Version/s: 10.4.13, 10.5.3

Type: Task Priority: Major
Reporter: Sergei Petrunia Assignee: Sergei Petrunia
Resolution: Fixed Votes: 0
Labels: optimizer_trace, rowid_filtering


 Description   

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.

 Comments   
Comment by Varun Gupta (Inactive) [ 2020-03-29 ]

psergey please make sure to push the patch into 10.4, rowid filtering was there in 10.4. Currently the patch is based on 10.5

Generated at Thu Feb 08 09:11:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.