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

   
   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 d96e861aeee41254e10715bf58f891f400cee351, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5484    5149    5179    5149
   q2   390     173     158     158
   q3   1465    1188    1170    1170
   q4   1087    837     832     832
   q5   3125    3139    3108    3108
   q6   227     138     131     131
   q7   989     550     521     521
   q8   2160    2191    2273    2191
   q9   6680    6688    6660    6660
   q10  3199    3122    3147    3122
   q11  342     237     220     220
   q12  390     248     242     242
   q13  4392    3623    3633    3623
   q14  247     213     210     210
   q15  613     551     544     544
   q16  458     389     405     389
   q17  1054    605     527     527
   q18  7064    6727    6720    6720
   q19  1646    1522    1480    1480
   q20  572     367     355     355
   q21  2900    2482    2454    2454
   q22  389     307     318     307
   Total cold run time: 44873 ms
   Total hot run time: 40113 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5151    5082    5085    5082
   q2   345     250     257     250
   q3   3367    3350    3316    3316
   q4   2142    2017    1994    1994
   q5   5928    5916    5899    5899
   q6   223     127     125     125
   q7   2369    1909    1946    1909
   q8   3567    3647    3676    3647
   q9   9011    8989    8998    8989
   q10  3857    3903    3894    3894
   q11  594     508     482     482
   q12  803     648     633     633
   q13  3901    3189    3226    3189
   q14  297     277     292     277
   q15  614     547     544     544
   q16  530     537     502     502
   q17  2036    1787    1804    1787
   q18  8773    8457    8354    8354
   q19  1742    1687    1711    1687
   q20  2292    2006    1974    1974
   q21  5713    5200    5391    5200
   q22  557     508     517     508
   Total cold run time: 63812 ms
   Total hot run time: 60242 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