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

   
   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 a627703bc697fc3dd91b01eb8426cce111974b34, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5512    5093    5098    5093
   q2   391     164     159     159
   q3   1452    1197    1159    1159
   q4   1098    812     764     764
   q5   3098    3075    3155    3075
   q6   225     144     130     130
   q7   974     533     536     533
   q8   2146    2277    2234    2234
   q9   6686    6639    6681    6639
   q10  3155    3171    3151    3151
   q11  365     207     218     207
   q12  380     241     237     237
   q13  4413    3663    3643    3643
   q14  255     215     220     215
   q15  615     539     549     539
   q16  454     404     398     398
   q17  1047    530     528     528
   q18  7101    6758    6912    6758
   q19  1637    1524    1611    1524
   q20  619     350     359     350
   q21  2849    2456    2543    2456
   q22  401     327     328     327
   Total cold run time: 44873 ms
   Total hot run time: 40119 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5122    5035    5138    5035
   q2   336     250     241     241
   q3   3361    3350    3293    3293
   q4   2116    2011    2006    2006
   q5   5959    5922    5937    5922
   q6   232     128     124     124
   q7   2416    1921    1897    1897
   q8   3570    3664    3670    3664
   q9   9084    9012    8989    8989
   q10  3900    3896    3897    3896
   q11  568     484     479     479
   q12  804     656     640     640
   q13  3885    3204    3190    3190
   q14  301     269     262     262
   q15  629     548     553     548
   q16  560     490     513     490
   q17  2081    1859    1817    1817
   q18  8711    8471    8448    8448
   q19  1749    1673    1652    1652
   q20  2293    2001    1992    1992
   q21  5755    5297    5356    5297
   q22  583     496     476     476
   Total cold run time: 64015 ms
   Total hot run time: 60358 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