aboutsummaryrefslogtreecommitdiff
path: root/src/backend/nodes/plannodes.h
blob: a01a93c7749b7af5b6c6daf56c06d5463a86e608 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
/*-------------------------------------------------------------------------
 *
 * plannodes.h--
 *    definitions for query plan nodes
 *
 *
 * Copyright (c) 1994, Regents of the University of California
 *
 * $Id: plannodes.h,v 1.1.1.1 1996/07/09 06:21:33 scrappy Exp $
 *
 *-------------------------------------------------------------------------
 */
#ifndef PLANNODES_H
#define	PLANNODES_H

#include "postgres.h"

#include "nodes/nodes.h"
#include "nodes/pg_list.h"
#include "nodes/primnodes.h"

/* ----------------------------------------------------------------
 *  Executor State types are used in the plannode structures
 *  so we have to include their definitions too.
 *
 *	Node Type		node information used by executor
 *
 * control nodes
 *
 *	Existential		ExistentialState	exstate;
 *	Result			ResultState		resstate;
 *	Append			AppendState		unionstate;
 *
 * scan nodes
 *
 *    	Scan ***		CommonScanState		scanstate;
 *    	IndexScan		IndexScanState		indxstate;
 *
 *	  (*** nodes which inherit Scan also inherit scanstate)
 *
 * join nodes
 *
 *	NestLoop		NestLoopState		nlstate;
 *	MergeJoin		MergeJoinState		mergestate;
 *	HashJoin		HashJoinState		hashjoinstate;
 *
 * materialize nodes
 *
 *	Material		MaterialState		matstate;
 *      Sort			SortState		sortstate;
 *      Unique			UniqueState		uniquestate;
 *      Hash			HashState		hashstate;
 *
 * ----------------------------------------------------------------
 */
#include "nodes/execnodes.h"		/* XXX move executor types elsewhere */


/* ----------------------------------------------------------------
 *			node definitions
 * ----------------------------------------------------------------
 */

/* ----------------
 *	Plan node
 * ----------------
 */

typedef struct Plan {
    NodeTag		type;
    Cost		cost;
    int			plan_size;
    int			plan_width;
    int			plan_tupperpage;
    EState		*state;  /* at execution time, state's of individual
				    nodes point to one EState for the 
				    whole top-level plan */
    List		*targetlist;
    List		*qual;	/* Node* or List* ?? */
    struct Plan		*lefttree;
    struct Plan		*righttree;
} Plan;

/* ----------------
 *  these are are defined to avoid confusion problems with "left"
 *  and "right" and "inner" and "outer".  The convention is that
 *  the "left" plan is the "outer" plan and the "right" plan is
 *  the inner plan, but these make the code more readable. 
 * ----------------
 */
#define innerPlan(node)		(((Plan *)(node))->righttree)
#define outerPlan(node)		(((Plan *)(node))->lefttree)


/*
 * ===============
 * Top-level nodes
 * ===============
 */

/* all plan nodes "derive" from the Plan structure by having the
   Plan structure as the first field.  This ensures that everything works
   when nodes are cast to Plan's.  (node pointers are frequently cast to Plan*
   when passed around generically in the executor */


/* ----------------
 *	existential node
 * ----------------
 */
typedef Plan	Existential;

/* ----------------
 *   result node -
 *      returns tuples from outer plan that satisfy the qualifications
 * ----------------
 */
typedef struct Result {
    Plan		plan;
    Node		*resconstantqual;
    ResultState		*resstate;
} Result;

/* ----------------
 *	append node
 * ----------------
 */
typedef struct Append {
    Plan		plan;
    List		*unionplans;
    Index		unionrelid;
    List		*unionrtentries;
    AppendState		*unionstate;
} Append;

/*
 * ==========
 * Scan nodes
 * ==========
 */
typedef struct Scan {
    Plan		plan;
    Index		scanrelid; /* relid is index into the range table */
    CommonScanState	*scanstate;
} Scan;

/* ----------------
 *	sequential scan node
 * ----------------
 */
typedef Scan	SeqScan;

/* ----------------
 *	index scan node
 * ----------------
 */
