• Sergei Petrunia's avatar
    MDEV-18478 ANALYZE for statement should show selectivity of ICP, part#2 · 0940a969
    Sergei Petrunia authored
    Part#2, variant 2: Make the printed r_ values in JSON output consistent.
    After this patch, ANALYZE output has:
    
    - r_index_rows (NEW) - Observed number of rows before ICP or Rowid Filtering
      checks. This is a per-scan average. like r_rows and "rows" are.
    
    - r_rows (AS BEFORE) - Observed number of rows after ICP and Rowid Filtering.
    
    - r_icp_filtered (NEW) - Observed selectivity of ICP condition.
    
    - (AS BEFORE) observed selectivity of Rowid Filter is in
      $.rowid_filter.r_selectivity_pct
    
    - r_total_filtered - Observed combined selectivity: fraction of rows left
      after applying ICP condition, Rowid Filter, and attached_condition.
      This is now comparable with "filtered" and is printed right after it.
    
    - r_filtered (AS BEFORE) - Observed selectivity of "attached_condition".
    
    Tabular ANALYZE output is not changed. Note that JSON's r_filtered and
    r_rows have the same meanings as before and have the same meaning as in
    tabular output.
    0940a969
sql_explain.h 29.3 KB