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

   
   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 b6b2600cd70fdf27f6b0976245565fd581fddc7f, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5540    5176    5228    5176
   q2   393     161     162     161
   q3   1459    1152    1142    1142
   q4   1084    787     843     787
   q5   3144    3124    3131    3124
   q6   222     144     134     134
   q7   986     555     535     535
   q8   2137    2262    2282    2262
   q9   6690    6649    6671    6649
   q10  3205    3163    3154    3154
   q11  335     226     214     214
   q12  381     231     229     229
   q13  4377    3637    3649    3637
   q14  252     211     224     211
   q15  581     526     528     526
   q16  451     429     417     417
   q17  1041    538     454     454
   q18  7070    6747    6745    6745
   q19  1636    1504    1431    1431
   q20  547     341     351     341
   q21  2859    2388    2479    2388
   q22  408     331     332     331
   Total cold run time: 44798 ms
   Total hot run time: 40048 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5149    5143    5103    5103
   q2   340     231     239     231
   q3   3355    3345    3307    3307
   q4   2178    2036    2034    2034
   q5   5961    5932    5933    5932
   q6   225     125     126     125
   q7   2403    1970    1966    1966
   q8   3592    3671    3692    3671
   q9   9007    8985    9014    8985
   q10  3895    3914    3893    3893
   q11  590     486     482     482
   q12  800     620     668     620
   q13  4015    3216    3157    3157
   q14  317     294     274     274
   q15  591     530     528     528
   q16  540     511     500     500
   q17  2035    1804    1856    1804
   q18  8757    8298    8783    8298
   q19  1739    1651    1696    1651
   q20  2263    1991    1991    1991
   q21  5792    5308    5458    5308
   q22  575     480     502     480
   Total cold run time: 64119 ms
   Total hot run time: 60340 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