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

   
   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 20194aaa858dc10d2710160cd302c63a4de3f426, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5490    5108    5092    5092
   q2   395     159     154     154
   q3   1459    1197    1129    1129
   q4   1096    809     780     780
   q5   3111    3085    3157    3085
   q6   220     140     131     131
   q7   965     544     547     544
   q8   2166    2129    2192    2129
   q9   6718    6671    6644    6644
   q10  3159    3139    3150    3139
   q11  348     214     230     214
   q12  383     242     237     237
   q13  4436    3655    3675    3655
   q14  249     221     207     207
   q15  598     545     540     540
   q16  457     404     409     404
   q17  1029    514     497     497
   q18  7125    6763    6841    6763
   q19  1640    1571    1425    1425
   q20  545     369     335     335
   q21  2915    2450    2444    2444
   q22  384     337     328     328
   Total cold run time: 44888 ms
   Total hot run time: 39876 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5138    5025    5105    5025
   q2   338     245     256     245
   q3   3385    3352    3296    3296
   q4   2144    2045    2033    2033
   q5   5966    5948    5948    5948
   q6   229     130     125     125
   q7   2393    1970    1935    1935
   q8   3543    3672    3685    3672
   q9   9138    9028    9018    9018
   q10  3898    3919    3925    3919
   q11  599     492     493     492
   q12  822     645     623     623
   q13  3859    3198    3219    3198
   q14  317     300     279     279
   q15  605     553     544     544
   q16  561     521     491     491
   q17  2084    1827    1810    1810
   q18  8769    8331    8378    8331
   q19  1722    1734    1680    1680
   q20  2301    2007    1987    1987
   q21  5716    5306    5307    5306
   q22  601     499     520     499
   Total cold run time: 64128 ms
   Total hot run time: 60456 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