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

From Tom Lane
Subject Re: debugging tools inside postgres
Date
Msg-id 26054.1308928913@sss.pgh.pa.us
Whole thread Raw
In response to Re: debugging tools inside postgres  (Shigeru Hanada <shigeru.hanada@gmail.com>)
Responses Re: debugging tools inside postgres
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Re: starting to review the Extend NOT NULL representation to pg_constraint patch
Next
From: HuangQi
Date:
Subject: Re: debugging tools inside postgres