Query Plan Columns - Mailing list pgsql-hackers

From David E. Wheeler
Subject Query Plan Columns
Date
Msg-id 16A15982-8FCD-4BA1-8BD7-C94D4C1A0282@kineticode.com
Whole thread Raw
Responses Re: Query Plan Columns
Re: Query Plan Columns
List pgsql-hackers
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
thevarious 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
TotalTime"   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,
"HashCond"           TEXT,   "Relation Name"       NAME,   "Alias"               NAME,   "Scan Direction"      TEXT,
"IndexName"          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?

Thanks,

David



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCH] Revert default wal_sync_method to fdatasync on Linux 2.6.33+
Next
From: Tom Lane
Date:
Subject: Re: ALTER TABLE ... IF EXISTS feature?