| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Shigeru Hanada <shigeru(dot)hanada(at)gmail(dot)com> |
| Cc: | HuangQi <huangqiyx(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: debugging tools inside postgres |
| Date: | 2011-06-24 15:21:53 |
| Message-ID: | 26054.1308928913@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | HuangQi | 2011-06-24 15:27:52 | Re: debugging tools inside postgres |
| Previous Message | Alvaro Herrera | 2011-06-24 15:17:19 | Re: Re: starting to review the Extend NOT NULL representation to pg_constraint patch |