I need some help understanding what the difference is between the following debug_print parameters. I have tried them all and they all seem to give me the same output (looks like an explain verbose). Anyway, I am really wanted to just have the db print a simple explain to the log for each query so we can see where problems may be in some new code we are developing. Is there a way to do this? I really don't want the verbose output since I'm not very comfortable figuring out what it is telling me.



Parameters:

debug_print_parse

debug_print_rewritten

debug_print_plan

Thanks for any explanation on these.

Chris

postgresql-7.3.4


---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Reply via email to