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

   
   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 497c2d0c41927dc0cc819aca4ae283bf579cbeaa, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5475    5145    5160    5145
   q2   385     166     159     159
   q3   1461    1128    1115    1115
   q4   1083    804     776     776
   q5   3137    3081    3111    3081
   q6   218     133     133     133
   q7   986     535     535     535
   q8   2176    2289    2225    2225
   q9   6682    6678    6652    6652
   q10  3200    3147    3149    3147
   q11  361     207     211     207
   q12  371     234     232     232
   q13  4360    3618    3637    3618
   q14  254     211     223     211
   q15  577     533     522     522
   q16  460     403     418     403
   q17  1039    519     576     519
   q18  7098    6730    6774    6730
   q19  1626    1525    1437    1437
   q20  556     351     334     334
   q21  2890    2488    2470    2470
   q22  405     334     336     334
   Total cold run time: 44800 ms
   Total hot run time: 39985 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5078    5090    5090    5090
   q2   343     227     233     227
   q3   3368    3317    3309    3309
   q4   2160    2023    2026    2023
   q5   5967    5907    5916    5907
   q6   224     127     127     127
   q7   2406    1932    1962    1932
   q8   3552    3644    3670    3644
   q9   9058    8970    9004    8970
   q10  3865    3888    3885    3885
   q11  592     499     486     486
   q12  809     613     640     613
   q13  3855    3216    3190    3190
   q14  303     305     277     277
   q15  585     531     539     531
   q16  554     491     520     491
   q17  2043    1840    1798    1798
   q18  8733    8307    8274    8274
   q19  1735    1684    1687    1684
   q20  2250    1973    1967    1967
   q21  5769    5314    5323    5314
   q22  590     504     536     504
   Total cold run time: 63839 ms
   Total hot run time: 60243 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