Easily reading debug_print_plan - Mailing list pgsql-hackers

From Craig Ringer
Subject Easily reading debug_print_plan
Date
Msg-id 528C6EF3.3020808@2ndquadrant.com
Whole thread Raw
Responses Re: Easily reading debug_print_plan  (Antonin Houska <antonin.houska@gmail.com>)
Re: Easily reading debug_print_plan  (Craig Ringer <craig@2ndquadrant.com>)
Re: Easily reading debug_print_plan  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi all

I'm spending a lot of time staring at parse and plan trees at the
moment, and I'm finding reading them rather cumbersome.

For those of you who do this a lot, do you use any sort of tooling to
help you out? Just being able to collapse and expand subtrees would be a
lifesaver.

If it's a hassle for others too, how would you feel about using json as
an output format in future releases? It'd be pretty simple to retrofit
by the looks, though updating the regression tests would be a PITA. My
main concern would be effects on back-patching.

If the conensus opinion on that is "hell no" or if it's a much bigger
job than I thought I'll just write a converter that ingests node trees
and spits out json I can view using existing tools.

-- Craig Ringer                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: CREATE TABLE IF NOT EXISTS AS
Next
From: Antonin Houska
Date:
Subject: Re: Easily reading debug_print_plan