You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "jackwener (via GitHub)" <gi...@apache.org> on 2023/11/14 05:51:58 UTC
[PR] [enhancement](Nereids): add nereids profile [doris]
jackwener opened a new pull request, #26935:
URL: https://github.com/apache/doris/pull/26935
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
## Further comments
If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhancement](Nereids): add nereids profile [doris]
Posted by "jackwener (via GitHub)" <gi...@apache.org>.
jackwener merged PR #26935:
URL: https://github.com/apache/doris/pull/26935
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhancement](Nereids): add nereids profile [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26935:
URL: https://github.com/apache/doris/pull/26935#issuecomment-1809713544
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 801b8a3faa266603d7aa03f953345b3bf27c6912, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5231 5114 5176 5114
q2 356 159 162 159
q3 2047 2018 2040 2018
q4 1403 1363 1379 1363
q5 3992 3973 3990 3973
q6 252 133 133 133
q7 1477 893 901 893
q8 2775 2777 2746 2746
q9 9697 9550 9356 9356
q10 3454 3509 3533 3509
q11 395 262 247 247
q12 434 283 295 283
q13 4601 4129 4120 4120
q14 314 282 285 282
q15 600 565 529 529
q16 675 588 585 585
q17 1129 1063 1085 1063
q18 8128 7537 7606 7537
q19 1664 1674 1667 1667
q20 566 315 305 305
q21 4699 4317 4359 4317
q22 520 401 403 401
Total cold run time: 54409 ms
Total hot run time: 50600 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5034 5057 5043 5043
q2 331 218 235 218
q3 4054 3960 4001 3960
q4 2781 2771 2759 2759
q5 9880 9750 9728 9728
q6 244 124 122 122
q7 3021 2442 2465 2442
q8 4810 4897 4858 4858
q9 13005 12783 12901 12783
q10 4062 4177 4169 4169
q11 783 656 644 644
q12 991 821 798 798
q13 4279 3864 3810 3810
q14 375 336 371 336
q15 583 533 540 533
q16 775 670 702 670
q17 3837 3901 3926 3901
q18 9553 9360 9318 9318
q19 1818 1767 1745 1745
q20 2390 2044 2071 2044
q21 9090 8862 8846 8846
q22 970 850 893 850
Total cold run time: 82666 ms
Total hot run time: 79577 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhancement](Nereids): add nereids profile [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #26935:
URL: https://github.com/apache/doris/pull/26935#issuecomment-1809754322
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhancement](Nereids): add nereids profile [doris]
Posted by "jackwener (via GitHub)" <gi...@apache.org>.
jackwener commented on PR #26935:
URL: https://github.com/apache/doris/pull/26935#issuecomment-1809609460
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhancement](Nereids): add nereids profile [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #26935:
URL: https://github.com/apache/doris/pull/26935#issuecomment-1809757314
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhancement](Nereids): add nereids profile [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26935:
URL: https://github.com/apache/doris/pull/26935#issuecomment-1809726875
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 45.42 seconds
stream load tsv: 555 seconds loaded 74807831229 Bytes, about 128 MB/s
stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
stream load orc: 65 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 29.6 seconds inserted 10000000 Rows, about 337K ops/s
storage size: 17096795379 Bytes
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org