Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-20 Thread via GitHub


hello-stephen commented on PR #58153:
URL: https://github.com/apache/doris/pull/58153#issuecomment-3557020306

   # FE Regression Coverage Report
   Increment line coverage `  100.00% (1/1)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/58153_ef1ef61265574c28bb73d7d676f48e22c2f4f97c_merge_fe/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/58153_ef1ef61265574c28bb73d7d676f48e22c2f4f97c_merge_fe/report/index.html)
   


-- 
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]



Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-20 Thread via GitHub


Jibing-Li merged PR #58153:
URL: https://github.com/apache/doris/pull/58153


-- 
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]



Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-20 Thread via GitHub


Jibing-Li commented on PR #58153:
URL: https://github.com/apache/doris/pull/58153#issuecomment-3556474778

   run cloud_p0


-- 
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]



Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-19 Thread via GitHub


hello-stephen commented on PR #58153:
URL: https://github.com/apache/doris/pull/58153#issuecomment-3556391326

   # FE Regression Coverage Report
   Increment line coverage `  100.00% (1/1)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/58153_ef1ef61265574c28bb73d7d676f48e22c2f4f97c_merge_fe/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/58153_ef1ef61265574c28bb73d7d676f48e22c2f4f97c_merge_fe/report/index.html)
   


-- 
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]



Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-19 Thread via GitHub


github-actions[bot] commented on PR #58153:
URL: https://github.com/apache/doris/pull/58153#issuecomment-3556367685

   PR approved by at least one committer and no changes requested.


-- 
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]



Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-19 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 27.42 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit ef1ef61265574c28bb73d7d676f48e22c2f4f97c, 
data reload: false
   
   query1   0.060.050.04
   query2   0.110.050.05
   query3   0.280.080.08
   query4   1.610.110.10
   query5   0.260.250.25
   query6   1.180.640.63
   query7   0.020.020.02
   query8   0.050.040.04
   query9   0.590.530.52
   query10  0.580.570.58
   query11  0.180.110.11
   query12  0.150.120.12
   query13  0.620.610.60
   query14  1.001.001.01
   query15  0.850.830.84
   query16  0.390.420.39
   query17  1.030.991.02
   query18  0.210.190.20
   query19  1.921.801.78
   query20  0.020.010.01
   query21  15.48   0.210.14
   query22  4.920.100.04
   query23  15.64   0.250.10
   query24  3.850.910.44
   query25  0.060.050.07
   query26  0.150.140.13
   query27  0.060.050.06
   query28  4.081.190.96
   query29  12.61   3.803.20
   query30  0.290.130.11
   query31  2.820.580.39
   query32  3.230.550.48
   query33  2.973.163.03
   query34  15.90   5.144.57
   query35  4.534.584.60
   query36  0.660.500.49
   query37  0.130.070.06
   query38  0.120.040.04
   query39  0.050.020.02
   query40  0.190.150.13
   query41  0.110.040.03
   query42  0.050.030.03
   query43  0.050.040.03
   Total cold run time: 99.06 s
   Total hot run time: 27.42 s
   ```
   
   


-- 
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]



Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-19 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 188041 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit ef1ef61265574c28bb73d7d676f48e22c2f4f97c, 
data reload: false
   
   query1   1134409 389 389
   query2   6558168816551655
   query3   6843232 223 223
   query4   26388   23256   22943   22943
   query5   4436655 504 504
   query6   361 252 243 243
   query7   4659506 302 302
   query8   307 264 281 264
   query9   8640292129302921
   query10  525 342 308 308
   query11  15731   15485   14797   14797
   query12  183 129 120 120
   query13  1697578 465 465
   query14  10804   919390659065
   query15  195 188 170 170
   query16  7345660 528 528
   query17  1263789 638 638
   query18  2002437 342 342
   query19  208 206 180 180
   query20  132 131 120 120
   query21  515 138 115 115
   query22  4177423640824082
   query23  33888   33188   8   33188
   query24  8213240423932393
   query25  636 573 490 490
   query26  1261317 164 164
   query27  2706496 363 363
   query28  4423222622142214
   query29  843 636 512 512
   query30  337 219 200 200
   query31  900 791 714 714
   query32  89  79  85  79
   query33  589 397 357 357
   query34  790 854 531 531
   query35  810 843 743 743
   query36  971 998 913 913
   query37  163 121 103 103
   query38  3499355034253425
   query39  1447143413961396
   query40  228 137 124 124
   query41  68  60  61  60
   query42  129 116 118 116
   query43  492 483 488 483
   query44  1255800 797 797
   query45  186 189 170 170
   query46  878 990 640 640
   query47  1779181016971697
   query48  392 415 327 327
   query49  777 488 420 420
   query50  658 684 409 409
   query51  3836399237963796
   query52  108 115 116 115
   query53  237 266 203 203
   query54  365 312 302 302
   query55  91  97  88  88
   query56  357 348 354 348
   query57  1180118511271127
   query58  302 285 286 285
   query59  2528262825142514
   query60  359 356 350 350
   query61  163 161 155 155
   query62  765 703 650 650
   query63  229 192 195 192
   query64  45551172887 887
   query65  4033393239213921
   query66  1186426 349 349
   query67  15550   15231   14950   14950
   query68  8409949 629 629
   query69  491 339 302 302
   query70  1392127312911273
   query71  477 345 330 330
   query72  5846483047964796
   query73  697 554 369 369
   query74  9245902588158815
   query75  3982327427452745
   query76  36901174751 751
   query77  812 421 331 331
   query78  9348971788698869
   query79  2159837 602 602
   query80  664 593 525 525
   query81  487 264 240 240
   query82  424 158 140 140
   query83  255 266 253 253
   query84  249 116 100 100
   query85  922 500 453 453
   query86  345 297 299 297
   query87  3678374636213621
   query88  3140222722172217
   query89  395 333 289 289
   query90  2007235 229 229
   query91  170 164 135 135
   query92  88  73  75  73
   query93  11141010686 686
   query94  696 440 340 340
   query95  429 339 339 339
   query96  473 585 293 293
   query97  2922297128692869
   query98  244 221 218 218
   query99  1674141212781278
   Total cold run time: 275278 ms
   Total hot run time: 188041 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

Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-19 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 34210 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit ef1ef61265574c28bb73d7d676f48e22c2f4f97c, 
data reload: false
   
   -- Round 1 --
   q1   17684   505648944894
   q2   2293323 227 227
   q3   10244   1260699 699
   q4   10254   928 376 376
   q5   7523231225192312
   q6   180 168 138 138
   q7   910 787 634 634
   q8   9484135211431143
   q9   7187548253935393
   q10  7033223418301830
   q11  574 300 277 277
   q12  340 368 230 230
   q13  17981   361929932993
   q14  229 237 216 216
   q15  588 518 508 508
   q16  1010988 933 933
   q17  624 860 360 360
   q18  7537701470167014
   q19  1117940 536 536
   q20  359 344 236 236
   q21  3669250622892289
   q22  10661019972 972
   Total cold run time: 107886 ms
   Total hot run time: 34210 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5106492448924892
   q2   322 405 322 322
   q3   2159264622982298
   q4   1332175513441344
   q5   4231446844014401
   q6   216 189 133 133
   q7   1977200818201820
   q8   2707268225972597
   q9   7496755774557455
   q10  3118323027742774
   q11  570 516 498 498
   q12  665 748 576 576
   q13  3451387033243324
   q14  304 297 270 270
   q15  542 495 514 495
   q16  1067120110771077
   q17  1141159514021402
   q18  7927773577537735
   q19  794 804 832 804
   q20  2063211419111911
   q21  4917433642174217
   q22  10841046989 989
   Total cold run time: 53189 ms
   Total hot run time: 51334 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]



Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-19 Thread via GitHub


yujun777 commented on PR #58153:
URL: https://github.com/apache/doris/pull/58153#issuecomment-3555672706

   run buildall


-- 
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]



Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-19 Thread via GitHub


hello-stephen commented on PR #58153:
URL: https://github.com/apache/doris/pull/58153#issuecomment-3555638092

   # FE Regression Coverage Report
   Increment line coverage `  100.00% (1/1)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/58153_ee5b8de6a586dcbad6877d67fbe47497a8c7e16b_merge_fe/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/58153_ee5b8de6a586dcbad6877d67fbe47497a8c7e16b_merge_fe/report/index.html)
   


-- 
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]



Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-19 Thread via GitHub


yujun777 commented on PR #58153:
URL: https://github.com/apache/doris/pull/58153#issuecomment-3555632020

   run buildall


-- 
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]



Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-19 Thread via GitHub


