Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-82899

Investigate SBE bucket level filters being slower than classic

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 7.3.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution
    • Fully Compatible
    • 35

      The following agg pipeline on the TSBS dataset is ~30% slower in SBE with block processing than it is in classic.

      [
        {
          $match:
            {
              $and:
                [
                  { usage_user: { $gte: 0, $lt: 20 } },
                  { usage_system: { $gte: 20, $lt: 35 } },
                  { usage_idle: { $gte: 35, $lt: 50 } },
                  { usage_nice: { $gte: 50, $lt: 65 } },
                  { usage_iowait : { $gte: 65, $lt: 80 } },
                  { usage_steal: { $gte: 80, $lt: 90 } },
                  { usage_guest: { $gte: 90, $lt: 100 } },
                ],
            },
        },
        { $count: "count" }
      ]
      

      This should only be investigated once the linked issue is closed, since SBE block processing will currently unpack every bucket which makes it orders of magnitude slower than classic.

            Assignee:
            ian.boros@mongodb.com Ian Boros
            Reporter:
            parker.felix@mongodb.com Parker Felix
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: