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

   
   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 a3a01a003e3cbfe29c1a2e952a075126ebff4337, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5433    5165    5169    5165
   q2   396     169     159     159
   q3   1474    1240    1209    1209
   q4   1100    823     803     803
   q5   3159    3114    3125    3114
   q6   221     130     132     130
   q7   989     551     524     524
   q8   2166    2226    2226    2226
   q9   6704    6654    6666    6654
   q10  3171    3196    3146    3146
   q11  357     218     230     218
   q12  380     231     231     231
   q13  4406    3686    3661    3661
   q14  244     206     217     206
   q15  601     558     551     551
   q16  476     409     407     407
   q17  1054    565     553     553
   q18  7039    6723    7224    6723
   q19  1624    1512    1462    1462
   q20  607     363     347     347
   q21  2882    2424    2514    2424
   q22  392     334     327     327
   Total cold run time: 44875 ms
   Total hot run time: 40240 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5173    5040    5108    5040
   q2   333     256     243     243
   q3   3337    3325    3330    3325
   q4   2141    2020    2020    2020
   q5   5939    5929    5973    5929
   q6   232     127     126     126
   q7   2393    1950    1926    1926
   q8   3568    3677    3662    3662
   q9   9050    9011    9019    9011
   q10  3887    3907    3929    3907
   q11  591     485     479     479
   q12  807     674     619     619
   q13  3906    3222    3214    3214
   q14  286     309     282     282
   q15  618     535     552     535
   q16  541     543     506     506
   q17  2016    1844    1809    1809
   q18  8761    8319    8391    8319
   q19  1733    1703    1701    1701
   q20  2309    1996    1987    1987
   q21  5775    5318    5266    5266
   q22  580     508     507     507
   Total cold run time: 63976 ms
   Total hot run time: 60413 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