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

   
   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 dc12cc7b40cc09d5e35e9c49e431d80af2624f44, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5538    5078    5111    5078
   q2   397     165     193     165
   q3   1458    1149    1047    1047
   q4   1076    790     793     790
   q5   3130    3072    3092    3072
   q6   234     136     139     136
   q7   963     527     529     527
   q8   2154    2286    2296    2286
   q9   6659    6648    6656    6648
   q10  3162    3124    3101    3101
   q11  333     229     217     217
   q12  375     234     226     226
   q13  4403    3702    3628    3628
   q14  253     217     225     217
   q15  583     539     525     525
   q16  466     413     395     395
   q17  1042    505     528     505
   q18  7069    6791    6776    6776
   q19  1636    1580    1438    1438
   q20  590     337     341     337
   q21  2928    2439    2505    2439
   q22  379     329     338     329
   Total cold run time: 44828 ms
   Total hot run time: 39882 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5098    5031    5073    5031
   q2   342     237     236     236
   q3   3361    3328    3310    3310
   q4   2156    2035    2036    2035
   q5   5937    5947    5954    5947
   q6   225     126     130     126
   q7   2380    1903    1888    1888
   q8   3590    3670    3668    3668
   q9   9090    8996    8990    8990
   q10  3864    3945    3904    3904
   q11  604     482     481     481
   q12  806     622     637     622
   q13  3896    3237    3203    3203
   q14  322     266     281     266
   q15  597     528     535     528
   q16  550     498     524     498
   q17  2039    1844    1808    1808
   q18  8768    8317    8437    8317
   q19  1754    1701    1715    1701
   q20  2263    1978    1987    1978
   q21  5731    5460    5360    5360
   q22  550     498     476     476
   Total cold run time: 63923 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: [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