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

   
   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 5de5f78b705b1ec0daa6538937cc955a3b3f2e45, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5437    5151    5138    5138
   q2   390     164     168     164
   q3   1469    1124    1126    1124
   q4   1077    793     806     793
   q5   3139    3070    3073    3070
   q6   221     133     135     133
   q7   973     528     534     528
   q8   2171    2230    2298    2230
   q9   6690    6663    6643    6643
   q10  3186    3220    3188    3188
   q11  339     217     202     202
   q12  378     231     237     231
   q13  4377    3662    3616    3616
   q14  256     228     220     220
   q15  570     537     546     537
   q16  458     442     401     401
   q17  1045    569     472     472
   q18  7130    6781    6702    6702
   q19  1642    1476    1500    1476
   q20  566     359     324     324
   q21  2939    2474    2512    2474
   q22  393     323     324     323
   Total cold run time: 44846 ms
   Total hot run time: 39989 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5110    5068    5027    5027
   q2   338     228     240     228
   q3   3374    3342    3323    3323
   q4   2160    2016    2049    2016
   q5   5967    5937    5907    5907
   q6   222     126     127     126
   q7   2398    1956    1918    1918
   q8   3533    3645    3676    3645
   q9   9070    9004    9028    9004
   q10  3875    3878    3896    3878
   q11  571     486     476     476
   q12  808     629     647     629
   q13  3903    3191    3173    3173
   q14  294     273     285     273
   q15  582     534     533     533
   q16  571     479     486     479
   q17  2055    1825    1803    1803
   q18  8796    8356    8374    8356
   q19  1736    1698    1730    1698
   q20  2261    1979    1973    1973
   q21  5776    5371    5329    5329
   q22  544     495     492     492
   Total cold run time: 63944 ms
   Total hot run time: 60286 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