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

   
   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 1d698fa93ce8f76ac1b645c1772af0f8fe60567c, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5558    5096    5118    5096
   q2   399     155     158     155
   q3   1457    1188    1168    1168
   q4   1092    851     787     787
   q5   3158    3033    3052    3033
   q6   221     144     134     134
   q7   987     552     518     518
   q8   2165    2236    2169    2169
   q9   6696    6657    6663    6657
   q10  3188    3134    3106    3106
   q11  342     215     220     215
   q12  380     237     239     237
   q13  4385    3665    3629    3629
   q14  256     223     228     223
   q15  577     535     526     526
   q16  463     398     399     398
   q17  1046    514     524     514
   q18  7113    6774    6735    6735
   q19  1640    1567    1508    1508
   q20  589     330     335     330
   q21  2860    2419    2455    2419
   q22  394     320     336     320
   Total cold run time: 44966 ms
   Total hot run time: 39877 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5071    5039    4974    4974
   q2   343     239     235     235
   q3   3361    3339    3298    3298
   q4   2160    2026    2042    2026
   q5   5967    5905    5931    5905
   q6   226     126     126     126
   q7   2368    1937    1920    1920
   q8   3587    3645    3665    3645
   q9   9002    8979    8975    8975
   q10  3868    3902    3903    3902
   q11  561     487     488     487
   q12  819     636     648     636
   q13  3888    3193    3168    3168
   q14  298     268     268     268
   q15  588     542     535     535
   q16  553     511     510     510
   q17  2036    1829    1824    1824
   q18  8677    8367    8361    8361
   q19  1742    1700    1675    1675
   q20  2253    1983    1971    1971
   q21  5749    5439    5247    5247
   q22  577     505     492     492
   Total cold run time: 63694 ms
   Total hot run time: 60180 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