From: | "Hou, Zhijie" <houzj(dot)fnst(at)cn(dot)fujitsu(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Initplan placed at the righttree or the lefttree of joinnode |
Date: | 2020-10-22 09:43:27 |
Message-ID: | 133491a8ecc2456084e7050830d93202@G08CNEXMBPEKD05.g08.fujitsu.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I try to make some special query plan like the following.
I have tried a lot SQL, but failed.
Can Initplan placed at the righttree or the lefttree of joinnode?
(Fake) QUERY PLAN
-------------------------------------------------------------------
Hash Join (cost=13.15..26.48 rows=140 width=8)
Hash Cond: (test1.a = test.a)
-> Seq Scan on test1 (cost=0.00..11.40 rows=140 width=4)
-> Hash (cost=11.40..11.40 rows=140 width=8)
-> InitPlan 1 (returns $0,$1)
Or
(Fake) QUERY PLAN
-------------------------------------------------------------------
Hash Join (cost=13.15..26.48 rows=140 width=8)
Hash Cond: (test1.a = test.a)
-> Seq Scan on test1 (cost=0.00..11.40 rows=140 width=4)
-> InitPlan 1 (returns $0,$1)
-> Hash (cost=11.40..11.40 rows=140 width=8)
Best regards
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2020-10-22 12:17:55 | Re: Initplan placed at the righttree or the lefttree of joinnode |
Previous Message | Andreas Joseph Krogh | 2020-10-22 09:04:47 | Re: Hot backup in PostgreSQL |