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

opt: fix EXPLAIN (OPT, ENV) so it doesn't need manual changes #43399

Closed
RaduBerinde opened this issue Dec 20, 2019 · 2 comments
Closed

opt: fix EXPLAIN (OPT, ENV) so it doesn't need manual changes #43399

RaduBerinde opened this issue Dec 20, 2019 · 2 comments
Assignees
@RaduBerinde
Labels
A-sql-optimizer SQL logical planning and optimizations. C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)
Projects
BACKLOG, NO NEW ISSUES: SQL Optimizer

Comments

@RaduBerinde
Copy link
Member

The output of EXPLAIN (OPT, ENV) frequently needs a lot of massaging:

  • FKs can refer to tables that are not in the output
  • if the tables have FKs to each other, they are not necessarily in the right order
  • the statistics use the fully-qualified name.

In complicated cases, this is a lot of work. We need to fix the command to address all these issues.
@RaduBerinde RaduBerinde self-assigned this Dec 20, 2019
@RaduBerinde RaduBerinde added this to Triage in BACKLOG, NO NEW ISSUES: SQL Optimizer via automation Dec 20, 2019
@RaduBerinde
Copy link
Member Author

INTERLEAVE IN PARENT tables can also be missing.

@awoods187 awoods187 added C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) A-sql-optimizer SQL logical planning and optimizations. labels Dec 20, 2019
@RaduBerinde
Copy link
Member Author

Ah, this is a dup of #37402. Adding more to that one.

BACKLOG, NO NEW ISSUES: SQL Optimizer automation moved this from Triage to Done Dec 21, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@RaduBerinde RaduBerinde

Labels
A-sql-optimizer SQL logical planning and optimizations. C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)
Projects
BACKLOG, NO NEW ISSUES: SQL Optimizer
Done
Milestone
No milestone
Development

No branches or pull requests
2 participants
@RaduBerinde @awoods187