[SERVER-59714] Include number of calls to mongot in slow query log Created: 01/Sep/21  Updated: 29/Oct/23  Resolved: 12/Oct/21

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 5.2.0

Type: Improvement Priority: Major - P3
Reporter: Oren Ovadia Assignee: Ted Tuckman
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Backwards Compatibility: Fully Compatible
Sprint: QO 2021-10-18
Participants:

 Description   

Slow query log for $search queries and getMores includes this section today:

“mongot”: {
“cursorid”: 22318,
“timeWaitingMillis”: 36365
} 

I suggest we include the number of getMores calls to mongot performed. For long running queries with a blocking stage such as $group and $sort, this will be very useful for debugging purposes. 

This will be incredibly important if we ever pushdown $limit to mongot, and when mongot will be returning variable batch sizes.

 



 Comments   
Comment by Oren Ovadia [ 13/Oct/21 ]

Thanks Ted!

Comment by Githook User [ 12/Oct/21 ]

Author:

{'name': 'Ted Tuckman', 'email': 'ted.tuckman@mongodb.com', 'username': 'TedTuckman'}

Message: SERVER-59714 Add batch number to task executor cursor
Branch: master
https://github.com/mongodb/mongo/commit/602738c03ec549c5469ad8942ea489b95e83d3d6

Comment by Githook User [ 12/Oct/21 ]

Author:

{'name': 'Ted Tuckman', 'email': 'ted.tuckman@mongodb.com', 'username': 'TedTuckman'}

Message: SERVER-59714 Add batch number to task executor cursor
Branch: master
https://github.com/10gen/mongo-enterprise-modules/commit/2085195eb704258845a4406353a217d43d9df68f

Generated at Thu Feb 08 05:47:56 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.