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