-
Type:
Sub-task
-
Resolution: Gone away
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Execution
Group distinct cases into a task. Feel free to split it further if needed.
| when to look | team | high value | variant | task | test | measurement | args | compare_value | base_value | compare_stable_mean | base_stable_mean | compare_stable_std | base_stable_std | percent_change | percent_change_stable_mean_pre_tcmalloc | percent_change_stable_mean | post_tcmalloc_percent_difference |
| before 8.0 | query | perf-mongo-perf-standalone.intel.aws.2023-11 | agg-query-comparison_read_commands | Aggregation.DistinctWithIndex | ops_per_sec | {'thread_level': 4} | 321.0089165 | 407.5318724 | 313.7054018 | 403.4309061 | 15.00419225 | 18.30759946 | -21.23096664 | 17.72710222 | -22.24061244 | -39.96771466 | |
| before 8.0 | query | perf-mongo-perf-standalone.arm.aws.2023-11 | agg-query-comparison_read_commands | Aggregation.DistinctWithIndex | ops_per_sec | {'thread_level': 4} | 175.4321608 | 214.1474478 | 182.3838088 | 230.9510648 | 8.677265709 | 9.173532759 | -18.07879917 | 8.76413404 | -21.029241 | -29.79337504 | |
| before 8.0 | query | perf-mongo-perf-standalone.arm.aws.2023-11 | agg-query-comparison_read_commands | Aggregation.DistinctWithIndex | ops_per_sec | {'thread_level': 2} | 94.1735679 | 113.7684276 | 97.4075431 | 118.8629683 | 4.417804311 | 5.051015727 | -17.22346009 | 7.333480867 | -18.05055477 | -25.38403564 | |
| before 8.0 | query | perf-mongo-perf-standalone.intel.aws.2023-11 | agg-query-comparison_read_commands | Aggregation.DistinctWithIndex | ops_per_sec | {'thread_level': 2} | 186.9318716 | 215.6048861 | 177.4249362 | 213.1479603 | 9.162248186 | 9.860331384 | -13.29887046 | 15.63551331 | -16.75973069 | -32.395244 | |
| before 8.0 | query | perf-mongo-perf-standalone.intel.aws.2023-11 | agg-query-comparison_read_commands | Aggregation.DistinctWithIndex | ops_per_sec | {'thread_level': 8} | 321.4553357 | 387.6041521 | 317.1011934 | 378.5299303 | 12.79904176 | 24.87429549 | -17.06607528 | 22.55724508 | -16.22823769 | -38.78548277 | |
| before 8.0 | query | perf-mongo-perf-standalone.arm.aws.2023-11 | agg-query-comparison_read_commands | Aggregation.DistinctWithIndex | ops_per_sec | {'thread_level': 8} | 182.2259651 | 197.8001031 | 190.1255698 | 212.0954353 | 9.149668645 | 10.47084902 | -7.873675405 | 19.09169954 | -10.35848106 | -29.45018061 | |
| before 8.0 | query | perf-mongo-perf-standalone.arm.aws.2023-11 | agg-query-comparison_read_commands | Aggregation.DistinctWithIndexAndQuery | ops_per_sec | {'thread_level': 4} | 472.0235877 | 593.8188681 | 513.3369294 | 627.7908276 | 54.51898786 | 22.12879464 | -20.51051035 | 5.019179322 | -18.23121542 | -23.25039474 | |
| before 8.0 | query | perf-mongo-perf-standalone.intel.aws.2023-11 | agg-query-comparison_read_commands | Aggregation.DistinctWithIndexAndQuery | ops_per_sec | {'thread_level': 8} | 850.8236454 | 1053.142528 | 844.9992657 | 1029.236282 | 24.6806082 | 32.00298096 | -19.21096883 | 11.25711461 | -17.90036161 | -29.15747622 | |
| before 8.0 | query | perf-mongo-perf-standalone.arm.aws.2023-11 | agg-query-comparison_read_commands | Aggregation.DistinctWithIndexAndQuery | ops_per_sec | {'thread_level': 8} | 489.2203946 | 573.5481304 | 522.5201519 | 617.7730735 | 17.34770767 | 27.12095605 | -14.70281766 | 7.332195018 | -15.41875581 | -22.75095082 | |
| before 8.0 | query | perf-mongo-perf-standalone.arm.aws.2023-11 | agg-query-comparison_read_commands | Aggregation.DistinctWithIndexAndQuery | ops_per_sec | {'thread_level': 2} | 256.5209122 | 298.1675517 | 272.4670346 | 315.8694028 | 24.78345118 | 14.03017729 | -13.96752909 | 6.483621249 | -13.74060537 | -20.22422662 | |
| before 8.0 | query | perf-mongo-perf-standalone.intel.aws.2023-11 | agg-query-comparison_read_commands | Aggregation.DistinctWithoutIndex | ops_per_sec | {'thread_level': 4} | 319.6540753 | 403.1615705 | 307.0049363 | 397.7343969 | 23.47728593 | 20.85929911 | -20.71315852 | 24.81852804 | -22.81157006 | -47.63009809 | |
| before 8.0 | query | perf-mongo-perf-standalone.arm.aws.2023-11 | agg-query-comparison_read_commands | Aggregation.DistinctWithoutIndex | ops_per_sec | {'thread_level': 4} | 173.445472 | 221.4328134 | 180.2043116 | 228.7798043 | 9.651717845 | 7.760417382 | -21.67128738 | 10.51253422 | -21.23242162 | -31.74495584 | |
| before 8.0 | query | perf-mongo-perf-standalone.arm.aws.2023-11 | agg-query-comparison_read_commands | Aggregation.DistinctWithoutIndex | ops_per_sec | {'thread_level': 2} | 90.24841806 | 111.1212095 | 95.79137074 | 116.3690731 | 4.953257884 | 5.250007388 | -18.78380514 | 7.718877626 | -17.6831368 | -25.40201443 | |
| before 8.0 | query | perf-mongo-perf-standalone.intel.aws.2023-11 | agg-query-comparison_read_commands | Aggregation.DistinctWithoutIndex | ops_per_sec | {'thread_level': 2} | 186.5463886 | 216.3163596 | 175.7588085 | 209.1513937 | 10.62350806 | 13.06663983 | -13.76223744 | 16.92587147 | -15.96574835 | -32.89161982 | |
| before 8.0 | query | perf-mongo-perf-standalone.intel.aws.2023-11 | agg-query-comparison_read_commands | Aggregation.DistinctWithoutIndex | ops_per_sec | {'thread_level': 8} | 321.7592514 | 380.5027587 | 315.0043478 | 374.4834062 | 15.028912 | 24.24478576 | -15.43839197 | 24.26604975 | -15.88296235 | -40.1490121 |