Query Plan Columns

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

Responses

Browse pgsql-hackers by date

  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+