Compass explain plan shows no index applied for query, while interpreting it shows index was used

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Incomplete
    • Priority: Major - P3
    • No version
    • Affects Version/s: None
    • Component/s: None
    • None
    • Environment:
      OS: MAC M4 (Sequoia 15.7.4)
      node.js / npm versions: node v18.19.1 / npm 10.2.4

    • Not Needed
    • None
    • Developer Tools

      Problem Statement/Rationale

      Explain plan shows no index applied for query, while interpreting it shows index was used

      Please be sure to attach relevant logs with any sensitive data redacted.

      Steps to Reproduce

      Create aggregation for match, group and project stages, 
      in match two parameters were added for filtering.
       while running aggregation explain plan it shows no index was used, while when interpreting query
      with mongo DB assistant it shows index was used.

      Expected Results

      Result was same, but since mongo explain plan shows index was not getting used.
      we added addition stage of sort before group as found through researching
      which made our query slow, hence post discovering index were used but mongo compass was misleading with message we removed.

      Actual Results

      Same result.

      Additional Notes

      None

        1. image-2026-03-20-14-01-43-853.png
          85 kB
          Rishabh Mankatala
        2. image-2026-03-20-14-05-37-754.png
          105 kB
          Rishabh Mankatala

            Assignee:
            Unassigned
            Reporter:
            Rishabh Mankatala
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: