Add a new field (mongos queryShapeHash) to the mongod slow logs

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Done
    • Priority: Major - P3
    • 8.3.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Integration
    • Fully Compatible
    • 0
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      The InTel team is working on associating slow logs from the mongod with query shapes collected on the mongos using the query shape hash. However, the query shape hash may be different on the mongos and mongod for a single request as the query may be modified when the mongos sends the query to the mongod.

      Let's propagate the 'original' mongos query shape hash to the mongod, including for find, distinct, and aggregate requests, and ensure that the mongos query shape hash is added as a field if there are slow logs generated from the query on the mongod. Field name could be "originalQueryShapeHash", but open to discussion.

        1. Screenshot 2025-07-17 at 2.57.48 PM.png
          Screenshot 2025-07-17 at 2.57.48 PM.png
          339 kB

            Assignee:
            Gil Alon
            Reporter:
            Laurel Xiang
            Votes:
            0 Vote for this issue
            Watchers:
            12 Start watching this issue

              Created:
              Updated:
              Resolved: