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

   
   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 f1c16072154f9df7f12f2501b6a80b3e975a05f1, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5500    5132    5137    5132
   q2   390     163     160     160
   q3   1469    1130    1216    1130
   q4   1100    835     816     816
   q5   3148    3061    3059    3059
   q6   223     143     134     134
   q7   987     582     519     519
   q8   2148    2238    2232    2232
   q9   6707    6653    6669    6653
   q10  3172    3219    3098    3098
   q11  353     218     211     211
   q12  384     246     236     236
   q13  4426    3637    3664    3637
   q14  245     219     217     217
   q15  595     552     555     552
   q16  453     399     400     399
   q17  1037    469     509     469
   q18  7058    6807    6795    6795
   q19  1648    1545    1516    1516
   q20  587     337     343     337
   q21  2884    2451    2468    2451
   q22  385     334     316     316
   Total cold run time: 44899 ms
   Total hot run time: 40069 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5160    5077    5078    5077
   q2   334     265     246     246
   q3   3365    3318    3290    3290
   q4   2131    2050    2015    2015
   q5   5922    5907    5948    5907
   q6   230     125     127     125
   q7   2409    1913    1940    1913
   q8   3553    3669    3653    3653
   q9   9057    8979    8959    8959
   q10  3955    3942    3930    3930
   q11  586     500     482     482
   q12  819     650     634     634
   q13  3901    3229    3186    3186
   q14  318     275     281     275
   q15  604     533     544     533
   q16  569     519     527     519
   q17  2034    1809    1851    1809
   q18  8735    8290    8458    8290
   q19  1740    1672    1684    1672
   q20  2290    1994    1982    1982
   q21  5729    5342    5348    5342
   q22  581     530     469     469
   Total cold run time: 64022 ms
   Total hot run time: 60308 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