Postgres Pro
Downloads
Home   >   mailing lists

Re: How to get the selectStatement parse tree info? - Mailing list pgsql-general

From Julien Rouhaud
Subject Re: How to get the selectStatement parse tree info?
Date
Msg-id 20221025055852.aghny3huir6lt7xy@jrouhaud
Whole thread Raw
In response to How to get the selectStatement parse tree info?  ("jacktby@gmail.com" <jacktby@gmail.com>)
List pgsql-general
Tree view 
Hi,

On Tue, Oct 25, 2022 at 01:38:09PM +0800, jacktby@gmail.com wrote:
> I'm reading this book https://www.interdb.jp/pg/pgsql03.html? I'm debugging
> pg, but I can't get the parse tree like this:
> https://files.slack.com/files-pri/T0FS7GCKS-F047H5R2UKH/1.png, can you give
> me some ways to get that? I'm using vscode to debug, the watch info doesn't
> interest me, it gives me
> nothing,https://files.slack.com/files-pri/T0FS7GCKS-F048MD5BTME/quzk_6bk0sug60__f_0wh2l.png

I can't access the pictures, so I'm not sure what exactly you expect (and you
should usually prefer sending text anyway), but maybe what you want is "SET
debug_print_parse = on" to print the parse trees in the logs?

pgsql-general by date:

Previous
From: "jacktby@gmail.com"
Date:
Subject: How to get the selectStatement parse tree info?
Next
From: Yi Sun
Date:
Subject: How to know how much CPU, RAM is used by existing 1 database