On Wed, Jan 19, 2011 at 7:10 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > frank joerdens <fiskadoro@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
