Re: Add YAML option to explain - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Add YAML option to explain
Date
Msg-id 4A9BBA9C020000250002A637@gw.wicourts.gov
Whole thread Raw
In response to Re: Add YAML option to explain  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-hackers
"Greg Sabino Mullane" <greg@turnstep.com> wrote:
>  -
>    Plan:
>      Node Type: Index Scan
>      Scan Direction: Forward
>      Index Name: pg_class_relname_nsp_index
>      Relation Name: pg_class
>      Alias: pg_class
>      Startup Cost: 0.00
>      Total Cost: 8.27
>      Plan Rows: 1
>      Plan Width: 0
>      Actual Startup Time: 0.019
>      Actual Total Time: 0.019
>      Actual Rows: 0
>      Actual Loops: 1
>      Index Cond: "(relname = 'foo\"bar\"'::name)"
>    Triggers:
>    Total Runtime: 0.058
+1 for including this format.  On a ten point scale for human
readability, I'd give this about a nine.  It's something I'd be
comfortable generating in order to annotate and include in an email to
programmers or managers who wouldn't have a clue how to read the
current text version of a plan.
-Kevin


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: autovacuum launcher using InitPostgres
Next
From: "Kevin Grittner"
Date:
Subject: Re: Linux LSB init script