"sabrina lal" <sabrina_lal2300@hotmail.com> writes:
> I found out that the debug levels and EXPLAIN command lets you know the
> selection made at each step of the query execution. I wanted to know if
> there was or there can be a way to find out what query paths are considered
> while forming the query execution plan.
Compiling with -DOPTIMIZER_DEBUG provides some visibility into the
process, but I'd be the first to say we could use more. Please feel
free to propose mechanisms for improving this.
regards, tom lane
PS: please use a relevant Subject: line in future pghackers postings.