On Wed, Jan 19, 2011 at 7:10 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> frank joerdens <fiskadoro@gmail.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