github-actions[bot] commented on PR #58153:
URL: https://github.com/apache/doris/pull/58153#issuecomment-3555406776

   PR approved by anyone and no changes requested.


-- 
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]



Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-19 Thread via GitHub


github-actions[bot] commented on PR #58153:
URL: https://github.com/apache/doris/pull/58153#issuecomment-3555406723

   PR approved by at least one committer and no changes requested.


-- 
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]



Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-19 Thread via GitHub


yujun777 commented on PR #58153:
URL: https://github.com/apache/doris/pull/58153#issuecomment-3555336233

   run feut


-- 
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]



Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-19 Thread via GitHub


yujun777 commented on PR #58153:
URL: https://github.com/apache/doris/pull/58153#issuecomment-3555336035

   run p0


-- 
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]



Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-19 Thread via GitHub


hello-stephen commented on PR #58153:
URL: https://github.com/apache/doris/pull/58153#issuecomment-3552749113

   # FE Regression Coverage Report
   Increment line coverage `  100.00% (1/1)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/58153_ee5b8de6a586dcbad6877d67fbe47497a8c7e16b_merge_fe/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/58153_ee5b8de6a586dcbad6877d67fbe47497a8c7e16b_merge_fe/report/index.html)
   


-- 
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]



Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-19 Thread via GitHub


yujun777 commented on PR #58153:
URL: https://github.com/apache/doris/pull/58153#issuecomment-3552388452

   run feut


-- 
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]



Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-19 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 27.27 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit ee5b8de6a586dcbad6877d67fbe47497a8c7e16b, 
data reload: false
   
   query1   0.050.040.05
   query2   0.080.040.04
   query3   0.250.080.08
   query4   1.610.120.11
   query5   0.290.250.25
   query6   1.200.650.63
   query7   0.030.020.03
   query8   0.060.040.05
   query9   0.570.530.52
   query10  0.570.570.57
   query11  0.170.110.11
   query12  0.150.120.11
   query13  0.620.600.61
   query14  1.001.001.00
   query15  0.840.820.83
   query16  0.390.380.40
   query17  1.011.021.01
   query18  0.220.200.21
   query19  1.871.881.87
   query20  0.020.010.01
   query21  15.45   0.200.13
   query22  5.010.070.05
   query23  15.69   0.260.11
   query24  2.221.300.31
   query25  0.070.070.06
   query26  0.140.130.13
   query27  0.060.060.05
   query28  3.271.150.95
   query29  12.56   3.833.19
   query30  0.290.140.12
   query31  2.820.580.38
   query32  3.240.540.47
   query33  3.032.993.05
   query34  15.86   5.104.54
   query35  4.574.514.62
   query36  0.670.510.49
   query37  0.090.070.07
   query38  0.070.040.04
   query39  0.030.030.03
   query40  0.180.140.14
   query41  0.090.040.04
   query42  0.040.030.03
   query43  0.050.030.03
   Total cold run time: 96.5 s
   Total hot run time: 27.27 s
   ```
   
   


