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

   
   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 58ffef2a3574a85750211809bdeeccd9a241c4b6, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5473    5053    5072    5053
   q2   390     164     197     164
   q3   1464    1085    1096    1085
   q4   1079    793     805     793
   q5   3126    3151    3124    3124
   q6   233     141     138     138
   q7   979     568     523     523
   q8   2152    2274    2295    2274
   q9   6748    6679    6690    6679
   q10  3163    3108    3075    3075
   q11  355     226     205     205
   q12  384     237     231     231
   q13  4389    3653    3641    3641
   q14  251     221     226     221
   q15  587     539     528     528
   q16  448     425     417     417
   q17  1039    584     549     549
   q18  7085    6802    6799    6799
   q19  1642    1485    1418    1418
   q20  560     365     326     326
   q21  2865    2509    2551    2509
   q22  399     327     331     327
   Total cold run time: 44811 ms
   Total hot run time: 40079 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5084    5093    5051    5051
   q2   342     239     236     236
   q3   3348    3347    3321    3321
   q4   2178    2025    2033    2025
   q5   5952    5948    5940    5940
   q6   224     128     128     128
   q7   2401    1912    1890    1890
   q8   3609    3659    3663    3659
   q9   9078    8951    8993    8951
   q10  3899    3930    3908    3908
   q11  590     484     477     477
   q12  814     649     625     625
   q13  3876    3227    3203    3203
   q14  300     262     267     262
   q15  593     541     532     532
   q16  578     516     487     487
   q17  2035    1815    1805    1805
   q18  8806    8348    8327    8327
   q19  1745    1649    1684    1649
   q20  2275    1991    1973    1973
   q21  5661    5264    5349    5264
   q22  568     491     460     460
   Total cold run time: 63956 ms
   Total hot run time: 60173 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