Re: debug_print_plan logs table alias used in join, not table name itself

On Wed, Jan 19, 2011 at 7:10 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> frank joerdens <fiskadoro(at)gmail(dot)com> writes:
>> I was just experimenting with debug logging on 8.3 and am finding that
>> I can't get it to log the table names involved in a given query, it
>> will always print the table alias used in your join instead, e.g.
>
> I don't know why you think that debug_print_plan is meant to do any such
> thing; it isn't meant to be useful to end users at all.  You could get
> the table identity from the relation OID that's in the plan tree, but
> the name is not there.

Oh, that's great - the OID will do just fine (missed that it was there). Thanks!

Regards,

Frank