Re: analyzing debugging sentences.

On Wed, Oct 18, 2006 at 02:11:53PM -0400, jungmin shin wrote:
> Hello,
>
> I set on for following items in postgresql.conf
>
> debug_print_parse
> debug_print_rewritten
> debug_print_plan
> debug_print_pretty
>
> now, I can see something in PGAdmin query tool when I execute a query.
> can I get some idea how I can read comprehend the output?

<snip>

It's almost (with a few exceptions) an exact repesentation of the in
memory structures. If you look in readfuncs.c and outfuncs.c you can
see the code that generates it.

CONST is a ConstNode
OPEXPR is an OpExprNode

etc...

So you'll have to read the header files to understand what they mean.

Hope this helps,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.