Uploaded image for project: 'Compass '
  1. Compass
  2. COMPASS-8120

Incorrectly says no index used for count_scan operations in explain plan

    • Type: Icon: Bug Bug
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • 1.43.6
    • Affects Version/s: None
    • Component/s: Explain
    • Environment:
      OS:
      node.js / npm versions:
      Additional info:
    • 2
    • Not Needed
    • Developer Tools

      Problem Statement/Rationale

      Aggregations that are clearly using an index are flagged as no index used

      Please be sure to attach relevant logs with any sensitive data redacted.
      How to retrieve logs for: Compass; Shell

      Steps to Reproduce

      Add an index to collection, run match followed by count stages?

      Expected Results

      Query performance summary correctly shows which index was used

      Actual Results

      "No index available for this query"

      Additional Notes

      Particularly bad looking since "No index..." is right below something that says XXX index keys examined.

            Assignee:
            Unassigned Unassigned
            Reporter:
            taylor.obrien@mongodb.com Taylor O'Brien
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: