From: | "David E(dot) Wheeler" <david(at)kineticode(dot)com> |
---|---|
To: | "pgsql-hackers(at)postgresql(dot)org Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Explain Nodes |
Date: | 2011-04-28 21:49:36 |
Message-ID: | 4E5B0DD3-9724-4ECC-B381-A57046C85C88@kineticode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hackers,
For my [explanation extension](http://pgxn.org/extension/explanation) I wanted to put together a list of node types, since I'm always having to figure them out to decide which nodes I'm interested in. Reading src/backend/commands/explain.c I assembled this list:
+ Aggregate
+ Append
+ Bitmap Heap Scan
+ Bitmap Index Scan
+ BitmapAnd
+ BitmapOr
+ CTE Scan
+ Foreign Scan
+ Function Scan
+ Group
+ Hash
+ Hash Join
+ Index Scan
+ Limit
+ LockRows
+ Materialize
+ Merge Append
+ Merge Join
+ ModifyTable
+ Nested Loop
+ Recursive Union
+ Result
+ Seq Scan
+ SetOp
+ Sort
+ Subquery Scan
+ Tid Scan
+ Unique
+ Values Scan
+ WindowAgg
+ WorkTable Scan
Is that accurate? I was looking at how `sname` was set, but maybe it can be set other ways?
Should a list like this be added to the EXPLAIN docs?
Thanks,
David
From | Date | Subject | |
---|---|---|---|
Next Message | Noah Misch | 2011-04-28 21:54:06 | Re: SQLERRD and dump of variables |
Previous Message | Alexander Korotkov | 2011-04-28 21:41:40 | Re: Extreme bloating of intarray GiST indexes |