| From: | Gourav Kumar <gourav1905(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | How does postgres store the join predicate for a relation in a given query |
| Date: | 2017-10-10 13:59:24 |
| Message-ID: | CAPzqDmhQN3cOZns1foyaQaKap3Xt4RoSXr+8CS--u5o1M43Yxw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi all,
When you fire a query in postgresql, it will first parse the query and
create the data structures for storing various aspects of the query and
executing the query. (Like RangeTblEntry, PlannerInfo, RangeOptInfo etc.).
I want to know how does postgresql stores the join predicates of a query.
Like which data structure is used to store the join predicates.
How can we find the join predicates applied on a relation from relid, Oid
or RangeTblEntry ?
I want to construct a join graph for a given query, for which I need the
join predicates between two relations.
--
Thanks,
Gourav Kumar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2017-10-10 14:14:44 | Re: [COMMITTERS] pgsql: Fix freezing of a dead HOT-updated tuple |
| Previous Message | Petr Jelinek | 2017-10-10 13:25:14 | Re: 10.0: Logical replication doesn't execute BEFORE UPDATE OF <columns> trigger |