Vallishp opened a new pull request, #44318:
URL: https://github.com/apache/doris/pull/44318
### What problem does this PR solve?
Issue Number: close #42570
Related PR: #xxx
Problem Summary:
[Enhancement] (nereids)implement CleanAllProfileCommand in nereids
### Release note
None
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [ ] Regression test // added nereids check.
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason <!-- Add your reason? -->
UT verification test
mysql> set enable_profile=true;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from table1;
Empty set (0.00 sec)
mysql>
<div class="ant-table ant-table-small ant-table-bordered
ant-table-ping-right ant-table-scroll-horizontal" style="box-sizing:
border-box; margin: 0px; padding: 0px; color: rgba(0, 0, 0, 0.85);
font-variant: tabular-nums; line-height: 1.5715; list-style: none;
font-feature-settings: "tnum"; position: relative; font-size: 14px;
background: rgb(255, 255, 255); border-radius: 2px; font-family: -apple-system,
BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue",
Arial, "Noto Sans", sans-serif, "Apple Color Emoji",
"Segoe UI Emoji", "Segoe UI Symbol", "Noto Color
Emoji"; font-style: normal; font-weight: 400; letter-spacing: normal;
orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows:
2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal;
text-decoration-thickness: initial; text-decoration-style: initial;
text-decoration-color: initial;"><div class="ant-table-
container" style="box-sizing: border-box; border-top-right-radius: 2px;
border-top-left-radius: 2px; border-left: 1px solid rgb(240, 240, 240);
position: relative;"><div class="ant-table-content" style="box-sizing:
border-box; overflow: auto hidden;">
Profile ID | Task Type | Start Time | End Time | Total | Task State | User |
Default Catalog | Default Db | Sql Statement | Action
-- | -- | -- | -- | -- | -- | -- | -- | -- | -- | --
| | | | | | | | | |
9e174a7a49084826-bf58a88be1c7fe58 | QUERY | 2024-11-20 05:54:34 | 2024-11-20
05:54:34 | 3ms | EOF | root | internal | test_recover_db | select * from table1
| Download
</div></div></div><ul class="ant-pagination ant-pagination-mini
ant-table-pagination ant-table-pagination-right" style="box-sizing: border-box;
margin: 16px 0px; color: rgba(0, 0, 0, 0.85); font-size: 14px; font-variant:
tabular-nums; line-height: 1.5715; font-feature-settings: "tnum";
padding: 0px; list-style: circle; display: flex; flex-wrap: wrap; row-gap: 8px;
justify-content: flex-end; font-family: -apple-system, BlinkMacSystemFont,
"Segoe UI", Roboto, "Helvetica Neue", Arial, "Noto
Sans", sans-serif, "Apple Color Emoji", "Segoe UI
Emoji", "Segoe UI Symbol", "Noto Color Emoji";
font-style: normal; font-weight: 400; letter-spacing: normal; orphans: 2;
text-align: start; text-indent: 0px; text-transform: none; widows: 2;
word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal;
background-color: rgb(255, 255, 255); text-decoration-thickness: initial;
text-decoration-style: initial; tex
t-decoration-color: initial;"><br class="Apple-interchange-newline">Profile ID
Task Type
Start Time
End Time
Total
Task State
User
Default Catalog
Default Db
Sql Statement
Action
[9e174a7a49084826-bf58a88be1c7fe58](http://127.0.0.1:8030/QueryProfile/9e174a7a49084826-bf58a88be1c7fe58)
QUERY 2024-11-20 05:54:34 2024-11-20 05:54:34 3ms EOF
root internal test_recover_db
select * from table1
mysql> clean all profile
-> ;
Query OK, 0 rows affected (0.00 sec)
mysql>
After clean query profile doesnt have old profiles.
- Behavior changed:
- [ ] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [ ] No.
- [ ] Yes. <!-- Add document PR link here. eg:
https://github.com/apache/doris-website/pull/1214 -->
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label <!-- Add branch pick label that this PR should
merge into -->
--
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]
