We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
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
Version of PEV2: xxxx
Copy the failing plan
QUERY PLAN 1. HashSetOp Except (cost=0.29..3941.33 rows=6679 width=28) (actual time=35.005..36.214 rows=5077 loops=1) 2. -> Append (cost=0.29..3674.20 rows=106854 width=28) (actual time=0.086..22.669 rows=106854 loops=1) 3. -> Subquery Scan on "*SELECT* 1" (cost=0.29..453.51 rows=13009 width=10) (actual time=0.085..2.777 rows=13009 loops=1) 4. -> Index Only Scan using idx_weight_ndb_no on weight (cost=0.29..323.42 rows=13009 width=6) (actual time=0.083..1.797 rows=13009 loops=1) 5. Heap Fetches: 0 6. -> Subquery Scan on "*SELECT* 2" (cost=0.29..2686.42 rows=93845 width=10) (actual time=0.042..14.659 rows=93845 loops=1) 7. -> Index Only Scan using idx_datsrcln_ndb_no on datsrcln (cost=0.29..1747.97 rows=93845 width=6) (actual time=0.040..7.620 rows=93845 loops=1) 8. Heap Fetches: 0 Planning Time: 0.285 ms Execution Time: 36.560 ms
The text was updated successfully, but these errors were encountered:
@Youssefamr123 : remove the numbers & points, and the spaces before the HashSetOps and it works: https://explain.dalibo.com/plan/86b338d97abfgf17
HashSetOps
Where did you get this plan?
Sorry, something went wrong.
No branches or pull requests
Version of PEV2: xxxx
Copy the failing plan
The text was updated successfully, but these errors were encountered: