[HACKERS] Ideas of printing out the alternative paths

2013-11-14 Thread Zhan Li
When searching all the possible paths of executing a query, the optimizer finds and saves the cheapest paths for the top level rel. I'd like to check out all the paths the optimizer has ever considered, which I believe, are stored in the pathlist of the top level rel. But I do not have an idea of

Re: [HACKERS] Ideas of printing out the alternative paths

2013-11-14 Thread Tom Lane
Zhan Li zhanl...@gmail.com writes: When searching all the possible paths of executing a query, the optimizer finds and saves the cheapest paths for the top level rel. I'd like to check out all the paths the optimizer has ever considered, which I believe, are stored in the pathlist of the top

Re: [HACKERS] Ideas of printing out the alternative paths

2013-11-14 Thread Zhan Li
Thank you for your reply Tom. Then a) what are exactly stored in the pathlist of top level rel? Paths worth considering? b) I have been struggling to come up with a way to print the Path struct. If I can print a path the way like A hash join (B nested loop join C), that would be great. You

Re: [HACKERS] Ideas of printing out the alternative paths

2013-11-14 Thread Tom Lane
Zhan Li zhanl...@gmail.com writes: Thank you for your reply Tom. Then a) what are exactly stored in the pathlist of top level rel? Paths worth considering? b) I have been struggling to come up with a way to print the Path struct. If I can print a path the way like A hash join (B nested loop