Skip site navigation (1) Skip section navigation (2)

Re: Add YAML option to explain

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-hackers(at)postgresql(dot)org>, "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
Subject: Re: Add YAML option to explain
Date: 2009-08-31 16:57:16
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
"Greg Sabino Mullane" <greg(at)turnstep(dot)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.

In response to

pgsql-hackers by date

Next:From: Kevin GrittnerDate: 2009-08-31 17:07:34
Subject: Re: Linux LSB init script
Previous:From: Tom LaneDate: 2009-08-31 16:34:09
Subject: Re: autovacuum launcher using InitPostgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group