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

   
   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 b61308534f5aa98dd507ac703b77283b5e70b6d9, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5616    5333    5237    5237
   q2   402     192     154     154
   q3   1504    1273    1173    1173
   q4   1168    947     868     868
   q5   3287    3271    3232    3232
   q6   246     152     141     141
   q7   1054    511     500     500
   q8   2314    2377    2419    2377
   q9   6907    6908    6903    6903
   q10  3284    3259    3179    3179
   q11  355     217     222     217
   q12  417     230     235     230
   q13  4467    3658    3616    3616
   q14  265     216     217     216
   q15  612     537     540     537
   q16  457     407     395     395
   q17  1071    594     574     574
   q18  7122    6790    6758    6758
   q19  1781    1732    1630    1630
   q20  597     340     351     340
   q21  3047    2654    2623    2623
   q22  413     321     329     321
   Total cold run time: 46386 ms
   Total hot run time: 41221 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5283    5235    5231    5231
   q2   358     257     252     252
   q3   3439    3402    3380    3380
   q4   2214    2081    2092    2081
   q5   6085    6060    6069    6060
   q6   251     127     126     126
   q7   2411    1912    1966    1912
   q8   3757    3813    3844    3813
   q9   9180    9082    9018    9018
   q10  3943    3989    4017    3989
   q11  592     491     518     491
   q12  828     637     640     637
   q13  3977    3209    3167    3167
   q14  303     252     277     252
   q15  609     557     533     533
   q16  561     495     527     495
   q17  2144    1884    1861    1861
   q18  8898    8432    8527    8432
   q19  1919    1837    1874    1837
   q20  2316    1989    1957    1957
   q21  5949    5454    5368    5368
   q22  585     524     469     469
   Total cold run time: 65602 ms
   Total hot run time: 61361 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