Re: Query Plan Columns

On 11/05/2010 04:27 PM, David E. Wheeler wrote:
> Fellow Hackers,
>
> I'm writing a function to turn an EXPLAIN plan into a table with columns. As such, I need to have a complete list of the various bits of each plan node and their types for the table. Here's what I've got so far:
>
>      "Node Type"           TEXT,
>      "Strategy"            TEXT,
>      "Startup Cost"        NUMERIC,
>      "Total Cost"          NUMERIC,
>      "Plan Rows"           INTEGER,
>      "Plan Width"          INTEGER,
>      "Actual Startup Time" NUMERIC,
>      "Actual Total Time"   NUMERIC,
>      "Actual Rows"         INTEGER,
>      "Actual Width"        INTEGER,
>      "Actual Loops"        INTEGER,
>      "Parent Relationship" TEXT
>      "Sort Key"            TEXT[],
>      "Sort Method"         TEXT,
>      "Sort-Space-Used"     TEXT,
>      "Sort-Space-Type"     TEXT,
>      "Join Type"           TEXT,
>      "Join Filter"         TEXT,
>      "Hash Cond"           TEXT,
>      "Relation Name"       NAME,
>      "Alias"               NAME,
>      "Scan Direction"      TEXT,
>      "Index Name"          NAME,
>      "Index Cond"          TEXT,
>      "Subplan Name"        TEXT,
>      "Function Name"       TEXT,
>      "Filter"              TEXT
>
> Questions:
>
> * Am I missing any?
> * Are the data types correct?
> * Is there some place in the source with a canonical list?


src/backend/commands/explain.c

Of course, there are containers too, which are not in your list at all. 
How do you intend to represent the tree-ish structure in a flat table?

cheers

andrew