Re: debugging tools inside postgres - Mailing list pgsql-hackers

From HuangQi
Subject Re: debugging tools inside postgres
Date
Msg-id BANLkTi=Gj9c2BU62usG5G8sv9tNqxvuSvw@mail.gmail.com
Whole thread Raw
In response to Re: debugging tools inside postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 24 June 2011 23:21, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Shigeru Hanada <shigeru.hanada@gmail.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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: debugging tools inside postgres
Next
From: Robert Haas
Date:
Subject: Re: Re: starting to review the Extend NOT NULL representation to pg_constraint patch