Hi @giribabu_venugopal and welcome to the MongoDB community!!
Could you help with some details on the issues you are observing:
- The error message observed if any while executing the query.
- The output for .explain() for which slow query has been observed.
- Sharded cluster deployment specifications (like no of shard servers, number of mongos etc)
- MongoDB version you are using
- Hardware specifications for the sharded cluster. (eg. disc space, RAM etc).
- Is the deployment On-Prem or an Atlas deployment.
Also, for troubleshooting slow queries in sharded cluster the following documentation can be of help.
- Troubleshoot Sharded Clusters
- Indexes for slow query improvements.
Let us know if you have any further queries.
Best Regards
Aasawari