Details
-
Task
-
Resolution: Fixed
-
Major - P3
-
None
-
None
-
None
-
Query Execution
-
Fully Compatible
-
35
Description
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.
Attachments
Issue Links
- depends on
-
SERVER-82570 Bucket-level filters in time-series are translated to SBE as trivially "true"
-
- Closed
-