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

   
   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 ba42ca239d6b13701f1cdbb2328c172a2f60fbad, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5447    5198    5140    5140
   q2   385     169     162     162
   q3   1479    1189    1186    1186
   q4   1079    887     806     806
   q5   3151    3130    3092    3092
   q6   223     135     135     135
   q7   994     563     519     519
   q8   2149    2261    2269    2261
   q9   6671    6650    6598    6598
   q10  3176    3135    3109    3109
   q11  352     221     220     220
   q12  386     236     242     236
   q13  4399    3613    3653    3613
   q14  246     214     217     214
   q15  606     573     547     547
   q16  446     401     408     401
   q17  1040    594     582     582
   q18  7114    6793    6945    6793
   q19  1638    1518    1600    1518
   q20  613     354     335     335
   q21  2861    2516    2456    2456
   q22  405     333     347     333
   Total cold run time: 44860 ms
   Total hot run time: 40256 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5158    5063    5047    5047
   q2   339     257     254     254
   q3   3377    3325    3286    3286
   q4   2148    2016    1997    1997
   q5   5947    5941    5906    5906
   q6   224     128     130     128
   q7   2369    1901    1891    1891
   q8   3566    3652    3681    3652
   q9   9102    8971    9010    8971
   q10  3884    3922    3925    3922
   q11  590     486     511     486
   q12  791     665     635     635
   q13  3870    3242    3171    3171
   q14  303     268     279     268
   q15  619     567     543     543
   q16  541     508     512     508
   q17  2029    1815    1834    1815
   q18  8741    8315    8420    8315
   q19  1727    1614    1702    1614
   q20  2283    2012    2023    2012
   q21  5747    5391    5282    5282
   q22  580     480     519     480
   Total cold run time: 63935 ms
   Total hot run time: 60183 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