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

   
   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 4db83152709159f6fb2954eb29eef9535c308f64, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5461    5126    5070    5070
   q2   393     160     178     160
   q3   1475    1122    1207    1122
   q4   1095    757     807     757
   q5   3135    3110    3162    3110
   q6   220     139     126     126
   q7   978     538     522     522
   q8   2151    2290    2232    2232
   q9   6766    6658    6719    6658
   q10  3157    3141    3181    3141
   q11  364     224     214     214
   q12  378     236     234     234
   q13  4403    3635    3619    3619
   q14  254     212     213     212
   q15  613     551     548     548
   q16  455     406     403     403
   q17  1039    497     512     497
   q18  7080    6751    6980    6751
   q19  1642    1529    1542    1529
   q20  608     398     360     360
   q21  2937    2411    2406    2406
   q22  384     313     316     313
   Total cold run time: 44988 ms
   Total hot run time: 39984 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5121    5056    5065    5056
   q2   341     246     246     246
   q3   3351    3300    3275    3275
   q4   2147    2031    2034    2031
   q5   5943    5882    5928    5882
   q6   232     122     124     122
   q7   2357    1937    1948    1937
   q8   3556    3654    3639    3639
   q9   9020    9040    8947    8947
   q10  3864    3906    3941    3906
   q11  569     488     469     469
   q12  805     652     662     652
   q13  3862    3229    3168    3168
   q14  291     272     275     272
   q15  624     537     547     537
   q16  543     524     518     518
   q17  2040    1809    1801    1801
   q18  8748    8399    8414    8399
   q19  1765    1627    1709    1627
   q20  2294    2022    1974    1974
   q21  5710    5346    5326    5326
   q22  589     511     507     507
   Total cold run time: 63772 ms
   Total hot run time: 60291 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