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

   
   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 9a2c2965543589dc759e933ea91b81ceb7d0051d, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5523    5085    5120    5085
   q2   390     211     153     153
   q3   1479    1160    1150    1150
   q4   1100    760     796     760
   q5   3119    3135    3049    3049
   q6   233     135     136     135
   q7   970     583     507     507
   q8   2177    2219    2271    2219
   q9   6706    6674    6695    6674
   q10  3168    3137    3087    3087
   q11  348     224     211     211
   q12  382     236     235     235
   q13  4382    3620    3632    3620
   q14  257     218     209     209
   q15  588     537     523     523
   q16  458     422     418     418
   q17  1039    518     502     502
   q18  7095    6813    6758    6758
   q19  1641    1476    1611    1476
   q20  595     355     347     347
   q21  2890    2465    2471    2465
   q22  396     316     338     316
   Total cold run time: 44936 ms
   Total hot run time: 39899 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5102    5037    5152    5037
   q2   346     247     233     233
   q3   3361    3311    3322    3311
   q4   2150    2026    2030    2026
   q5   5945    5941    5929    5929
   q6   225     126     133     126
   q7   2405    1922    1943    1922
   q8   3553    3662    3639    3639
   q9   9024    8952    8966    8952
   q10  3845    3897    3916    3897
   q11  594     480     471     471
   q12  817     637     637     637
   q13  3883    3169    3234    3169
   q14  311     281     275     275
   q15  579     530     542     530
   q16  566     493     486     486
   q17  2028    1790    1802    1790
   q18  8705    8354    8416    8354
   q19  1755    1681    1649    1649
   q20  2243    1991    1968    1968
   q21  5693    5413    5283    5283
   q22  562     486     480     480
   Total cold run time: 63692 ms
   Total hot run time: 60164 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