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

Refine Explain's format and content. #15347

Closed
2 tasks done
LittleFall opened this issue Mar 12, 2020 · 1 comment · Fixed by #15507
Closed
2 tasks done

Refine Explain's format and content. #15347

LittleFall opened this issue Mar 12, 2020 · 1 comment · Fixed by #15507
Assignees
@LittleFall
Labels
sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.

Comments

@LittleFall
Copy link
Contributor

LittleFall commented Mar 12, 2020 •
edited
Loading

The following changes are exported from some internal or external DBAs.

  • For EXPLAIN and EXPLAIN ANALYZE, add column access object after column task, it includes table name or index name.
  • For EXPLAIN ANALYZE, swap order of column operator info and execution info.

For clear:

1 2 3 4 5 6 7 8 9
EXPLAIN (old) id estRows task operator info
EXPLAIN (new) id estRows task access object operator info
EXPLAIN ANALYZE (old) id estRows actRows task operator info execution info memory disk
EXPLAIN ANALYZE (new) id estRows actRows task access object execution info operator info memory disk
@LittleFall LittleFall added type/enhancement The issue or PR belongs to an enhancement. sig/planner SIG: Planner labels Mar 12, 2020
@LittleFall LittleFall self-assigned this Mar 12, 2020
@LittleFall
Copy link
Contributor Author

And I'm working for this.

@LittleFall LittleFall mentioned this issue Mar 20, 2020
Merged
@LittleFall LittleFall linked a pull request Mar 20, 2020 that will close this issue
*: Refine Explain's format. #15507
Merged
@LittleFall LittleFall mentioned this issue Nov 24, 2021
Closed
3 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@LittleFall LittleFall

Labels
sig/planner SIG: Planner 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.

*: Refine Explain's format.
1 participant
@LittleFall