Thread: Finding relfilenode

Finding relfilenode

From
Soroosh Sardari
Date:
Hi

In cost functions such as cost_seqscan, a RelOptinfo indicate a base relation.
But there  is no relfilenode in the RelOptinfo, So how could i find relfilenode or reloid of the relation?

Thanks,
Soroosh Sardari

Re: Finding relfilenode

From
Tom Lane
Date:
Soroosh Sardari <soroosh.sardari@gmail.com> writes:
> In cost functions such as cost_seqscan, a RelOptinfo indicate a base
> relation.
> But there  is no relfilenode in the RelOptinfo, So how could i find
> relfilenode or reloid of the relation?

You could get the table OID out of the associated RTE.  But I fail to
see what value the relfilenode would have at plan time.
        regards, tom lane