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

Keep consistency between the meaning of the estimated and actual row count in the result of EXPLAIN ANALYZE #38187

Closed
time-and-fate opened this issue Sep 27, 2022 · 0 comments · Fixed by #38188
Closed

Keep consistency between the meaning of the estimated and actual row count in the result of EXPLAIN ANALYZE #38187

time-and-fate opened this issue Sep 27, 2022 · 0 comments · Fixed by #38188
Assignees
@time-and-fate
Labels
sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.

Comments

@time-and-fate
Copy link
Member

time-and-fate commented Sep 27, 2022 •
edited
Loading

Enhancement

Currently, in the result of EXPLAIN ANALYZE, for the inner children of IndexJoin and Apply, the displayed estimated row count is for a single "probe", but the displayed actual row count is for the sum of all "probes".
This caused much confusion. We need to make them consistent. I think adjusting the estimated row count to display all "probes" is proper.

This also relates to the displayed execution plan in the slow log, statements summary...
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
sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
1 participant
@time-and-fate