[HACKERS] How does postgres store the join predicate for a relation in a given query - Mailing list pgsql-hackers

From Gourav Kumar
Subject [HACKERS] How does postgres store the join predicate for a relation in a given query
Date
Msg-id CAPzqDmhQN3cOZns1foyaQaKap3Xt4RoSXr+8CS--u5o1M43Yxw@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] How does postgres store the join predicate for arelation in a given query
Re: [HACKERS] How does postgres store the join predicate for arelation in a given query
List 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

pgsql-hackers by date:

Previous
From: Petr Jelinek
Date:
Subject: [HACKERS] Re: [BUGS] 10.0: Logical replication doesn't execute BEFORE UPDATE OF trigger
Next
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] [COMMITTERS] pgsql: Fix freezing of a dead HOT-updatedtuple