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.

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

Failed to parse plan #691

Open
Youssefamr123 opened this issue Dec 13, 2024 · 1 comment
Open

Failed to parse plan #691

Youssefamr123 opened this issue Dec 13, 2024 · 1 comment
Labels

Comments

@Youssefamr123
Copy link

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
@Krysztophe
Copy link

@Youssefamr123 : remove the numbers & points, and the spaces before the HashSetOps and it works: https://explain.dalibo.com/plan/86b338d97abfgf17

Where did you get this plan?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants