Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Make tidb generate binary plan to support the visual plan feature #35889

Closed
time-and-fate opened this issue Jul 1, 2022 · 0 comments · Fixed by #35698
Closed

Make tidb generate binary plan to support the visual plan feature #35889

time-and-fate opened this issue Jul 1, 2022 · 0 comments · Fixed by #35698
Assignees
@time-and-fate
Labels
type/enhancement The issue or PR belongs to an enhancement.

Comments

@time-and-fate
Copy link
Member

Enhancement

The dashboard is implementing a feature to display the execution plan visually instead of a string.
This needs tidb to output the execution plan more structurally.

We add a new message to transmit the execution plan in protobuf: pingcap/tipb#265
And we plan to add a new field to output it in the slow query/slow log and the statements summary.

Design of the changes at tidb side (in Chinese): https://docs.google.com/document/d/14PyiK1rEZ4OjCpmWSW-9l0wHlYeL9EA0vaPdtWVl44g/edit
@time-and-fate time-and-fate added the type/enhancement The issue or PR belongs to an enhancement. label Jul 1, 2022
@time-and-fate time-and-fate mentioned this issue Jul 1, 2022
Merged
12 tasks
@time-and-fate time-and-fate self-assigned this Jul 4, 2022
@time-and-fate time-and-fate mentioned this issue Jul 4, 2022
Merged
12 tasks
ti-chi-bot pushed a commit that referenced this issue Jul 6, 2022
@time-and-fate
planner: refactor "access object" related logic and prepare for binar…
07f1242 
…y plan (#35890)

ref #35888, ref #35889
ti-chi-bot pushed a commit that referenced this issue Jul 6, 2022
@time-and-fate
executor: fix incorrect runtime stats when there are applys (#35919)
562bb9f 
ref #35889, close #35911
This was referenced Jul 6, 2022
Merged
Merged
Merged
ti-chi-bot pushed a commit that referenced this issue Jul 8, 2022
@time-and-fate
distsql, execdetails: add information into runtime stats (#35993)
d941cb9 
ref #35889
@time-and-fate time-and-fate mentioned this issue Jul 8, 2022
Merged
ti-chi-bot pushed a commit that referenced this issue Jul 9, 2022
@time-and-fate
planner: introduce flat plan (#35994)
28bf364 
ref #35888, ref #35889
@time-and-fate time-and-fate mentioned this issue Jul 14, 2022
Merged
12 tasks
ti-chi-bot pushed a commit that referenced this issue Jul 18, 2022
@time-and-fate
*: support the binary plan through EXPLAIN format='binary' and tidb_d…
4cade24 
…ecode_binary_plan (#36221)

ref #35889
ti-chi-bot pushed a commit that referenced this issue Jul 20, 2022
@time-and-fate
*: add binary plan in stmt summary and slow log/query (#35698)
a52656f 
close #35889
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@time-and-fate time-and-fate

Labels
type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

*: add binary plan in stmt summary and slow log/query time-and-fate/tidb
1 participant
@time-and-fate