[SERVER-84295] count time-series collection is very slow, db.collection.count() run COLLSCAN stage. Created: 19/Dec/23  Updated: 15/Jan/24

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

Type: Bug Priority: Major - P3
Reporter: y yz Assignee: Edwin Zhou
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File image-2023-12-19-16-52-07-123.png    
Operating System: ALL
Participants:

 Description   

count  time-series collection is very slow,  db.collection.count() run COLLSCAN stage.



 Comments   
Comment by y yz [ 12/Jan/24 ]

hi, edwin.zhou@mongodb.com 

This is a very serious bug and you should not turn off this PR because count should be retrieved from metadata, not a full table scan.

please open the PR again, thanks.

Comment by Edwin Zhou [ 19/Dec/23 ]

Hi 1147952115@qq.com,

For this issue we'd like to encourage you to start by asking our community for help by posting on the MongoDB Developer Community Forums.

If the discussion there leads you to suspect a bug in the MongoDB server, then we'd want to investigate it as a possible bug here in the SERVER project.

Kind regards,
Edwin

Comment by y yz [ 19/Dec/23 ]

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