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

   
   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 60527feb72b29d01cb7313ab340b826c55766125, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5461    5161    5089    5089
   q2   379     164     159     159
   q3   1448    1206    1198    1198
   q4   1080    809     778     778
   q5   3129    3095    3130    3095
   q6   223     133     134     133
   q7   967     541     520     520
   q8   2150    2307    2241    2241
   q9   6671    6644    6647    6644
   q10  3174    3144    3134    3134
   q11  349     235     209     209
   q12  380     241     232     232
   q13  4406    3626    3592    3592
   q14  249     221     217     217
   q15  581     536     518     518
   q16  444     390     410     390
   q17  1046    498     546     498
   q18  7075    6791    6794    6791
   q19  1643    1518    1603    1518
   q20  605     329     341     329
   q21  2875    2482    2468    2468
   q22  409     303     341     303
   Total cold run time: 44744 ms
   Total hot run time: 40056 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5087    5044    5050    5044
   q2   338     232     243     232
   q3   3357    3318    3318    3318
   q4   2150    2075    2037    2037
   q5   5927    5904    5910    5904
   q6   223     127     126     126
   q7   2393    1959    1914    1914
   q8   3551    3708    3670    3670
   q9   9051    8971    9023    8971
   q10  3864    3930    3903    3903
   q11  586     473     499     473
   q12  810     625     655     625
   q13  3866    3155    3184    3155
   q14  289     260     264     260
   q15  591     532     534     532
   q16  550     502     500     500
   q17  2003    1801    1874    1801
   q18  8829    8463    8581    8463
   q19  1731    1684    1701    1684
   q20  2271    1994    1972    1972
   q21  5741    5303    5262    5262
   q22  564     543     527     527
   Total cold run time: 63772 ms
   Total hot run time: 60373 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