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

   
   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 5b4a8655789fbc6ef8161a0ade5f570732ee6bf0, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5573    5137    5194    5137
   q2   397     167     158     158
   q3   1461    1218    1152    1152
   q4   1067    742     805     742
   q5   3082    3098    3151    3098
   q6   224     137     134     134
   q7   995     565     516     516
   q8   2162    2250    2241    2241
   q9   6678    6698    6665    6665
   q10  3182    3123    3129    3123
   q11  355     209     213     209
   q12  374     231     234     231
   q13  4371    3631    3663    3631
   q14  247     222     207     207
   q15  586     543     518     518
   q16  465     405     421     405
   q17  1054    625     463     463
   q18  7116    6712    6842    6712
   q19  1647    1508    1405    1405
   q20  566     329     329     329
   q21  2950    2484    2423    2423
   q22  382     336     333     333
   Total cold run time: 44934 ms
   Total hot run time: 39832 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5133    5078    5031    5031
   q2   340     239     237     237
   q3   3356    3336    3316    3316
   q4   2163    2057    2047    2047
   q5   5953    5897    5912    5897
   q6   220     128     125     125
   q7   2403    1933    1977    1933
   q8   3589    3684    3675    3675
   q9   9090    8932    9007    8932
   q10  3855    3906    3922    3906
   q11  576     481     469     469
   q12  795     650     634     634
   q13  3882    3198    3193    3193
   q14  312     267     263     263
   q15  604     530     524     524
   q16  557     541     515     515
   q17  2034    1802    1830    1802
   q18  8747    8381    8326    8326
   q19  1737    1682    1694    1682
   q20  2248    1977    1961    1961
   q21  5697    5291    5413    5291
   q22  557     488     454     454
   Total cold run time: 63848 ms
   Total hot run time: 60213 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