typedef struct IndexScan {
    Scan		scan;
    List		*indxid;
    List		*indxqual;
    IndexScanState	*indxstate;
} IndexScan;

/*
 * ==========
 * Join nodes
 * ==========
 */

/* ----------------
 *	Join node
 * ----------------
 */
typedef	Plan	Join;

/* ----------------
 *	nest loop join node
 * ----------------
 */
typedef struct NestLoop {
    Join		join;
    NestLoopState	*nlstate;
} NestLoop;

/* ----------------
 *	merge join node
 * ----------------
 */
typedef struct MergeJoin {
    Join		join;
    List		*mergeclauses;
    Oid			mergesortop;
    Oid			*mergerightorder;	/* inner sort operator */
    Oid			*mergeleftorder;	/* outer sort operator */
    MergeJoinState	*mergestate;
} MergeJoin;

/* ----------------
 *	hash join (probe) node
 * ----------------
 */
typedef struct HashJoin {
    Join		join;
    List		*hashclauses;
    Oid			hashjoinop;
    HashJoinState	*hashjoinstate;
    HashJoinTable	hashjointable;
    IpcMemoryKey	hashjointablekey;
    int			hashjointablesize;
    bool		hashdone;
} HashJoin;

/* ---------------
 *      aggregate node
 * ---------------
 */
typedef struct Agg {
    Plan		plan;
    int			numAgg;
    Aggreg		**aggs;
    AggState            *aggstate;
} Agg;

/* ---------------
 *   group node -
 *      use for queries with GROUP BY specified.
 *
 *      If tuplePerGroup is true, one tuple (with group columns only) is
 *      returned for each group and NULL is returned when there are no more
 *      groups. Otherwise, all the tuples of a group are returned with a
 *	NULL returned at the end of each group. (see nodeGroup.c for details)
 * ---------------
 */
typedef struct Group {
    Plan		plan;
    bool		tuplePerGroup;	/* what tuples to return (see above) */
    int			numCols;	/* number of group columns */
    AttrNumber		*grpColIdx;	/* index into the target list */
    GroupState		*grpstate;
} Group;

/*
 * ==========
 * Temp nodes
 * ==========
 */
typedef struct Temp {
    Plan		plan;
    Oid			tempid;
    int			keycount;
} Temp;

/* ----------------
 *	materialization node
 * ----------------
 */
typedef struct Material {
    Plan		plan;		/* temp node flattened out */
    Oid			tempid;
    int			keycount;
    MaterialState	*matstate;
} Material;

/* ----------------
 *	sort node
 * ----------------
 */
typedef struct Sort {
    Plan		plan;		/* temp node flattened out */
    Oid			tempid;
    int			keycount;
    SortState		*sortstate;
} Sort;

/* ----------------
 *	unique node
 * ----------------
 */
typedef struct Unique {
    Plan		plan;		/* temp node flattened out */
    Oid			tempid;
    int			keycount;
    char               *uniqueAttr; /* NULL if all attrs,
				       or unique attribute name */
    AttrNumber     	uniqueAttrNum; /* attribute number of attribute
					   to select distinct on */
    UniqueState		*uniquestate;
} Unique;

/* ----------------
 *	hash build node
 * ----------------
 */
typedef struct Hash {
    Plan		plan;
    Var			*hashkey;
    HashState		*hashstate;
    HashJoinTable	hashtable;
    IpcMemoryKey	hashtablekey;
    int			hashtablesize;
} Hash;

/* ---------------------
 *	choose node
 * ---------------------
 */
typedef struct Choose {
    Plan	plan;
    List	*chooseplanlist;
} Choose;

/* -------------------
 *      Tee node information
 *
 *    leftParent :              the left parent of this node
 *    rightParent:              the right parent of this node  
 * -------------------
*/
typedef struct Tee {
  Plan           plan;
  Plan*          leftParent;
  Plan*          rightParent;
  TeeState       *teestate;
  char           *teeTableName; /* the name of the table to materialize
				  the tee into */
  List           *rtentries; /* the range table for the plan below the Tee
				may be different than the parent plans */
} Tee;

#endif /* PLANNODES_H */