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

   
   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 2dfbd8844328d0b91bf26c53dbb93fb9809c3a0e, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5536    5178    5147    5147
   q2   390     164     159     159
   q3   1473    1136    1138    1136
   q4   1089    798     803     798
   q5   3156    3114    3202    3114
   q6   229     136     134     134
   q7   984     570     502     502
   q8   2159    2305    2264    2264
   q9   6701    6706    6677    6677
   q10  3203    3131    3179    3131
   q11  336     226     221     221
   q12  392     237     241     237
   q13  4418    3625    3638    3625
   q14  251     227     215     215
   q15  605     552     548     548
   q16  463     415     395     395
   q17  1045    535     555     535
   q18  7092    6719    6731    6719
   q19  1647    1499    1512    1499
   q20  606     358     344     344
   q21  2907    2432    2571    2432
   q22  386     320     343     320
   Total cold run time: 45068 ms
   Total hot run time: 40152 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5134    5072    5046    5046
   q2   330     227     255     227
   q3   3381    3290    3207    3207
   q4   2137    2041    2004    2004
   q5   5966    5937    5926    5926
   q6   227     124     128     124
   q7   2376    1963    1947    1947
   q8   3579    3661    3673    3661
   q9   9061    8966    8937    8937
   q10  3887    3910    3887    3887
   q11  617     490     489     489
   q12  797     642     622     622
   q13  3884    3172    3156    3156
   q14  302     268     267     267
   q15  598     532     540     532
   q16  543     518     496     496
   q17  2032    1891    1845    1845
   q18  8747    8333    8615    8333
   q19  1744    1700    1696    1696
   q20  2347    2010    1956    1956
   q21  5739    5347    5365    5347
   q22  604     501     468     468
   Total cold run time: 64032 ms
   Total hot run time: 60173 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