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

            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: