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

Investigate view benchmarks to see if there's any route to improving the overhead of query stats

    • Type: Icon: Task Task
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • 7.1.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Fully Compatible
    • QO 2023-08-07, QO 2023-08-21

      We are seeing some regressions in "Queries.IdentityView.UnindexedLargeInMatching", which probably are caused by us adding an additional parse of an expensive $in query. We should run some benchmarking to confirm the waste and then look to see if there's any way to avoid a re-parse between the query stats store and when we hand it off to run the view as an aggregation.

        1. UnindexedLargeInMatching-QueryStats.png
          UnindexedLargeInMatching-QueryStats.png
          333 kB
        2. UnindexedLargeInMatching.png
          UnindexedLargeInMatching.png
          349 kB
        3. TwoInts-QueryStats.png
          TwoInts-QueryStats.png
          321 kB
        4. TwoInts.png
          TwoInts.png
          319 kB
        5. query_stats_view_query_UnindexedLargeInMatching.svg
          652 kB
        6. query_stats_non_view_query_UnindexedLargeInMatching.svg
          647 kB
        7. perf-test_control_flamegraph_connections_merged-2.svg
          704 kB
        8. perf-test_control_flamegraph_connections_merged-1.svg
          704 kB
        9. perf-test_control_flamegraph_connections_merged.svg
          680 kB
        10. perf-test_control_flamegraph_connections_merged_query_stats.svg
          680 kB
        11. perf-test_control_flamegraph_connections_merged_no_query_stats.svg
          704 kB
        12. IntNonIdFindOne-QueryStats.png
          IntNonIdFindOne-QueryStats.png
          341 kB
        13. IntNonIdFindOne.png
          IntNonIdFindOne.png
          334 kB

            Assignee:
            joshua.lapacik@mongodb.com Joshua Lapacik (Inactive)
            Reporter:
            charlie.swanson@mongodb.com Charlie Swanson
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: