Query Plan Columns

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема Query Plan Columns
Дата
Msg-id 16A15982-8FCD-4BA1-8BD7-C94D4C1A0282@kineticode.com
обсуждение исходный текст
Ответы Re: Query Plan Columns
Re: Query Plan Columns
Список 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 по дате отправления: