From: | "David E(dot) Wheeler" <david(at)kineticode(dot)com> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Query Plan Columns |
Date: | 2010-11-05 20:27:21 |
Message-ID: | 16A15982-8FCD-4BA1-8BD7-C94D4C1A0282@kineticode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 the various 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 Total Time" 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,
"Hash Cond" TEXT,
"Relation Name" NAME,
"Alias" NAME,
"Scan Direction" TEXT,
"Index Name" 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-11-05 20:31:47 | Re: ALTER TABLE ... IF EXISTS feature? |
Previous Message | Tom Lane | 2010-11-05 20:16:40 | Re: [PATCH] Revert default wal_sync_method to fdatasync on Linux 2.6.33+ |