Skip site navigation (1) Skip section navigation (2)

Explain Nodes

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 (view raw or flat)
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


Responses

pgsql-hackers by date

Next:From: Noah MischDate: 2011-04-28 21:54:06
Subject: Re: SQLERRD and dump of variables
Previous:From: Alexander KorotkovDate: 2011-04-28 21:41:40
Subject: Re: Extreme bloating of intarray GiST indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group