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

   
   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 522057873ea52fde77e4b188cb62ad46f2088969, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5517    5078    5101    5078
   q2   389     163     169     163
   q3   1471    1198    1204    1198
   q4   1085    817     811     811
   q5   3154    3124    3154    3124
   q6   222     134     137     134
   q7   967     548     533     533
   q8   2137    2281    2215    2215
   q9   6683    6700    6673    6673
   q10  3187    3123    3108    3108
   q11  356     217     219     217
   q12  378     236     235     235
   q13  4414    3664    3634    3634
   q14  260     222     213     213
   q15  582     537     535     535
   q16  476     393     422     393
   q17  1047    491     575     491
   q18  7044    6779    6805    6779
   q19  1628    1509    1586    1509
   q20  607     372     343     343
   q21  2860    2443    2456    2443
   q22  388     308     325     308
   Total cold run time: 44852 ms
   Total hot run time: 40137 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5124    5077    5166    5077
   q2   335     232     240     232
   q3   3375    3353    3319    3319
   q4   2145    2075    2043    2043
   q5   5972    5945    5947    5945
   q6   223     126     131     126
   q7   2401    1909    1956    1909
   q8   3565    3647    3668    3647
   q9   9093    9032    9061    9032
   q10  3845    3925    3904    3904
   q11  575     487     487     487
   q12  803     635     664     635
   q13  3883    3161    3168    3161
   q14  295     266     280     266
   q15  591     532     527     527
   q16  543     484     503     484
   q17  2066    1863    1809    1809
   q18  8721    8384    8332    8332
   q19  1743    1661    1690    1661
   q20  2275    1990    1971    1971
   q21  5615    5275    5219    5219
   q22  586     482     486     482
   Total cold run time: 63774 ms
   Total hot run time: 60268 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