Some times query taking exactly 10 seconds of time to execute even there is indexing also and moreover there are around 30k documents in database. What could be reason for that.
what have you done for troubleshooting?
Hello @Durga_Prasad_Gandham ,
Welcome to The MongoDB Community Forums!
In addition to @Kobe_W’s response, can you also share additional details such as:
- MongoDB version
- Query being executed
- Sample documents
- Indexes created
- Run your query with explain in
executionStatsmode (e.g. `db.collection.explain(‘executionStats’).aggregate(…)) and share the output.