Re: [PR] [opt](profile) Disable profile for insert into values and other commands [doris]
github-actions[bot] commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2612079772 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: 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] [opt](profile) Disable profile for insert into values and other commands [doris]
doris-robot commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2611898697 TPC-DS: Total hot run time: 190848 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 d38087efe05ae33e0b9d2bdf9d592d211729a0a9, data reload: false query1 1320950 944 944 query2 6291203319391939 query3 10947 441744344417 query4 60874 28772 23040 23040 query5 5620593 441 441 query6 434 213 179 179 query7 5541510 325 325 query8 351 252 231 231 query9 8211258925642564 query10 443 309 254 254 query11 17420 15063 15602 15063 query12 164 118 110 110 query13 1486529 439 439 query14 11570 675764666466 query15 218 209 191 191 query16 7116643 493 493 query17 1102757 592 592 query18 1888406 327 327 query19 203 180 158 158 query20 122 115 119 115 query21 214 125 104 104 query22 4504470645004500 query23 34777 33539 33467 33467 query24 5543232423182318 query25 473 458 415 415 query26 659 239 152 152 query27 1791483 334 334 query28 4093242424132413 query29 549 527 419 419 query30 216 188 158 158 query31 950 893 832 832 query32 67 64 56 56 query33 508 360 298 298 query34 752 889 529 529 query35 794 821 784 784 query36 10271035968 968 query37 129 100 73 73 query38 4233434042254225 query39 1497143114681431 query40 199 120 101 101 query41 51 50 50 50 query42 118 110 104 104 query43 534 521 489 489 query44 1416846 848 846 query45 181 173 174 173 query46 903 1058654 654 query47 1916191018151815 query48 376 398 318 318 query49 735 493 415 415 query50 664 669 393 393 query51 4315426742714267 query52 117 105 94 94 query53 246 253 183 183 query54 489 497 423 423 query55 84 78 79 78 query56 262 246 245 245 query57 1189121411761176 query58 242 235 252 235 query59 3105323530963096 query60 283 281 276 276 query61 113 111 115 111 query62 728 728 665 665 query63 217 190 186 186 query64 12941083653 653 query65 3259311231463112 query66 715 400 300 300 query67 15979 15733 15527 15527 query68 3659863 538 538 query69 482 340 254 254 query70 1194113611001100 query71 395 282 247 247 query72 5944383737703770 query73 654 758 364 364 query74 10288 908788338833 query75 3197313127122712 query76 30661197762 762 query77 533 371 271 271 query78 10051 10047 92439243 query79 2384791 595 595 query80 976 521 449 449 query81 540 284 236 236 query82 352 151 115 115 query83 212 165 156 156 query84 347 88 79 79 query85 732 370 300 300 query86 400 320 309 309 query87 4343458843994399 query88 3700220521652165 query89 385 320 288 288 query90 1646187 188 187 query91 138 134 106 106 query92 64 57 52 52 query93 2181859 533 533 query94 759 403 296 296 query95 327 262 254 254 query96 486 614 279 279 query97 2821290227582758 query98 217 196 208 196 query99 1298136412531253 Total cold run time: 307598 ms Total hot run time: 190848 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 t
Re: [PR] [opt](profile) Disable profile for insert into values and other commands [doris]
doris-robot commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2611880958 TPC-H: Total hot run time: 32252 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit d38087efe05ae33e0b9d2bdf9d592d211729a0a9, data reload: false -- Round 1 -- q1 17573 545653715371 q2 2052313 173 173 q3 10413 1228719 719 q4 10199 958 525 525 q5 7519236621652165 q6 190 167 135 135 q7 900 771 600 600 q8 9237137811281128 q9 5076491348884888 q10 6868232218581858 q11 470 276 252 252 q12 342 370 216 216 q13 17768 367930763076 q14 231 234 203 203 q15 506 479 461 461 q16 655 607 581 581 q17 571 859 318 318 q18 6831653564996499 q19 1269953 534 534 q20 312 325 193 193 q21 2746221220532053 q22 360 329 304 304 Total cold run time: 102088 ms Total hot run time: 32252 ms - Round 2, with runtime_filter_mode=off - q1 5495551055075507 q2 246 333 232 232 q3 2273270924372437 q4 1453190314311431 q5 4389480046514651 q6 159 157 122 122 q7 1947195218211821 q8 2633284127452745 q9 7343722172037203 q10 3029327228182818 q11 579 504 493 493 q12 686 753 598 598 q13 3468447832513251 q14 289 289 272 272 q15 532 467 486 467 q16 669 706 655 655 q17 1226173512791279 q18 7647749872857285 q19 804 113411001100 q20 1960204018861886 q21 5760509848314831 q22 658 619 570 570 Total cold run time: 53245 ms Total hot run time: 51654 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] [opt](profile) Disable profile for insert into values and other commands [doris]
zhiqiang- commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2611760281 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] [opt](profile) Disable profile for insert into values and other commands [doris]
doris-robot commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2609143735 ClickBench: Total hot run time: 30.8 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 5e41421aa421558fc9f25d1fd8dd0cea7b39d3e3, data reload: false query1 0.040.050.03 query2 0.070.030.03 query3 0.240.070.07 query4 1.620.100.10 query5 0.420.410.43 query6 1.140.670.65 query7 0.020.020.01 query8 0.040.040.03 query9 0.560.500.51 query10 0.560.560.54 query11 0.150.100.10 query12 0.140.110.12 query13 0.620.590.60 query14 2.722.732.75 query15 0.900.820.83 query16 0.380.380.39 query17 1.000.991.05 query18 0.230.200.21 query19 1.841.841.96 query20 0.010.010.01 query21 15.38 0.940.59 query22 0.740.920.69 query23 15.16 1.430.58 query24 3.411.491.16 query25 0.200.180.05 query26 0.300.150.14 query27 0.050.060.04 query28 14.09 1.050.42 query29 12.58 3.963.27 query30 0.250.100.07 query31 2.810.590.39 query32 3.230.550.45 query33 3.053.093.06 query34 16.64 5.274.46 query35 4.494.534.50 query36 0.650.500.47 query37 0.090.060.06 query38 0.040.040.04 query39 0.030.020.02 query40 0.160.130.12 query41 0.080.030.03 query42 0.040.030.02 query43 0.040.030.03 Total cold run time: 106.21 s Total hot run time: 30.8 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] [opt](profile) Disable profile for insert into values and other commands [doris]
doris-robot commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2609133278 TPC-DS: Total hot run time: 192299 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 5e41421aa421558fc9f25d1fd8dd0cea7b39d3e3, data reload: false query1 1303988 935 935 query2 6306207721192077 query3 10974 44124412 query4 60356 29533 22789 22789 query5 5453610 467 467 query6 439 198 206 198 query7 5601523 311 311 query8 331 248 232 232 query9 8455264125742574 query10 447 303 239 239 query11 17896 15143 15597 15143 query12 157 111 108 108 query13 1486535 409 409 query14 11007 742074187418 query15 225 206 188 188 query16 7213629 480 480 query17 1068745 555 555 query18 1888399 301 301 query19 189 183 162 162 query20 126 113 111 111 query21 208 124 108 108 query22 4597464747304647 query23 34111 33323 33540 33323 query24 5627239923022302 query25 507 451 399 399 query26 662 264 159 159 query27 1625487 351 351 query28 4123249224492449 query29 562 555 438 438 query30 217 199 154 154 query31 944 877 819 819 query32 71 62 57 57 query33 452 368 303 303 query34 783 912 542 542 query35 787 836 771 771 query36 10441050938 938 query37 120 99 72 72 query38 4298424843034248 query39 1668144114391439 query40 229 110 104 104 query41 60 51 50 50 query42 120 101 102 101 query43 520 538 502 502 query44 1375834 852 834 query45 187 178 159 159 query46 901 1076658 658 query47 1899190118491849 query48 396 408 344 344 query49 707 490 419 419 query50 666 667 410 410 query51 4329433642844284 query52 110 99 92 92 query53 240 266 195 195 query54 485 504 409 409 query55 82 93 82 82 query56 263 274 255 255 query57 1266120411821182 query58 246 238 245 238 query59 3279319530703070 query60 290 272 262 262 query61 116 121 112 112 query62 739 711 644 644 query63 224 188 186 186 query64 12211028662 662 query65 3252320131573157 query66 725 389 344 344 query67 16203 15750 15569 15569 query68 5041848 532 532 query69 474 298 259 259 query70 1162110811421108 query71 410 288 262 262 query72 6302391838203820 query73 833 761 363 363 query74 9950892187728772 query75 3249319227152715 query76 37051163767 767 query77 492 359 278 278 query78 10225 10048 94199419 query79 3073805 594 594 query80 660 521 462 462 query81 503 275 239 239 query82 295 151 119 119 query83 168 174 169 169 query84 285 98 74 74 query85 755 343 370 343 query86 391 302 305 302 query87 4441452245094509 query88 4624215821352135 query89 394 328 286 286 query90 1629189 192 189 query91 138 130 105 105 query92 74 58 52 52 query93 2852869 547 547 query94 702 414 300 300 query95 329 266 254 254 query96 494 623 296 296 query97 2772287527652765 query98 226 200 196 196 query99 1304134712671267 Total cold run time: 311408 ms Total hot run time: 192299 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 t
Re: [PR] [opt](profile) Disable profile for insert into values and other commands [doris]
doris-robot commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2609110541 TPC-H: Total hot run time: 32272 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 5e41421aa421558fc9f25d1fd8dd0cea7b39d3e3, data reload: false -- Round 1 -- q1 17594 548453585358 q2 2044297 164 164 q3 10446 1262771 771 q4 10234 965 534 534 q5 8146241021862186 q6 194 171 133 133 q7 911 764 620 620 q8 9245140411851185 q9 5205488348844883 q10 6841233818841884 q11 477 275 258 258 q12 344 363 224 224 q13 17769 374530703070 q14 238 235 205 205 q15 504 466 470 466 q16 630 614 580 580 q17 571 873 323 323 q18 7097651763996399 q19 3410946 549 549 q20 311 316 189 189 q21 2795221919891989 q22 373 345 302 302 Total cold run time: 105379 ms Total hot run time: 32272 ms - Round 2, with runtime_filter_mode=off - q1 5619548154825481 q2 236 333 231 231 q3 2293266823442344 q4 1426187213881388 q5 4316476147244724 q6 165 162 131 131 q7 2087202617911791 q8 2658286027272727 q9 7401727572577257 q10 3022334826872687 q11 563 515 484 484 q12 645 785 657 657 q13 3545393632993299 q14 286 294 286 286 q15 519 472 463 463 q16 652 712 648 648 q17 1255174412581258 q18 7769761474167416 q19 820 117411041104 q20 1982203119231923 q21 5818520451685168 q22 595 646 571 571 Total cold run time: 53672 ms Total hot run time: 52038 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] [opt](profile) Disable profile for insert into values and other commands [doris]
zhiqiang- commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-260906 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] [opt](profile) Disable profile for insert into values and other commands [doris]
doris-robot commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2607587021 ClickBench: Total hot run time: 30.83 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 4078c2f9310c626f2a5178f4f8a184f3c62daa98, data reload: false query1 0.040.040.03 query2 0.070.030.03 query3 0.240.070.07 query4 1.620.110.10 query5 0.410.420.43 query6 1.180.650.67 query7 0.020.020.02 query8 0.040.030.04 query9 0.590.490.51 query10 0.550.560.55 query11 0.140.100.10 query12 0.140.100.11 query13 0.620.600.61 query14 2.832.722.73 query15 0.890.830.84 query16 0.380.400.39 query17 1.061.021.00 query18 0.230.210.21 query19 1.901.951.95 query20 0.010.010.01 query21 15.38 0.920.58 query22 0.760.750.64 query23 15.35 1.400.56 query24 3.020.991.99 query25 0.160.100.16 query26 0.300.150.14 query27 0.070.060.04 query28 14.49 0.960.44 query29 12.56 3.963.29 query30 0.240.080.06 query31 2.840.580.40 query32 3.230.550.46 query33 3.003.093.03 query34 16.59 5.134.50 query35 4.524.544.50 query36 0.630.510.49 query37 0.100.060.06 query38 0.050.040.03 query39 0.040.030.03 query40 0.180.130.12 query41 0.080.030.02 query42 0.030.030.02 query43 0.040.030.03 Total cold run time: 106.62 s Total hot run time: 30.83 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] [opt](profile) Disable profile for insert into values and other commands [doris]
doris-robot commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2607573568 TPC-DS: Total hot run time: 194455 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 4078c2f9310c626f2a5178f4f8a184f3c62daa98, data reload: false query1 1308997 930 930 query2 6387205720422042 query3 11101 455643654365 query4 61101 29018 23349 23349 query5 5589643 466 466 query6 451 206 193 193 query7 5583527 313 313 query8 329 243 220 220 query9 8128269526932693 query10 442 306 268 268 query11 17309 15257 15355 15257 query12 161 113 113 113 query13 1463564 424 424 query14 11786 651072316510 query15 215 201 187 187 query16 7251690 480 480 query17 1147797 569 569 query18 1907436 335 335 query19 202 191 160 160 query20 119 116 115 115 query21 215 129 104 104 query22 4343451345644513 query23 34275 33556 33397 33397 query24 5616230722802280 query25 478 474 433 433 query26 654 284 161 161 query27 1796504 323 323 query28 4062253124972497 query29 559 597 420 420 query30 218 193 155 155 query31 933 912 804 804 query32 71 60 60 60 query33 465 386 324 324 query34 765 925 513 513 query35 835 855 778 778 query36 10341070931 931 query37 124 113 83 83 query38 4357446242004200 query39 1505144314611443 query40 212 116 103 103 query41 80 55 51 51 query42 122 108 102 102 query43 529 541 502 502 query44 1372845 833 833 query45 189 185 171 171 query46 864 1148664 664 query47 1906193018481848 query48 408 438 333 333 query49 732 506 419 419 query50 696 747 404 404 query51 7117709170407040 query52 105 109 95 95 query53 233 263 188 188 query54 504 508 448 448 query55 83 83 89 83 query56 283 259 261 259 query57 1263123411611161 query58 235 257 262 257 query59 3186316228002800 query60 276 269 256 256 query61 123 116 112 112 query62 752 738 647 647 query63 232 192 184 184 query64 13141062678 678 query65 3286316631133113 query66 724 422 299 299 query67 15903 15605 15379 15379 query68 5085836 530 530 query69 499 307 265 265 query70 1242115311641153 query71 416 292 253 253 query72 6038398840903988 query73 817 790 365 365 query74 9990916288628862 query75 3345323426632663 query76 37441275795 795 query77 545 378 304 304 query78 10084 10271 93679367 query79 3086844 598 598 query80 875 568 437 437 query81 510 292 233 233 query82 574 168 115 115 query83 216 176 157 157 query84 290 106 76 76 query85 751 368 304 304 query86 425 324 305 305 query87 4544447044354435 query88 4431220922002200 query89 409 322 284 284 query90 1579194 193 193 query91 128 142 106 106 query92 66 58 55 55 query93 2409894 536 536 query94 832 462 303 303 query95 337 268 252 252 query96 496 666 279 279 query97 2837286427432743 query98 234 203 194 194 query99 1379140512681268 Total cold run time: 315226 ms Total hot run time: 194455 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 t
Re: [PR] [opt](profile) Disable profile for insert into values and other commands [doris]
doris-robot commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2607540990 TPC-H: Total hot run time: 32195 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 4078c2f9310c626f2a5178f4f8a184f3c62daa98, data reload: false -- Round 1 -- q1 17580 552553325332 q2 2050296 172 172 q3 10664 1211759 759 q4 10228 958 549 549 q5 7933237921522152 q6 198 167 135 135 q7 892 754 609 609 q8 9239135711081108 q9 5195482848644828 q10 6899232819031903 q11 471 289 265 265 q12 350 357 223 223 q13 17785 367631083108 q14 247 248 238 238 q15 530 487 472 472 q16 625 621 589 589 q17 574 864 340 340 q18 7045654264476447 q19 1802925 533 533 q20 308 317 181 181 q21 2883214119491949 q22 366 334 303 303 Total cold run time: 103864 ms Total hot run time: 32195 ms - Round 2, with runtime_filter_mode=off - q1 5522546055995460 q2 239 335 231 231 q3 2286265723622362 q4 1420181413821382 q5 4302470646744674 q6 167 159 127 127 q7 2063196618181818 q8 2653280526852685 q9 7314725172287228 q10 3052328627992799 q11 593 525 495 495 q12 638 742 637 637 q13 3545393232933293 q14 287 296 285 285 q15 518 469 470 469 q16 651 689 670 670 q17 1195174212841284 q18 7744747974637463 q19 832 939 1109939 q20 2041206518841884 q21 5708533650295029 q22 618 599 579 579 Total cold run time: 53388 ms Total hot run time: 51793 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] [opt](profile) Disable profile for insert into values and other commands [doris]
zhiqiang- commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2607439132 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] [opt](profile) Disable profile for insert into values and other commands [doris]
zhiqiang- commented on code in PR #47296:
URL: https://github.com/apache/doris/pull/47296#discussion_r1925441295
##
fe/fe-core/src/main/java/org/apache/doris/qe/StmtExecutor.java:
##
@@ -1226,6 +1231,40 @@ private boolean isQuery() {
&& !(((LogicalPlanAdapter) parsedStmt).getLogicalPlan()
instanceof Command));
}
+private boolean isProfileSafeStmt() {
+//
fe/fe-core/src/main/java/org/apache/doris/nereids/NereidsPlanner.java:131
+// Only generate profile for NereidsPlanner.
+if (!(parsedStmt instanceof LogicalPlanAdapter)) {
+return false;
+}
+
+LogicalPlan plan = ((LogicalPlanAdapter) parsedStmt).getLogicalPlan();
+
+if (plan instanceof InsertIntoTableCommand) {
+LogicalPlan logicalPlan = ((InsertIntoTableCommand)
plan).getLogicalQuery();
+if ((logicalPlan instanceof UnboundTableSink) || (logicalPlan
instanceof UnboundBaseExternalTableSink)) {
+if (logicalPlan.children() == null ||
logicalPlan.children().isEmpty()) {
+return false;
+}
+
+for (Plan child : logicalPlan.children()) {
+if (child instanceof InlineTable) {
+return false;
+}
+}
+}
+return true;
+}
+
+// Generate profile for CreateTableCommand(mainly for create as
select).
Review Comment:
done
--
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] [opt](profile) Disable profile for insert into values and other commands [doris]
zhiqiang- commented on code in PR #47296:
URL: https://github.com/apache/doris/pull/47296#discussion_r1925440993
##
fe/fe-core/src/main/java/org/apache/doris/qe/StmtExecutor.java:
##
@@ -1226,6 +1231,40 @@ private boolean isQuery() {
&& !(((LogicalPlanAdapter) parsedStmt).getLogicalPlan()
instanceof Command));
}
+private boolean isProfileSafeStmt() {
+//
fe/fe-core/src/main/java/org/apache/doris/nereids/NereidsPlanner.java:131
+// Only generate profile for NereidsPlanner.
+if (!(parsedStmt instanceof LogicalPlanAdapter)) {
+return false;
+}
+
+LogicalPlan plan = ((LogicalPlanAdapter) parsedStmt).getLogicalPlan();
+
+if (plan instanceof InsertIntoTableCommand) {
+LogicalPlan logicalPlan = ((InsertIntoTableCommand)
plan).getLogicalQuery();
+if ((logicalPlan instanceof UnboundTableSink) || (logicalPlan
instanceof UnboundBaseExternalTableSink)) {
+if (logicalPlan.children() == null ||
logicalPlan.children().isEmpty()) {
+return false;
+}
+
+for (Plan child : logicalPlan.children()) {
+if (child instanceof InlineTable) {
+return false;
+}
+}
+}
Review Comment:
done
--
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] [opt](profile) Disable profile for insert into values and other commands [doris]
morrySnow commented on code in PR #47296:
URL: https://github.com/apache/doris/pull/47296#discussion_r1925340990
##
fe/fe-core/src/main/java/org/apache/doris/qe/StmtExecutor.java:
##
@@ -1226,6 +1231,40 @@ private boolean isQuery() {
&& !(((LogicalPlanAdapter) parsedStmt).getLogicalPlan()
instanceof Command));
}
+private boolean isProfileSafeStmt() {
+//
fe/fe-core/src/main/java/org/apache/doris/nereids/NereidsPlanner.java:131
+// Only generate profile for NereidsPlanner.
+if (!(parsedStmt instanceof LogicalPlanAdapter)) {
+return false;
+}
+
+LogicalPlan plan = ((LogicalPlanAdapter) parsedStmt).getLogicalPlan();
+
+if (plan instanceof InsertIntoTableCommand) {
+LogicalPlan logicalPlan = ((InsertIntoTableCommand)
plan).getLogicalQuery();
+if ((logicalPlan instanceof UnboundTableSink) || (logicalPlan
instanceof UnboundBaseExternalTableSink)) {
+if (logicalPlan.children() == null ||
logicalPlan.children().isEmpty()) {
+return false;
+}
+
+for (Plan child : logicalPlan.children()) {
+if (child instanceof InlineTable) {
+return false;
+}
+}
+}
+return true;
+}
+
+// Generate profile for CreateTableCommand(mainly for create as
select).
Review Comment:
comment is different with code
##
fe/fe-core/src/main/java/org/apache/doris/qe/StmtExecutor.java:
##
@@ -1226,6 +1231,40 @@ private boolean isQuery() {
&& !(((LogicalPlanAdapter) parsedStmt).getLogicalPlan()
instanceof Command));
}
+private boolean isProfileSafeStmt() {
+//
fe/fe-core/src/main/java/org/apache/doris/nereids/NereidsPlanner.java:131
+// Only generate profile for NereidsPlanner.
+if (!(parsedStmt instanceof LogicalPlanAdapter)) {
+return false;
+}
+
+LogicalPlan plan = ((LogicalPlanAdapter) parsedStmt).getLogicalPlan();
+
+if (plan instanceof InsertIntoTableCommand) {
+LogicalPlan logicalPlan = ((InsertIntoTableCommand)
plan).getLogicalQuery();
+if ((logicalPlan instanceof UnboundTableSink) || (logicalPlan
instanceof UnboundBaseExternalTableSink)) {
+if (logicalPlan.children() == null ||
logicalPlan.children().isEmpty()) {
+return false;
+}
+
+for (Plan child : logicalPlan.children()) {
+if (child instanceof InlineTable) {
+return false;
+}
+}
+}
Review Comment:
add comment to explain what does `InlineTable` mean
--
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] [opt](profile) Disable profile for insert into values and other commands [doris]
doris-robot commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2607097137 ClickBench: Total hot run time: 31.3 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 01dbb1c8e0ccbcd5b3371f77b8839d332287744e, data reload: false query1 0.040.040.04 query2 0.070.030.04 query3 0.240.070.07 query4 1.610.100.11 query5 0.420.420.42 query6 1.160.660.65 query7 0.020.020.02 query8 0.040.030.03 query9 0.590.500.49 query10 0.550.570.57 query11 0.150.100.10 query12 0.140.110.11 query13 0.590.600.59 query14 2.832.762.83 query15 0.890.810.82 query16 0.370.400.38 query17 0.961.031.02 query18 0.240.210.21 query19 1.901.822.02 query20 0.020.010.01 query21 15.38 0.910.58 query22 0.760.700.67 query23 15.41 1.330.59 query24 2.931.501.57 query25 0.200.170.12 query26 0.260.130.13 query27 0.070.060.06 query28 14.36 0.980.42 query29 12.61 4.063.33 query30 0.250.100.07 query31 2.820.570.40 query32 3.230.550.46 query33 2.963.043.09 query34 16.59 5.174.46 query35 4.594.454.53 query36 0.640.500.49 query37 0.080.060.06 query38 0.040.030.04 query39 0.030.020.02 query40 0.160.140.12 query41 0.080.030.02 query42 0.030.020.03 query43 0.030.030.03 Total cold run time: 106.34 s Total hot run time: 31.3 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] [opt](profile) Disable profile for insert into values and other commands [doris]
doris-robot commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2607084683 TPC-DS: Total hot run time: 187748 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 01dbb1c8e0ccbcd5b3371f77b8839d332287744e, data reload: false query1 977 389 380 380 query2 6527215021172117 query3 6800210 216 210 query4 33641 23274 22968 22968 query5 4323604 474 474 query6 297 196 191 191 query7 4606500 307 307 query8 297 246 236 236 query9 9360269026672667 query10 480 315 259 259 query11 18213 15298 15048 15048 query12 149 105 106 105 query13 1659519 411 411 query14 9549700572167005 query15 258 196 187 187 query16 8103628 452 452 query17 1623745 571 571 query18 2125390 289 289 query19 225 179 148 148 query20 115 109 110 109 query21 211 119 112 112 query22 4129417942154179 query23 34045 33480 32865 32865 query24 6709222522442225 query25 469 436 388 388 query26 1091224 153 153 query27 2131463 327 327 query28 5182246224472447 query29 542 504 406 406 query30 227 187 169 169 query31 960 910 819 819 query32 88 63 59 59 query33 530 378 303 303 query34 735 846 509 509 query35 812 814 737 737 query36 997 1023930 930 query37 126 102 83 83 query38 4250416440494049 query39 1477142514041404 query40 208 120 102 102 query41 60 58 50 50 query42 125 101 103 101 query43 522 528 506 506 query44 1298797 804 797 query45 185 168 166 166 query46 850 1037638 638 query47 1811181617701770 query48 372 416 325 325 query49 780 487 406 406 query50 625 662 394 394 query51 6831679968756799 query52 104 101 89 89 query53 225 248 190 190 query54 493 477 433 433 query55 80 79 83 79 query56 264 264 243 243 query57 1201116110831083 query58 243 239 269 239 query59 3074316631423142 query60 300 263 282 263 query61 149 115 115 115 query62 824 732 663 663 query63 223 199 187 187 query64 45531007682 682 query65 3278314231933142 query66 1068416 299 299 query67 15697 15653 15407 15407 query68 4880832 549 549 query69 470 290 263 263 query70 1198116911381138 query71 380 278 269 269 query72 5874384135673567 query73 645 750 364 364 query74 10297 908688688868 query75 3158319026322632 query76 31621196775 775 query77 515 360 268 268 query78 988710051 93539353 query79 2705799 597 597 query80 592 562 443 443 query81 516 280 248 248 query82 450 155 125 125 query83 189 177 147 147 query84 243 95 82 82 query85 796 366 364 364 query86 401 326 304 304 query87 4550448343564356 query88 4894219621672167 query89 403 336 288 288 query90 1862188 189 188 query91 141 138 170 138 query92 65 57 53 53 query93 1864864 541 541 query94 684 397 281 281 query95 339 263 253 253 query96 489 609 283 283 query97 2731282827672767 query98 226 203 210 203 query99 1261135112661266 Total cold run time: 285348 ms Total hot run time: 187748 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] [opt](profile) Disable profile for insert into values and other commands [doris]
doris-robot commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2607057857 TPC-H: Total hot run time: 32048 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 01dbb1c8e0ccbcd5b3371f77b8839d332287744e, data reload: false -- Round 1 -- q1 17679 556453935393 q2 2053298 168 168 q3 10411 1270728 728 q4 10227 976 528 528 q5 7566236621582158 q6 194 166 133 133 q7 918 755 594 594 q8 9256137011251125 q9 5349499648734873 q10 6827233418901890 q11 479 279 257 257 q12 345 359 224 224 q13 17779 367730623062 q14 239 224 221 221 q15 523 477 453 453 q16 629 614 582 582 q17 560 872 309 309 q18 7094656463376337 q19 1213948 527 527 q20 316 336 201 201 q21 2794218919721972 q22 361 334 313 313 Total cold run time: 102812 ms Total hot run time: 32048 ms - Round 2, with runtime_filter_mode=off - q1 5445550054505450 q2 241 333 240 240 q3 2309267723422342 q4 1400179113551355 q5 4310479146264626 q6 165 157 127 127 q7 2047199318481848 q8 2679282626912691 q9 7277724871997199 q10 2989328027812781 q11 593 527 486 486 q12 684 749 629 629 q13 3454396332383238 q14 285 317 268 268 q15 515 479 459 459 q16 634 684 628 628 q17 1212173312561256 q18 7775748773497349 q19 779 113810661066 q20 2013201519091909 q21 5724531149074907 q22 632 596 590 590 Total cold run time: 53162 ms Total hot run time: 51444 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] [opt](profile) Disable profile for insert into values and other commands [doris]
zhiqiang- commented on code in PR #47296:
URL: https://github.com/apache/doris/pull/47296#discussion_r1925171975
##
fe/fe-core/src/main/java/org/apache/doris/qe/StmtExecutor.java:
##
@@ -1226,6 +1230,40 @@ private boolean isQuery() {
&& !(((LogicalPlanAdapter) parsedStmt).getLogicalPlan()
instanceof Command));
}
+private boolean isProfileSafeStmt() {
+//
fe/fe-core/src/main/java/org/apache/doris/nereids/NereidsPlanner.java:131
+// Only generate profile for NereidsPlanner.
+if (!(parsedStmt instanceof LogicalPlanAdapter)) {
+return false;
+}
+
+LogicalPlan plan = ((LogicalPlanAdapter) parsedStmt).getLogicalPlan();
+
+if (plan instanceof InsertIntoTableCommand) {
+LogicalPlan logicalPlan = ((InsertIntoTableCommand)
plan).getLogicalQuery();
+if (logicalPlan instanceof UnboundTableSink) {
Review Comment:
fixed by adding UnboundBaseExternalTableSink
--
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] [opt](profile) Disable profile for insert into values and other commands [doris]
zhiqiang- commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2607006671 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] [opt](profile) Disable profile for insert into values and other commands [doris]
github-actions[bot] commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2606833098 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: 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] [opt](profile) Disable profile for insert into values and other commands [doris]
zclllyybb commented on code in PR #47296:
URL: https://github.com/apache/doris/pull/47296#discussion_r1925064501
##
fe/fe-core/src/main/java/org/apache/doris/qe/StmtExecutor.java:
##
@@ -1226,6 +1230,40 @@ private boolean isQuery() {
&& !(((LogicalPlanAdapter) parsedStmt).getLogicalPlan()
instanceof Command));
}
+private boolean isProfileSafeStmt() {
+//
fe/fe-core/src/main/java/org/apache/doris/nereids/NereidsPlanner.java:131
+// Only generate profile for NereidsPlanner.
+if (!(parsedStmt instanceof LogicalPlanAdapter)) {
+return false;
+}
+
+LogicalPlan plan = ((LogicalPlanAdapter) parsedStmt).getLogicalPlan();
+
+if (plan instanceof InsertIntoTableCommand) {
+LogicalPlan logicalPlan = ((InsertIntoTableCommand)
plan).getLogicalQuery();
+if (logicalPlan instanceof UnboundTableSink) {
Review Comment:
what if UnboundJdbcSink or UnboundHiveSink? is it safe for them to generate
profile not like olap table?
--
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] [opt](profile) Disable profile for insert into values and other commands [doris]
github-actions[bot] commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2606833172 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: 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] [opt](profile) Disable profile for insert into values and other commands [doris]
zhiqiang- commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2606652194 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: 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] [opt](profile) Disable profile for insert into values and other commands [doris]
doris-robot commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2606496511 TPC-DS: Total hot run time: 194441 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 4df958b58505de661b676a6bfc8855a6b8e37d59, data reload: false query1 1368972 913 913 query2 6473209220172017 query3 11094 459146054591 query4 32588 23194 22894 22894 query5 3476603 486 486 query6 284 199 186 186 query7 3971502 309 309 query8 298 241 235 235 query9 9062260926042604 query10 459 309 248 248 query11 17776 15213 14905 14905 query12 152 106 106 106 query13 1576526 399 399 query14 9414764672527252 query15 239 239 193 193 query16 7868687 467 467 query17 1617798 548 548 query18 2098415 307 307 query19 206 188 160 160 query20 128 126 112 112 query21 207 124 113 113 query22 4698465143474347 query23 34684 34139 33340 33340 query24 6620226622882266 query25 478 437 382 382 query26 728 251 159 159 query27 2047502 343 343 query28 5435247924802479 query29 604 535 417 417 query30 221 197 155 155 query31 955 876 811 811 query32 67 57 58 57 query33 481 365 312 312 query34 797 912 519 519 query35 853 854 794 794 query36 10141038974 974 query37 130 103 78 78 query38 4358435943034303 query39 1476145814391439 query40 209 124 99 99 query41 50 47 49 47 query42 121 104 104 104 query43 519 526 503 503 query44 1379819 829 819 query45 190 184 168 168 query46 889 1085659 659 query47 1922195118741874 query48 411 409 334 334 query49 719 492 431 431 query50 677 688 394 394 query51 6902714570107010 query52 96 101 90 90 query53 219 254 217 217 query54 473 509 424 424 query55 83 81 79 79 query56 256 286 245 245 query57 1216120311431143 query58 260 244 248 244 query59 3067323129602960 query60 294 271 256 256 query61 136 141 119 119 query62 794 723 661 661 query63 218 183 181 181 query64 32241036651 651 query65 3234316031743160 query66 697 402 294 294 query67 15904 15740 15481 15481 query68 5234875 507 507 query69 463 286 251 251 query70 1225114410651065 query71 377 289 281 281 query72 5441392139323921 query73 641 798 354 354 query74 10055 897790888977 query75 3244315426612661 query76 30141234790 790 query77 459 363 278 278 query78 10077 10049 93659365 query79 2783814 605 605 query80 1394614 444 444 query81 561 277 234 234 query82 362 150 121 121 query83 170 172 149 149 query84 234 83 73 73 query85 770 386 320 320 query86 459 323 305 305 query87 4351450844514451 query88 4543216621282128 query89 403 322 291 291 query90 1819193 188 188 query91 133 143 106 106 query92 65 59 51 51 query93 2857885 512 512 query94 709 468 296 296 query95 327 263 259 259 query96 491 659 292 292 query97 2793284328202820 query98 230 202 209 202 query99 1308136112771277 Total cold run time: 287151 ms Total hot run time: 194441 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] [opt](profile) Disable profile for insert into values and other commands [doris]
doris-robot commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2606504753 ClickBench: Total hot run time: 31.4 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 4df958b58505de661b676a6bfc8855a6b8e37d59, data reload: false query1 0.030.040.03 query2 0.070.030.03 query3 0.230.070.07 query4 1.610.100.10 query5 0.420.420.42 query6 1.160.640.65 query7 0.020.010.02 query8 0.040.040.03 query9 0.600.500.49 query10 0.550.560.55 query11 0.150.100.10 query12 0.140.100.10 query13 0.610.600.60 query14 2.842.722.83 query15 0.900.810.82 query16 0.370.380.38 query17 1.071.031.05 query18 0.230.210.21 query19 1.901.801.90 query20 0.010.010.01 query21 15.35 0.920.56 query22 0.750.740.76 query23 15.24 1.430.55 query24 2.931.651.98 query25 0.170.120.15 query26 0.300.150.14 query27 0.080.050.05 query28 14.33 0.900.43 query29 12.55 3.903.24 query30 0.250.100.06 query31 2.800.610.38 query32 3.220.550.46 query33 2.952.983.02 query34 16.66 5.254.55 query35 4.554.614.56 query36 0.820.500.49 query37 0.090.070.06 query38 0.050.030.03 query39 0.030.020.03 query40 0.170.130.13 query41 0.080.020.03 query42 0.040.020.03 query43 0.030.030.03 Total cold run time: 106.39 s Total hot run time: 31.4 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] [opt](profile) Disable profile for insert into values and other commands [doris]
doris-robot commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2606477913 TPC-H: Total hot run time: 32873 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 4df958b58505de661b676a6bfc8855a6b8e37d59, data reload: false -- Round 1 -- q1 17569 560854865486 q2 2044325 172 172 q3 10402 1258767 767 q4 10255 979 516 516 q5 8399240522432243 q6 208 170 137 137 q7 933 771 613 613 q8 9249148612791279 q9 5322501249564956 q10 6872232918871887 q11 479 278 255 255 q12 351 372 217 217 q13 17802 379430963096 q14 224 236 208 208 q15 530 481 471 471 q16 615 607 579 579 q17 570 904 319 319 q18 6915663366696633 q19 30541025584 584 q20 312 330 188 188 q21 2816220519601960 q22 373 346 307 307 Total cold run time: 105294 ms Total hot run time: 32873 ms - Round 2, with runtime_filter_mode=off - q1 5855568157335681 q2 253 328 232 232 q3 2283266922882288 q4 1520184214071407 q5 4343473348904733 q6 185 169 129 129 q7 2141197118291829 q8 2688294927642764 q9 7267730772827282 q10 3089321427072707 q11 589 510 489 489 q12 687 827 674 674 q13 3603399532903290 q14 295 305 286 286 q15 515 468 465 465 q16 651 678 643 643 q17 1264175612921292 q18 7738748474147414 q19 843 983 1246983 q20 2019206119371937 q21 5716542350465046 q22 634 586 583 583 Total cold run time: 54178 ms Total hot run time: 52154 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] [opt](profile) Disable profile for insert into values and other commands [doris]
zhiqiang- commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2606430563 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] [opt](profile) Disable profile for insert into values and other commands [doris]
Thearas commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2604824897 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
Re: [PR] [opt](profile) Disable profile for insert into values and other commands [doris]
zhiqiang- commented on PR #47296: URL: https://github.com/apache/doris/pull/47296#issuecomment-2604825190 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
