Re: [PR] [draft] Collect bloom runtime filter filtering statistics. [doris]
doris-robot commented on PR #47305: URL: https://github.com/apache/doris/pull/47305#issuecomment-2606515349 TeamCity be ut coverage result: Function Coverage: 41.56% (10835/26069) Line Coverage: 31.96% (91573/286554) Region Coverage: 31.09% (46903/150849) Branch Coverage: 27.18% (23756/87392) Coverage Report: http://coverage.selectdb-in.cc/coverage/14f578fc2bd97d39702c981ca30003460d247875_14f578fc2bd97d39702c981ca30003460d247875/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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [draft] Collect bloom runtime filter filtering statistics. [doris]
doris-robot commented on PR #47305: URL: https://github.com/apache/doris/pull/47305#issuecomment-2606460967 ClickBench: Total hot run time: 30.16 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 14f578fc2bd97d39702c981ca30003460d247875, data reload: false query1 0.040.030.02 query2 0.070.040.03 query3 0.240.070.06 query4 1.610.110.10 query5 0.420.430.43 query6 1.160.660.65 query7 0.030.020.01 query8 0.040.030.03 query9 0.590.520.52 query10 0.540.590.55 query11 0.130.110.10 query12 0.130.110.10 query13 0.610.590.61 query14 2.802.732.79 query15 0.890.820.82 query16 0.380.380.38 query17 1.081.061.01 query18 0.240.200.20 query19 1.911.802.04 query20 0.010.020.01 query21 15.37 0.930.58 query22 0.760.860.74 query23 15.21 1.420.57 query24 2.690.341.51 query25 0.200.170.10 query26 0.260.150.14 query27 0.040.060.04 query28 13.76 1.140.44 query29 12.59 4.073.33 query30 0.240.090.07 query31 2.820.610.38 query32 3.220.540.45 query33 3.033.023.03 query34 16.65 5.164.52 query35 4.544.494.62 query36 0.660.490.48 query37 0.100.060.06 query38 0.040.040.04 query39 0.030.030.03 query40 0.160.130.13 query41 0.080.020.02 query42 0.040.020.02 query43 0.040.030.03 Total cold run time: 105.45 s Total hot run time: 30.16 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [draft] Collect bloom runtime filter filtering statistics. [doris]
doris-robot commented on PR #47305: URL: https://github.com/apache/doris/pull/47305#issuecomment-2606453712 TPC-DS: Total hot run time: 186963 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 14f578fc2bd97d39702c981ca30003460d247875, data reload: false query1 973 376 382 376 query2 6529196120101961 query3 6795214 217 214 query4 33507 23328 22929 22929 query5 4359611 449 449 query6 294 218 183 183 query7 4600503 327 327 query8 296 254 228 228 query9 9673260425812581 query10 479 331 248 248 query11 18110 15054 15086 15054 query12 156 110 112 110 query13 1668516 400 400 query14 9501657575086575 query15 252 195 208 195 query16 7864579 462 462 query17 1621694 566 566 query18 1287350 283 283 query19 222 175 149 149 query20 121 109 107 107 query21 206 122 101 101 query22 4371445943414341 query23 34665 33069 33182 33069 query24 6789223722432237 query25 498 450 394 394 query26 1085277 149 149 query27 2121462 329 329 query28 5341242123912391 query29 629 542 406 406 query30 237 182 158 158 query31 971 880 773 773 query32 84 61 67 61 query33 545 345 329 329 query34 735 865 498 498 query35 822 812 731 731 query36 10181030964 964 query37 132 104 83 83 query38 4077421040984098 query39 1435140813971397 query40 205 114 100 100 query41 52 52 54 52 query42 123 101 102 101 query43 501 510 476 476 query44 1352812 810 810 query45 182 177 167 167 query46 850 1058642 642 query47 1838182617691769 query48 385 394 320 320 query49 770 501 401 401 query50 615 645 394 394 query51 6843690767786778 query52 100 102 94 94 query53 217 244 197 197 query54 480 477 416 416 query55 80 78 81 78 query56 265 270 247 247 query57 1191113710651065 query58 253 222 232 222 query59 3004299028042804 query60 281 277 263 263 query61 116 120 112 112 query62 823 726 634 634 query63 220 191 185 185 query64 41081026673 673 query65 3230319731973197 query66 838 408 303 303 query67 15864 15586 15373 15373 query68 4345810 527 527 query69 446 281 263 263 query70 1171118911641164 query71 372 285 268 268 query72 5979379738923797 query73 634 757 356 356 query74 9840920786558655 query75 3177315726912691 query76 30721196774 774 query77 458 355 287 287 query78 996910115 93769376 query79 2322816 582 582 query80 650 521 452 452 query81 522 271 243 243 query82 226 154 124 124 query83 178 173 148 148 query84 253 97 74 74 query85 816 440 291 291 query86 392 318 297 297 query87 4386448845124488 query88 3549220821462146 query89 399 325 296 296 query90 1724191 190 190 query91 137 138 109 109 query92 62 56 52 52 query93 1258862 526 526 query94 587 414 309 309 query95 325 263 250 250 query96 492 612 284 284 query97 2768285627012701 query98 240 197 195 195 query99 1286138012691269 Total cold run time: 280889 ms Total hot run time: 186963 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
Re: [PR] [draft] Collect bloom runtime filter filtering statistics. [doris]
doris-robot commented on PR #47305: URL: https://github.com/apache/doris/pull/47305#issuecomment-2606437627 TPC-H: Total hot run time: 32520 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 14f578fc2bd97d39702c981ca30003460d247875, data reload: false -- Round 1 -- q1 17583 569954135413 q2 2061312 179 179 q3 10472 1287735 735 q4 10218 984 568 568 q5 7610242222062206 q6 198 172 137 137 q7 911 773 627 627 q8 9257138911421142 q9 5183507948694869 q10 6846235018901890 q11 481 270 263 263 q12 345 357 223 223 q13 17783 372631213121 q14 240 252 212 212 q15 513 488 475 475 q16 637 640 587 587 q17 585 879 330 330 q18 7466645865866458 q19 2628950 554 554 q20 302 317 204 204 q21 2907219320092009 q22 368 336 318 318 Total cold run time: 104594 ms Total hot run time: 32520 ms - Round 2, with runtime_filter_mode=off - q1 5630558055375537 q2 241 338 235 235 q3 2263267623612361 q4 1434185014031403 q5 4360477848734778 q6 171 169 131 131 q7 2128202618971897 q8 2609285827332733 q9 7352715472627154 q10 3015330727942794 q11 625 510 512 510 q12 696 815 627 627 q13 3581390432263226 q14 289 299 287 287 q15 521 478 486 478 q16 637 709 644 644 q17 1213173612431243 q18 7732758973437343 q19 790 120110901090 q20 2011202319081908 q21 5705527448774877 q22 616 632 568 568 Total cold run time: 53619 ms Total hot run time: 51824 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [draft] Collect bloom runtime filter filtering statistics. [doris]
Mryange commented on PR #47305: URL: https://github.com/apache/doris/pull/47305#issuecomment-2606329898 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [draft] Collect bloom runtime filter filtering statistics. [doris]
hello-stephen commented on PR #47305: URL: https://github.com/apache/doris/pull/47305#issuecomment-2606329418 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org