Users can go to the slow log display page by the name of a single-node instance in the console to view the recent slow requests of the instance. The slow log generally contains information such as docsExamined to record the number of documents scanned in this request, and you can use the log information and query statements to determine whether a suitable index is missing.
Users can also use the mongo shell to connect to the DDS instance and then execute explain() to observe whether the query plan meets expectations. Example:
db.coll.find({xxx:xxx}).explain()If the index is missing, you can execute the commands described in the previous section for index creation, and then re-execute the query command to observe whether the execution plan is normal.