Query Plan Columns

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCH] Revert default wal_sync_method to fdatasync on Linux 2.6.33+
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ALTER TABLE ... IF EXISTS feature?