[SERVER-83762] [CQF] Should collect timing info for SBE execution plans created by Bonsai Created: 30/Nov/23  Updated: 07/Dec/23  Resolved: 07/Dec/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 7.3.0-rc0

Type: Task Priority: Major - P3
Reporter: Matt Olma Assignee: Hana Pearlman
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Optimization
Backwards Compatibility: Fully Compatible
Sprint: QO 2023-12-25
Participants:

 Description   

The explain outputs for execution stats are inconsistent between CQF and "classic" optimizers.

Specifically, in "executionStats" CQF does not expose "executionTimeMillisEstimate", "executionTimeMicros", "executionTimeNanos".

Although the SBE machinery should be already in place, It seems that the CQF explainer does not expose those fields. This ticket should address this along with extending the corresponding tests.

There are "TODO SERVER-83762" tags in js tests, which need to be addressed.

hana.pearlman@mongodb.com investigated this further and recognized that:
"the problem is this] line, where we only mark that we should collect timing info when expCtx->mayDbProfile. However, the stage builders version of this code checks expCtx->explain too."



 Comments   
Comment by Githook User [ 07/Dec/23 ]

Author:

{'name': 'Hana Pearlman', 'email': 'hana.pearlman@mongodb.com', 'username': 'HanaPearlman'}

Message: SERVER-83762: Collect timing info for execution stats explain of CQF plans

GitOrigin-RevId: 94edc00a1b18adb5542588ba0bcc5f501256fa2d
Branch: master
https://github.com/mongodb/mongo/commit/775a634d287694e910fa5092a2153e90e3e96a9e

Generated at Thu Feb 08 06:53:04 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.