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

   
   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 7defdb6ebd8b61979ac6849fe87458b1b62f6038, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5498    5155    5133    5133
   q2   398     173     162     162
   q3   1465    1167    1161    1161
   q4   1089    827     779     779
   q5   3107    3131    3078    3078
   q6   227     143     132     132
   q7   983     525     544     525
   q8   2154    2227    2237    2227
   q9   6693    6615    6612    6612
   q10  3194    3099    3207    3099
   q11  360     223     224     223
   q12  390     240     244     240
   q13  4406    3685    3676    3676
   q14  258     225     210     210
   q15  610     568     548     548
   q16  448     395     396     395
   q17  1034    519     480     480
   q18  7162    6758    6786    6758
   q19  1644    1568    1421    1421
   q20  547     359     353     353
   q21  2899    2464    2426    2426
   q22  387     312     325     312
   Total cold run time: 44953 ms
   Total hot run time: 39950 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5078    5068    5109    5068
   q2   352     246     240     240
   q3   3390    3343    3302    3302
   q4   2147    2045    2020    2020
   q5   5953    5925    5951    5925
   q6   227     129     130     129
   q7   2381    1952    1909    1909
   q8   3560    3662    3668    3662
   q9   9050    9023    9000    9000
   q10  3863    3946    3968    3946
   q11  589     489     487     487
   q12  814     654     633     633
   q13  3925    3236    3185    3185
   q14  307     258     294     258
   q15  623     556     547     547
   q16  578     516     497     497
   q17  2012    1849    1777    1777
   q18  8886    8349    8439    8349
   q19  1732    1664    1668    1664
   q20  2278    1998    1982    1982
   q21  5716    5382    5362    5362
   q22  553     539     510     510
   Total cold run time: 64014 ms
   Total hot run time: 60452 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