-
Type:
Task
-
Resolution: Fixed
-
Priority:
Major - P3
-
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.
- depends on
-
SERVER-82570 Bucket-level filters in time-series are translated to SBE as trivially "true"
-
- Closed
-