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

   
   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 609b31453805d285f097a4774b97954e8ac0e2eb, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5476    5110    5090    5090
   q2   387     168     158     158
   q3   1475    1190    1237    1190
   q4   1081    827     765     765
   q5   3111    3079    3121    3079
   q6   226     137     137     137
   q7   996     565     537     537
   q8   2155    2212    2234    2212
   q9   6717    6677    6672    6672
   q10  3182    3132    3192    3132
   q11  346     222     210     210
   q12  378     229     233     229
   q13  4382    3643    3674    3643
   q14  255     223     214     214
   q15  578     536     522     522
   q16  460     393     395     393
   q17  1039    497     575     497
   q18  7123    6734    6877    6734
   q19  1652    1506    1491    1491
   q20  596     362     352     352
   q21  2892    2498    2483    2483
   q22  386     317     332     317
   Total cold run time: 44893 ms
   Total hot run time: 40057 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5075    4996    5083    4996
   q2   341     236     231     231
   q3   3361    3328    3315    3315
   q4   2161    2068    2033    2033
   q5   5953    5927    5930    5927
   q6   224     127     129     127
   q7   2385    1928    1954    1928
   q8   3565    3639    3653    3639
   q9   9028    9010    8972    8972
   q10  3878    3891    3898    3891
   q11  569     491     483     483
   q12  811     634     616     616
   q13  3890    3195    3194    3194
   q14  311     263     251     251
   q15  594     538     529     529
   q16  558     510     538     510
   q17  2073    1862    1856    1856
   q18  8797    8381    8396    8381
   q19  1756    1678    1701    1678
   q20  2269    1968    1983    1968
   q21  5750    5350    5352    5350
   q22  543     534     485     485
   Total cold run time: 63892 ms
   Total hot run time: 60360 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