doris-robot commented on PR #29477:
URL: https://github.com/apache/doris/pull/29477#issuecomment-1875229819

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with 
scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
   ```
   Tpch sf100 test result on commit da224cee56207af15d19a45c7c343b60008ff94d, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5440    5109    5086    5086
   q2   400     183     159     159
   q3   1481    1174    1186    1174
   q4   1081    849     769     769
   q5   3182    3101    3123    3101
   q6   224     146     135     135
   q7   993     559     535     535
   q8   2150    2286    2264    2264
   q9   6726    6690    6677    6677
   q10  3167    3103    3109    3103
   q11  354     217     227     217
   q12  387     239     252     239
   q13  4431    3644    3692    3644
   q14  251     210     207     207
   q15  610     556     551     551
   q16  458     425     408     408
   q17  1047    541     586     541
   q18  7088    6748    6792    6748
   q19  1640    1529    1472    1472
   q20  546     383     337     337
   q21  2882    2482    2534    2482
   q22  411     315     318     315
   Total cold run time: 44949 ms
   Total hot run time: 40164 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5090    5050    5027    5027
   q2   335     254     243     243
   q3   3388    3325    3321    3321
   q4   2136    2043    2023    2023
   q5   5961    5914    5955    5914
   q6   222     125     131     125
   q7   2368    1918    1899    1899
   q8   3551    3641    3692    3641
   q9   9092    9028    9030    9028
   q10  3876    3907    3946    3907
   q11  588     519     496     496
   q12  790     681     642     642
   q13  3881    3215    3199    3199
   q14  292     281     272     272
   q15  609     544     546     544
   q16  560     492     530     492
   q17  2012    1810    1798    1798
   q18  8760    8371    8341    8341
   q19  1739    1677    1648    1648
   q20  2305    1979    1984    1979
   q21  5669    5207    5302    5207
   q22  575     481     495     481
   Total cold run time: 63799 ms
   Total hot run time: 60227 ms
   ```
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to