-- 
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]



Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-19 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 188035 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit ee5b8de6a586dcbad6877d67fbe47497a8c7e16b, 
data reload: false
   
   query1   1037410 389 389
   query2   6552167416781674
   query3   6784231 232 231
   query4   25779   23393   22595   22595
   query5   4919679 532 532
   query6   360 263 244 244
   query7   4655512 311 311
   query8   319 277 259 259
   query9   8694292229352922
   query10  514 361 320 320
   query11  15933   15023   14778   14778
   query12  202 126 148 126
   query13  1683579 438 438
   query14  12465   917390679067
   query15  242 190 176 176
   query16  7700667 515 515
   query17  1588764 621 621
   query18  2028428 325 325
   query19  218 197 178 178
   query20  129 129 123 123
   query21  220 133 116 116
   query22  4020424041854185
   query23  33856   33113   33178   33113
   query24  7778236023632360
   query25  685 596 495 495
   query26  1223281 174 174
   query27  2704511 372 372
   query28  4382227222412241
   query29  832 674 544 544
   query30  302 234 203 203
   query31  936 793 726 726
   query32  99  87  88  87
   query33  597 405 366 366
   query34  790 865 524 524
   query35  838 854 778 778
   query36  964 994 912 912
   query37  134 122 100 100
   query38  3479362034313431
   query39  1533145514071407
   query40  244 138 143 138
   query41  70  69  66  66
   query42  131 121 120 120
   query43  474 482 454 454
   query44  1261789 806 789
   query45  194 189 176 176
   query46  895 1008649 649
   query47  1794182317571757
   query48  416 429 339 339
   query49  792 512 436 436
   query50  647 688 410 410
   query51  3909390838433843
   query52  119 124 114 114
   query53  247 265 203 203
   query54  350 340 317 317
   query55  96  97  91  91
   query56  368 366 357 357
   query57  1194119311031103
   query58  371 298 288 288
   query59  2554268925702570
   query60  383 368 351 351
   query61  166 163 166 163
   query62  784 708 658 658
   query63  232 194 194 194
   query64  44401184899 899
   query65  4075392339773923
   query66  1109441 365 365
   query67  15388   15136   14876   14876
   query68  8477954 628 628
   query69  507 354 306 306
   query70  1315133312641264
   query71  524 355 325 325
   query72  6032494849074907
   query73  700 596 364 364
   query74  9241914586568656
   query75  4093323127962796
   query76  38171135761 761
   query77  813 398 339 339
   query78  941110209   88688868
   query79  2670869 627 627
   query80  687 584 527 527
   query81  482 252 231 231
   query82  654 164 136 136
   query83  287 267 247 247
   query84  298 118 95  95
   query85  909 486 456 456
   query86  358 326 325 325
   query87  3673370336563656
   query88  3264219622352196
   query89  391 332 295 295
   query90  2055240 228 228
   query91  170 164 133 133
   query92  87  79  76  76
   query93  1170988 687 687
   query94  711 438 332 332
   query95  421 336 335 335
   query96  494 589 277 277
   query97  2982292428702870
   query98  258 226 221 221
   query99  1420140612641264
   Total cold run time: 278247 ms
   Total hot run time: 188035 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 

Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-19 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 34374 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit ee5b8de6a586dcbad6877d67fbe47497a8c7e16b, 
data reload: false
   
   -- Round 1 --
   q1   17615   505348674867
   q2   2062325 209 209
   q3   10229   1295718 718
   q4   10225   933 373 373
   q5   7529234423522344
   q6   186 174 137 137
   q7   898 737 605 605
   q8   9344136011391139
   q9   6982540953885388
   q10  6817223718481848
   q11  495 299 285 285
   q12  345 363 241 241
   q13  17787   361930013001
   q14  236 229 212 212
   q15  565 500 500 500
   q16  10301025947 947
   q17  577 861 355 355
   q18  7569719271677167
   q19  1098955 547 547
   q20  354 343 230 230
   q21  3696310822772277
   q22  10721029984 984
   Total cold run time: 106711 ms
   Total hot run time: 34374 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4892488549074885
   q2   308 383 327 327
   q3   2150264523222322
   q4   1391177713221322
   q5   4192435447214354
   q6   229 179 140 140
   q7   2038197318351835
   q8   2601260425642564
   q9   7606752175557521
   q10  3029338128132813
   q11  596 515 501 501
   q12  702 774 640 640
   q13  3486414732393239
   q14  291 298 279 279
   q15  551 486 483 483
   q16  1038110410791079
   q17  1231159313931393
   q18  7933758075017501
   q19  783 780 902 780
   q20  2029201619261926
   q21  5079445543274327
   q22  10931039974 974
   Total cold run time: 53248 ms
   Total hot run time: 51205 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]



Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-19 Thread via GitHub


yujun777 commented on PR #58153:
URL: https://github.com/apache/doris/pull/58153#issuecomment-3552014209

   run buildall


-- 
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]



Re: [PR] [opt](staticstis) use count(1) for rowCount when scan full table [doris]

2025-11-19 Thread via GitHub


Thearas commented on PR #58153:
URL: https://github.com/apache/doris/pull/58153#issuecomment-3552013794

   
   Thank you for your contribution to Apache Doris.
   Don't know what should be done next? See [How to process your 
PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR).
   
   Please clearly describe your PR:
   1. What problem was fixed (it's best to include specific error reporting 
information). How it was fixed.
   2. Which behaviors were modified. What was the previous behavior, what is it 
now, why was it modified, and what possible impacts might there be.
   3. What features were added. Why was this function added?
   4. Which code was refactored and why was this part of the code refactored?
   5. Which functions were optimized and what is the difference before and 
after the optimization?
   


-- 
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]