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

   
   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 393db64fd453dcf349373cda22dac415d07f6d75, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5421    5170    5170    5170
   q2   390     165     159     159
   q3   1460    1153    1198    1153
   q4   1094    851     816     816
   q5   3159    3071    3112    3071
   q6   231     140     139     139
   q7   985     570     529     529
   q8   2175    2315    2237    2237
   q9   6728    6679    6685    6679
   q10  3225    3201    3157    3157
   q11  363     226     224     224
   q12  383     251     242     242
   q13  4359    3619    3663    3619
   q14  247     222     220     220
   q15  618     559     557     557
   q16  463     422     423     422
   q17  1051    539     580     539
   q18  7085    6740    7131    6740
   q19  1656    1581    1589    1581
   q20  637     358     362     358
   q21  2868    2435    2498    2435
   q22  382     315     320     315
   Total cold run time: 44980 ms
   Total hot run time: 40362 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5128    5056    5113    5056
   q2   338     258     263     258
   q3   3407    3355    3330    3330
   q4   2155    2078    2029    2029
   q5   5923    5893    5914    5893
   q6   236     134     134     134
   q7   2408    1927    1894    1894
   q8   3557    3632    3665    3632
   q9   9056    8996    9062    8996
   q10  3909    3939    3946    3939
   q11  596     491     478     478
   q12  800     649     636     636
   q13  3870    3189    3224    3189
   q14  318     271     290     271
   q15  629     547     549     547
   q16  553     516     483     483
   q17  2012    1849    1814    1814
   q18  8724    8336    8386    8336
   q19  1765    1708    1716    1708
   q20  2299    1987    1980    1980
   q21  5658    5307    5310    5307
   q22  597     492     492     492
   Total cold run time: 63938 ms
   Total hot run time: 60402 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