Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-56238

Queries on time field do not use index on time field on non-clustered time-series collections

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Gone away
    • Icon: Minor - P4 Minor - P4
    • None
    • None
    • None
    • None
    • Query Optimization
    • ALL

    Description

      Currently, it is possible for a time-series collection to not be clustered by _id, either by the (undocumented) timeseriesBucketsCollectionClusterById server parameter or if using a storage engine that doesn't support clustered indexes, like ephemeralForTest.

      When this is the case, any queries on the time field appear to use the _id index, even if there is also an index on the time field. See this test.

      Attachments

        Activity

          People

            backlog-query-optimization Backlog - Query Optimization
            gregory.noma@mongodb.com Gregory Noma
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: