On Wed, Jan 19, 2011 at 7:10 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > frank joerdens <fiskad...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general