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

2011-01-19 Thread frank joerdens
On Wed, Jan 19, 2011 at 7:10 PM, Tom Lane wrote: > frank joerdens 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

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

2011-01-19 Thread Tom Lane
frank joerdens 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

[GENERAL] debug_print_plan logs table alias used in join, not table name itself

2011-01-19 Thread frank joerdens
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. explaining a query such as woome=# explain select * from webapp_person p join auth_user a on