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

   
   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 6a733bcb71cdd0dcecae47785faffe969063f810, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5402    5113    5171    5113
   q2   390     176     177     176
   q3   1445    1211    1176    1176
   q4   1086    846     758     758
   q5   3133    3107    3044    3044
   q6   221     132     129     129
   q7   982     520     534     520
   q8   2154    2293    2240    2240
   q9   6669    6663    6654    6654
   q10  3157    3118    3150    3118
   q11  338     217     208     208
   q12  385     235     230     230
   q13  4366    3644    3622    3622
   q14  252     230     228     228
   q15  593     552     564     552
   q16  450     418     402     402
   q17  1054    575     541     541
   q18  7069    6774    6712    6712
   q19  1629    1464    1572    1464
   q20  595     364     342     342
   q21  2849    2472    2456    2456
   q22  401     322     324     322
   Total cold run time: 44620 ms
   Total hot run time: 40007 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5126    5056    5044    5044
   q2   332     252     242     242
   q3   3395    3350    3296    3296
   q4   2130    2014    2025    2014
   q5   5951    5915    5948    5915
   q6   229     126     121     121
   q7   2375    1901    1912    1901
   q8   3555    3633    3670    3633
   q9   8992    8995    8978    8978
   q10  3861    3887    3906    3887
   q11  600     476     482     476
   q12  814     633     665     633
   q13  3881    3179    3182    3179
   q14  309     278     279     278
   q15  609     541     557     541
   q16  539     511     523     511
   q17  2069    1797    1821    1797
   q18  8748    8291    8449    8291
   q19  1741    1637    1680    1637
   q20  2278    2008    1983    1983
   q21  5680    5314    5314    5314
   q22  582     536     494     494
   Total cold run time: 63796 ms
   Total hot run time: 60165 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