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 по дате отправления: