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

   
   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 a05bc37b535939dcfa20b0b90a773d6ad407665f, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5556    5107    5169    5107
   q2   408     155     158     155
   q3   1454    1186    1169    1169
   q4   1076    770     719     719
   q5   3121    3051    3062    3051
   q6   229     137     135     135
   q7   979     550     512     512
   q8   2158    2297    2245    2245
   q9   6662    6694    6656    6656
   q10  3190    3135    3149    3135
   q11  355     227     221     221
   q12  374     232     233     232
   q13  4419    3639    3639    3639
   q14  244     214     222     214
   q15  575     534     535     534
   q16  457     399     408     399
   q17  1045    588     508     508
   q18  7098    6725    6757    6725
   q19  1635    1525    1514    1514
   q20  580     345     327     327
   q21  2884    2445    2451    2445
   q22  392     312     335     312
   Total cold run time: 44891 ms
   Total hot run time: 39954 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5112    5112    5075    5075
   q2   344     246     243     243
   q3   3359    3319    3364    3319
   q4   2162    2064    2066    2064
   q5   5941    5893    5876    5876
   q6   229     127     127     127
   q7   2411    1906    1954    1906
   q8   3564    3654    3648    3648
   q9   9049    8983    9014    8983
   q10  3844    3901    3906    3901
   q11  604     476     494     476
   q12  814     665     654     654
   q13  3867    3201    3179    3179
   q14  296     300     285     285
   q15  582     532     531     531
   q16  553     498     497     497
   q17  2051    1826    1830    1826
   q18  8740    8395    8308    8308
   q19  1743    1700    1677    1677
   q20  2281    2007    1979    1979
   q21  5710    5353    5291    5291
   q22  561     488     493     488
   Total cold run time: 63817 ms
   Total hot run time: 60333 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to