Re: debugging tools inside postgres

On 24 June 2011 23:21, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Shigeru Hanada <shigeru(dot)hanada(at)gmail(dot)com> writes:
> > (2011/06/24 15:35), HuangQi wrote:
> >> I'm trying to debug a modification for the query planner. But I found it
> >> seems the data structure of my planned query is incorrect. I was trying
> to
> >> print out the data structure by use the "p" command in gdb which is
> quite
> >> inconvenient and takes time. May I know is there any embedded function
> in
> >> postgres to print out the node data structures, or any other plan
> related
> >> data structures? Thanks.
>
> > I think nodeToString() would help.
>
> For interactive use in gdb, I generally do
>
> call pprint(..node pointer..)
>
> which prints to the postmaster log.
>
> regards, tom lane
>

Thanks, Tom, this call pprint() works very nice.
--
Best Regards
Huang Qi Victor