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

   
   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 f92f384bb04fc14d8d352ed695ccfb766e5b802a, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5500    5136    5116    5116
   q2   398     178     159     159
   q3   1463    1162    1258    1162
   q4   1083    839     812     812
   q5   3126    3137    3058    3058
   q6   223     142     131     131
   q7   990     565     530     530
   q8   2134    2189    2289    2189
   q9   6661    6671    6645    6645
   q10  3171    3127    3056    3056
   q11  341     223     228     223
   q12  381     229     236     229
   q13  4395    3652    3644    3644
   q14  253     216     219     216
   q15  599     548     545     545
   q16  469     421     396     396
   q17  1037    528     478     478
   q18  7094    6769    6808    6769
   q19  1642    1564    1619    1564
   q20  560     357     335     335
   q21  2824    2446    2478    2446
   q22  403     337     333     333
   Total cold run time: 44747 ms
   Total hot run time: 40036 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5137    5070    4989    4989
   q2   329     267     261     261
   q3   3356    3323    3288    3288
   q4   2153    2039    2033    2033
   q5   5934    5903    5904    5903
   q6   229     124     122     122
   q7   2358    1946    1928    1928
   q8   3547    3664    3634    3634
   q9   9067    8943    8964    8943
   q10  3835    3897    3902    3897
   q11  593     472     470     470
   q12  802     695     631     631
   q13  3847    3220    3175    3175
   q14  299     281     284     281
   q15  600     551     539     539
   q16  562     513     516     513
   q17  2015    1834    1825    1825
   q18  8791    8381    8592    8381
   q19  1744    1691    1718    1691
   q20  2284    1995    1965    1965
   q21  5761    5327    5371    5327
   q22  562     496     509     496
   Total cold run time: 63805 ms
   Total hot run time: 60292 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