4 * routines to convert a node to ascii representation
6 * Copyright (c) 1994, Regents of the University of California
8 * $Id: outfuncs.c,v 1.96 1999/10/03 23:55:29 tgl Exp $
11 * Every (plan) node in POSTGRES has an associated "out" routine which
12 * knows how to create its ascii representation. These functions are
13 * useful for debugging as well as for storing plans in the system
14 * catalogs (eg. indexes). This is also the plan string sent out in
17 * These functions update the in/out argument of type StringInfo
18 * passed to them. This argument contains the string holding the ASCII
19 * representation plus some other information (string length, etc.)
24 #include "access/heapam.h"
25 #include "access/htup.h"
26 #include "catalog/pg_type.h"
28 #include "lib/stringinfo.h"
29 #include "nodes/execnodes.h"
30 #include "nodes/nodes.h"
31 #include "nodes/parsenodes.h"
32 #include "nodes/pg_list.h"
33 #include "nodes/plannodes.h"
34 #include "nodes/primnodes.h"
35 #include "nodes/relation.h"
36 #include "utils/datum.h"
37 #include "utils/lsyscache.h"
38 #include "utils/syscache.h"
42 static void _outDatum(StringInfo str, Datum value, Oid type);
43 static void _outNode(StringInfo str, void *obj);
45 /* Convert a null string pointer into "<>" */
46 #define stringStringInfo(s) (((s) == NULL) ? "<>" : (s))
51 * converts a List of integers
54 _outIntList(StringInfo str, List *list)
58 appendStringInfo(str, "(");
60 appendStringInfo(str, " %d ", lfirsti(l));
61 appendStringInfo(str, ")");
65 _outCreateStmt(StringInfo str, CreateStmt *node)
67 appendStringInfo(str, " CREATE :relname %s ",
68 stringStringInfo(node->relname));
70 appendStringInfo(str, " :istemp %s ",
71 node->istemp ? "true" : "false");
73 appendStringInfo(str, " :columns ");
74 _outNode(str, node->tableElts);
76 appendStringInfo(str, " :inhRelnames ");
77 _outNode(str, node->inhRelnames);
79 appendStringInfo(str, " :constraints ");
80 _outNode(str, node->constraints);
84 _outIndexStmt(StringInfo str, IndexStmt *node)
87 " INDEX :idxname %s :relname %s :accessMethod %s :indexParams ",
88 stringStringInfo(node->idxname),
89 stringStringInfo(node->relname),
90 stringStringInfo(node->accessMethod));
91 _outNode(str, node->indexParams);
93 appendStringInfo(str, " :withClause ");
94 _outNode(str, node->withClause);
96 appendStringInfo(str, " :whereClause ");
97 _outNode(str, node->whereClause);
99 appendStringInfo(str, " :rangetable ");
100 _outNode(str, node->rangetable);
102 appendStringInfo(str, " :lossy %s :unique %s ",
103 node->lossy ? "true" : "false",
104 node->unique ? "true" : "false");
108 _outSelectStmt(StringInfo str, SelectStmt *node)
110 appendStringInfo(str, "SELECT :where ");
111 _outNode(str, node->whereClause);
115 _outFuncCall(StringInfo str, FuncCall *node)
117 appendStringInfo(str, "FUNCTION %s :args ", stringStringInfo(node->funcname));
118 _outNode(str, node->args);
122 _outColumnDef(StringInfo str, ColumnDef *node)
124 appendStringInfo(str, " COLUMNDEF :colname %s :typename ",
125 stringStringInfo(node->colname));
126 _outNode(str, node->typename);
127 appendStringInfo(str, " :is_not_null %s :is_sequence %s :raw_default ",
128 node->is_not_null ? "true" : "false",
129 node->is_sequence ? "true" : "false");
130 _outNode(str, node->raw_default);
131 appendStringInfo(str, " :cooked_default %s :constraints ",
132 stringStringInfo(node->cooked_default));
133 _outNode(str, node->constraints);
137 _outTypeName(StringInfo str, TypeName *node)
139 appendStringInfo(str,
140 " TYPENAME :name %s :timezone %s :setof %s typmod %d :arrayBounds ",
141 stringStringInfo(node->name),
142 node->timezone ? "true" : "false",
143 node->setof ? "true" : "false",
146 appendStringInfo(str, " :arrayBounds ");
147 _outNode(str, node->arrayBounds);
151 _outIndexElem(StringInfo str, IndexElem *node)
153 appendStringInfo(str, " INDEXELEM :name %s :args ",
154 stringStringInfo(node->name));
155 _outNode(str, node->args);
157 appendStringInfo(str, " :class %s :typename ", stringStringInfo(node->class));
158 _outNode(str, node->typename);
162 _outQuery(StringInfo str, Query *node)
165 appendStringInfo(str, " QUERY :command %d ", node->commandType);
167 if (node->utilityStmt)
169 switch (nodeTag(node->utilityStmt))
172 appendStringInfo(str, " :create %s ",
173 stringStringInfo(((CreateStmt *) (node->utilityStmt))->relname));
174 _outNode(str, node->utilityStmt);
178 appendStringInfo(str, " :index %s on %s ",
179 stringStringInfo(((IndexStmt *) (node->utilityStmt))->idxname),
180 stringStringInfo(((IndexStmt *) (node->utilityStmt))->relname));
181 _outNode(str, node->utilityStmt);
185 appendStringInfo(str, " :utility %s ",
186 stringStringInfo(((NotifyStmt *) (node->utilityStmt))->relname));
190 appendStringInfo(str, " :utility ? ");
194 appendStringInfo(str, " :utility <>");
196 appendStringInfo(str,
197 " :resultRelation %u :into %s :isPortal %s :isBinary %s :isTemp %s :unionall %s ",
198 node->resultRelation,
199 stringStringInfo(node->into),
200 node->isPortal ? "true" : "false",
201 node->isBinary ? "true" : "false",
202 node->isTemp ? "true" : "false",
203 node->unionall ? "true" : "false");
205 appendStringInfo(str, " :unique %s :sortClause ",
206 stringStringInfo(node->uniqueFlag));
207 _outNode(str, node->sortClause);
209 appendStringInfo(str, " :rtable ");
210 _outNode(str, node->rtable);
212 appendStringInfo(str, " :targetlist ");
213 _outNode(str, node->targetList);
215 appendStringInfo(str, " :qual ");
216 _outNode(str, node->qual);
218 appendStringInfo(str, " :groupClause ");
219 _outNode(str, node->groupClause);
221 appendStringInfo(str, " :havingQual ");
222 _outNode(str, node->havingQual);
224 appendStringInfo(str, " :hasAggs %s :hasSubLinks %s :unionClause ",
225 node->hasAggs ? "true" : "false",
226 node->hasSubLinks ? "true" : "false");
227 _outNode(str, node->unionClause);
229 appendStringInfo(str, " :intersectClause ");
230 _outNode(str, node->intersectClause);
232 appendStringInfo(str, " :limitOffset ");
233 _outNode(str, node->limitOffset);
235 appendStringInfo(str, " :limitCount ");
236 _outNode(str, node->limitCount);
238 appendStringInfo(str, " :rowMark ");
239 _outNode(str, node->rowMark);
244 _outSortClause(StringInfo str, SortClause *node)
246 appendStringInfo(str, " SORTCLAUSE :tleSortGroupRef %d :sortop %u ",
247 node->tleSortGroupRef, node->sortop);
251 _outGroupClause(StringInfo str, GroupClause *node)
253 appendStringInfo(str, " GROUPCLAUSE :tleSortGroupRef %d :sortop %u ",
254 node->tleSortGroupRef, node->sortop);
258 * print the basic stuff of all nodes that inherit from Plan
261 _outPlanInfo(StringInfo str, Plan *node)
263 appendStringInfo(str,
264 ":cost %g :size %d :width %d :state %s :qptargetlist ",
268 node->state ? "not-NULL" : "<>");
269 _outNode(str, node->targetlist);
271 appendStringInfo(str, " :qpqual ");
272 _outNode(str, node->qual);
274 appendStringInfo(str, " :lefttree ");
275 _outNode(str, node->lefttree);
277 appendStringInfo(str, " :righttree ");
278 _outNode(str, node->righttree);
280 appendStringInfo(str, " :extprm ");
281 _outIntList(str, node->extParam);
283 appendStringInfo(str, " :locprm ");
284 _outIntList(str, node->locParam);
286 appendStringInfo(str, " :initplan ");
287 _outNode(str, node->initPlan);
289 appendStringInfo(str, " :nprm %d ", node->nParamExec);
293 * Stuff from plannodes.h
296 _outPlan(StringInfo str, Plan *node)
298 appendStringInfo(str, " PLAN ");
299 _outPlanInfo(str, (Plan *) node);
303 _outResult(StringInfo str, Result *node)
305 appendStringInfo(str, " RESULT ");
306 _outPlanInfo(str, (Plan *) node);
308 appendStringInfo(str, " :resconstantqual ");
309 _outNode(str, node->resconstantqual);
314 * Append is a subclass of Plan.
317 _outAppend(StringInfo str, Append *node)
319 appendStringInfo(str, " APPEND ");
320 _outPlanInfo(str, (Plan *) node);
322 appendStringInfo(str, " :appendplans ");
323 _outNode(str, node->appendplans);
325 appendStringInfo(str, " :unionrtables ");
326 _outNode(str, node->unionrtables);
328 appendStringInfo(str,
329 " :inheritrelid %u :inheritrtable ",
331 _outNode(str, node->inheritrtable);
336 * Join is a subclass of Plan
339 _outJoin(StringInfo str, Join *node)
341 appendStringInfo(str, " JOIN ");
342 _outPlanInfo(str, (Plan *) node);
347 * NestLoop is a subclass of Join
350 _outNestLoop(StringInfo str, NestLoop *node)
352 appendStringInfo(str, " NESTLOOP ");
353 _outPlanInfo(str, (Plan *) node);
357 * MergeJoin is a subclass of Join
360 _outMergeJoin(StringInfo str, MergeJoin *node)
362 appendStringInfo(str, " MERGEJOIN ");
363 _outPlanInfo(str, (Plan *) node);
365 appendStringInfo(str, " :mergeclauses ");
366 _outNode(str, node->mergeclauses);
370 * HashJoin is a subclass of Join.
373 _outHashJoin(StringInfo str, HashJoin *node)
375 appendStringInfo(str, " HASHJOIN ");
376 _outPlanInfo(str, (Plan *) node);
378 appendStringInfo(str, " :hashclauses ");
379 _outNode(str, node->hashclauses);
381 appendStringInfo(str,
385 appendStringInfo(str,
391 _outSubPlan(StringInfo str, SubPlan *node)
393 appendStringInfo(str, " SUBPLAN :plan ");
394 _outNode(str, node->plan);
396 appendStringInfo(str, " :planid %u :rtable ", node->plan_id);
397 _outNode(str, node->rtable);
399 appendStringInfo(str, " :setprm ");
400 _outIntList(str, node->setParam);
402 appendStringInfo(str, " :parprm ");
403 _outIntList(str, node->parParam);
405 appendStringInfo(str, " :slink ");
406 _outNode(str, node->sublink);
410 * Scan is a subclass of Node
413 _outScan(StringInfo str, Scan *node)
415 appendStringInfo(str, " SCAN ");
416 _outPlanInfo(str, (Plan *) node);
418 appendStringInfo(str, " :scanrelid %u ", node->scanrelid);
422 * SeqScan is a subclass of Scan
425 _outSeqScan(StringInfo str, SeqScan *node)
427 appendStringInfo(str, " SEQSCAN ");
428 _outPlanInfo(str, (Plan *) node);
430 appendStringInfo(str, " :scanrelid %u ", node->scanrelid);
434 * IndexScan is a subclass of Scan
437 _outIndexScan(StringInfo str, IndexScan *node)
439 appendStringInfo(str, " INDEXSCAN ");
440 _outPlanInfo(str, (Plan *) node);
442 appendStringInfo(str, " :scanrelid %u :indxid ", node->scan.scanrelid);
443 _outIntList(str, node->indxid);
445 appendStringInfo(str, " :indxqual ");
446 _outNode(str, node->indxqual);
448 appendStringInfo(str, " :indxqualorig ");
449 _outNode(str, node->indxqualorig);
451 appendStringInfo(str, " :indxorderdir %d ", node->indxorderdir);
455 * Noname is a subclass of Plan
458 _outNoname(StringInfo str, Noname *node)
460 appendStringInfo(str, " NONAME ");
461 _outPlanInfo(str, (Plan *) node);
463 appendStringInfo(str, " :nonameid %u :keycount %d ",
469 * Sort is a subclass of Noname
472 _outSort(StringInfo str, Sort *node)
474 appendStringInfo(str, " SORT ");
475 _outPlanInfo(str, (Plan *) node);
477 appendStringInfo(str, " :nonameid %u :keycount %d ",
483 _outAgg(StringInfo str, Agg *node)
486 appendStringInfo(str, " AGG ");
487 _outPlanInfo(str, (Plan *) node);
491 _outGroup(StringInfo str, Group *node)
493 appendStringInfo(str, " GRP ");
494 _outPlanInfo(str, (Plan *) node);
496 /* the actual Group fields */
497 appendStringInfo(str, " :numCols %d :tuplePerGroup %s ",
499 node->tuplePerGroup ? "true" : "false");
503 * For some reason, unique is a subclass of Noname.
506 _outUnique(StringInfo str, Unique *node)
508 appendStringInfo(str, " UNIQUE ");
509 _outPlanInfo(str, (Plan *) node);
511 appendStringInfo(str, " :nonameid %u :keycount %d ",
518 * Hash is a subclass of Noname
521 _outHash(StringInfo str, Hash *node)
523 appendStringInfo(str, " HASH ");
524 _outPlanInfo(str, (Plan *) node);
526 appendStringInfo(str, " :hashkey ");
527 _outNode(str, node->hashkey);
530 /*****************************************************************************
532 * Stuff from primnodes.h.
534 *****************************************************************************/
537 * Resdom is a subclass of Node
540 _outResdom(StringInfo str, Resdom *node)
542 appendStringInfo(str, " RESDOM :resno %d :restype %u :restypmod %d",
547 appendStringInfo(str, " :resname \"%s\" :reskey %d :reskeyop %u",
548 stringStringInfo(node->resname),
552 appendStringInfo(str, " :ressortgroupref %d :resjunk %s ",
553 node->ressortgroupref,
554 node->resjunk ? "true" : "false");
558 _outFjoin(StringInfo str, Fjoin *node)
562 appendStringInfo(str, " FJOIN :initialized %s :nNodes %d ",
563 node->fj_initialized ? "true" : "false",
566 appendStringInfo(str, " :innerNode ");
567 _outNode(str, node->fj_innerNode);
569 appendStringInfo(str, " :results @ 0x%x :alwaysdone",
570 (int) node->fj_results);
572 for (i = 0; i < node->fj_nNodes; i++)
573 appendStringInfo(str, (node->fj_alwaysDone[i]) ? "true" : "false");
577 * Expr is a subclass of Node
580 _outExpr(StringInfo str, Expr *node)
584 appendStringInfo(str, " EXPR :typeOid %u ",
587 switch (node->opType)
608 appendStringInfo(str, " :opType %s :oper ", stringStringInfo(opstr));
609 _outNode(str, node->oper);
611 appendStringInfo(str, " :args ");
612 _outNode(str, node->args);
616 * Var is a subclass of Expr
619 _outVar(StringInfo str, Var *node)
621 appendStringInfo(str,
622 " VAR :varno %d :varattno %d :vartype %u :vartypmod %d ",
628 appendStringInfo(str, " :varlevelsup %u :varnoold %d :varoattno %d",
635 * Const is a subclass of Expr
638 _outConst(StringInfo str, Const *node)
640 appendStringInfo(str,
641 " CONST :consttype %u :constlen %d :constisnull %s :constvalue ",
644 node->constisnull ? "true" : "false");
646 if (node->constisnull)
647 appendStringInfo(str, "<>");
649 _outDatum(str, node->constvalue, node->consttype);
651 appendStringInfo(str, " :constbyval %s ",
652 node->constbyval ? "true" : "false");
659 _outAggref(StringInfo str, Aggref *node)
661 appendStringInfo(str,
662 " AGGREG :aggname %s :basetype %u :aggtype %u :target ",
663 stringStringInfo(node->aggname),
666 _outNode(str, node->target);
668 appendStringInfo(str, " :usenulls %s ",
669 node->usenulls ? "true" : "false");
676 _outSubLink(StringInfo str, SubLink *node)
678 appendStringInfo(str,
679 " SUBLINK :subLinkType %d :useor %s :lefthand ",
681 node->useor ? "true" : "false");
682 _outNode(str, node->lefthand);
684 appendStringInfo(str, " :oper ");
685 _outNode(str, node->oper);
687 appendStringInfo(str, " :subselect ");
688 _outNode(str, node->subselect);
692 * Array is a subclass of Expr
695 _outArray(StringInfo str, Array *node)
699 appendStringInfo(str,
700 " ARRAY :arrayelemtype %u :arrayelemlength %d :arrayelembyval %c ",
702 node->arrayelemlength,
703 node->arrayelembyval ? 't' : 'f');
705 appendStringInfo(str, " :arrayndim %d :arraylow ", node->arrayndim);
706 for (i = 0; i < node->arrayndim; i++)
707 appendStringInfo(str, " %d ", node->arraylow.indx[i]);
708 appendStringInfo(str, " :arrayhigh ");
709 for (i = 0; i < node->arrayndim; i++)
710 appendStringInfo(str, " %d ", node->arrayhigh.indx[i]);
711 appendStringInfo(str, " :arraylen %d ", node->arraylen);
715 * ArrayRef is a subclass of Expr
718 _outArrayRef(StringInfo str, ArrayRef *node)
720 appendStringInfo(str,
721 " ARRAYREF :refelemtype %u :refattrlength %d :refelemlength %d ",
724 node->refelemlength);
726 appendStringInfo(str, " :refelembyval %c :refupperindex ",
727 node->refelembyval ? 't' : 'f');
728 _outNode(str, node->refupperindexpr);
730 appendStringInfo(str, " :reflowerindex ");
731 _outNode(str, node->reflowerindexpr);
733 appendStringInfo(str, " :refexpr ");
734 _outNode(str, node->refexpr);
736 appendStringInfo(str, " :refassgnexpr ");
737 _outNode(str, node->refassgnexpr);
741 * Func is a subclass of Expr
744 _outFunc(StringInfo str, Func *node)
746 appendStringInfo(str,
747 " FUNC :funcid %u :functype %u :funcisindex %s :funcsize %d ",
750 node->funcisindex ? "true" : "false",
753 appendStringInfo(str, " :func_fcache @ 0x%x :func_tlist ",
754 (int) node->func_fcache);
755 _outNode(str, node->func_tlist);
757 appendStringInfo(str, " :func_planlist ");
758 _outNode(str, node->func_planlist);
762 * Oper is a subclass of Expr
765 _outOper(StringInfo str, Oper *node)
767 appendStringInfo(str,
768 " OPER :opno %u :opid %u :opresulttype %u ",
775 * Param is a subclass of Expr
778 _outParam(StringInfo str, Param *node)
780 appendStringInfo(str,
781 " PARAM :paramkind %d :paramid %d :paramname %s :paramtype %u ",
784 stringStringInfo(node->paramname),
787 appendStringInfo(str, " :param_tlist ");
788 _outNode(str, node->param_tlist);
792 * Stuff from execnodes.h
796 * EState is a subclass of Node.
799 _outEState(StringInfo str, EState *node)
801 appendStringInfo(str,
802 " ESTATE :direction %d :range_table ",
804 _outNode(str, node->es_range_table);
806 appendStringInfo(str, " :result_relation_info @ 0x%x ",
807 (int) (node->es_result_relation_info));
811 * Stuff from relation.h
814 _outRelOptInfo(StringInfo str, RelOptInfo *node)
816 appendStringInfo(str, " RELOPTINFO :relids ");
817 _outIntList(str, node->relids);
819 appendStringInfo(str,
820 " :indexed %s :pages %u :tuples %u :size %u :width %u :targetlist ",
821 node->indexed ? "true" : "false",
826 _outNode(str, node->targetlist);
828 appendStringInfo(str, " :pathlist ");
829 _outNode(str, node->pathlist);
832 * Not sure if these are nodes or not. They're declared as struct
833 * Path *. Since i don't know, i'll just print the addresses for now.
834 * This can be changed later, if necessary.
837 appendStringInfo(str,
838 " :cheapestpath @ 0x%x :pruneable %s :restrictinfo ",
839 (int) node->cheapestpath,
840 node->pruneable ? "true" : "false");
841 _outNode(str, node->restrictinfo);
843 appendStringInfo(str, " :joininfo ");
844 _outNode(str, node->joininfo);
846 appendStringInfo(str, " :innerjoin ");
847 _outNode(str, node->innerjoin);
851 * TargetEntry is a subclass of Node.
854 _outTargetEntry(StringInfo str, TargetEntry *node)
856 appendStringInfo(str, " TARGETENTRY :resdom ");
857 _outNode(str, node->resdom);
859 appendStringInfo(str, " :expr ");
860 _outNode(str, node->expr);
864 _outRangeTblEntry(StringInfo str, RangeTblEntry *node)
866 appendStringInfo(str,
867 " RTE :relname %s :refname %s :relid %u :inh %s :inFromCl %s :skipAcl %s",
868 stringStringInfo(node->relname),
869 stringStringInfo(node->refname),
871 node->inh ? "true" : "false",
872 node->inFromCl ? "true" : "false",
873 node->skipAcl ? "true" : "false");
877 _outRowMark(StringInfo str, RowMark *node)
879 appendStringInfo(str, " ROWMARK :rti %u :info %u", node->rti, node->info);
883 * Path is a subclass of Node.
886 _outPath(StringInfo str, Path *node)
888 appendStringInfo(str, " PATH :pathtype %d :cost %f :pathkeys ",
891 _outNode(str, node->pathkeys);
895 * IndexPath is a subclass of Path.
898 _outIndexPath(StringInfo str, IndexPath *node)
900 appendStringInfo(str,
901 " INDEXPATH :pathtype %d :cost %f :pathkeys ",
903 node->path.path_cost);
904 _outNode(str, node->path.pathkeys);
906 appendStringInfo(str, " :indexid ");
907 _outIntList(str, node->indexid);
909 appendStringInfo(str, " :indexqual ");
910 _outNode(str, node->indexqual);
912 appendStringInfo(str, " :joinrelids ");
913 _outIntList(str, node->joinrelids);
917 * NestPath is a subclass of Path
920 _outNestPath(StringInfo str, NestPath *node)
922 appendStringInfo(str,
923 " NESTPATH :pathtype %d :cost %f :pathkeys ",
925 node->path.path_cost);
926 _outNode(str, node->path.pathkeys);
928 appendStringInfo(str, " :pathinfo ");
929 _outNode(str, node->pathinfo);
932 * Not sure if these are nodes; they're declared as "struct path *".
933 * For now, i'll just print the addresses.
936 appendStringInfo(str,
937 " :outerjoinpath @ 0x%x :innerjoinpath @ 0x%x ",
938 (int) node->outerjoinpath,
939 (int) node->innerjoinpath);
943 * MergePath is a subclass of NestPath.
946 _outMergePath(StringInfo str, MergePath *node)
948 appendStringInfo(str,
949 " MERGEPATH :pathtype %d :cost %f :pathkeys ",
950 node->jpath.path.pathtype,
951 node->jpath.path.path_cost);
952 _outNode(str, node->jpath.path.pathkeys);
954 appendStringInfo(str, " :pathinfo ");
955 _outNode(str, node->jpath.pathinfo);
958 * Not sure if these are nodes; they're declared as "struct path *".
959 * For now, i'll just print the addresses.
962 appendStringInfo(str,
963 " :outerjoinpath @ 0x%x :innerjoinpath @ 0x%x ",
964 (int) node->jpath.outerjoinpath,
965 (int) node->jpath.innerjoinpath);
967 appendStringInfo(str, " :path_mergeclauses ");
968 _outNode(str, node->path_mergeclauses);
970 appendStringInfo(str, " :outersortkeys ");
971 _outNode(str, node->outersortkeys);
973 appendStringInfo(str, " :innersortkeys ");
974 _outNode(str, node->innersortkeys);
978 * HashPath is a subclass of NestPath.
981 _outHashPath(StringInfo str, HashPath *node)
983 appendStringInfo(str,
984 " HASHPATH :pathtype %d :cost %f :pathkeys ",
985 node->jpath.path.pathtype,
986 node->jpath.path.path_cost);
987 _outNode(str, node->jpath.path.pathkeys);
989 appendStringInfo(str, " :pathinfo ");
990 _outNode(str, node->jpath.pathinfo);
993 * Not sure if these are nodes; they're declared as "struct path *".
994 * For now, i'll just print the addresses.
997 appendStringInfo(str,
998 " :outerjoinpath @ 0x%x :innerjoinpath @ 0x%x ",
999 (int) node->jpath.outerjoinpath,
1000 (int) node->jpath.innerjoinpath);
1002 appendStringInfo(str, " :path_hashclauses ");
1003 _outNode(str, node->path_hashclauses);
1007 * PathKeyItem is a subclass of Node.
1010 _outPathKeyItem(StringInfo str, PathKeyItem *node)
1012 appendStringInfo(str, " PATHKEYITEM :sortop %u :key ",
1014 _outNode(str, node->key);
1018 * RestrictInfo is a subclass of Node.
1021 _outRestrictInfo(StringInfo str, RestrictInfo *node)
1023 appendStringInfo(str, " RESTRICTINFO :clause ");
1024 _outNode(str, node->clause);
1026 appendStringInfo(str,
1027 " :selectivity %f :subclauseindices ",
1029 _outNode(str, node->subclauseindices);
1031 appendStringInfo(str, " :mergejoinoperator %u ", node->mergejoinoperator);
1032 appendStringInfo(str, " :left_sortop %u ", node->left_sortop);
1033 appendStringInfo(str, " :right_sortop %u ", node->right_sortop);
1034 appendStringInfo(str, " :hashjoinoperator %u ", node->hashjoinoperator);
1038 * JoinInfo is a subclass of Node.
1041 _outJoinInfo(StringInfo str, JoinInfo *node)
1043 appendStringInfo(str, " JINFO :unjoined_relids ");
1044 _outIntList(str, node->unjoined_relids);
1046 appendStringInfo(str, " :jinfo_restrictinfo ");
1047 _outNode(str, node->jinfo_restrictinfo);
1051 * Print the value of a Datum given its type.
1054 _outDatum(StringInfo str, Datum value, Oid type)
1063 * find some information about the type and the "real" length of the
1066 byValue = get_typbyval(type);
1067 typeLength = get_typlen(type);
1068 length = datumGetSize(value, type, byValue, typeLength);
1072 s = (char *) (&value);
1073 appendStringInfo(str, " %d [ ", length);
1074 for (i = 0; i < sizeof(Datum); i++)
1075 appendStringInfo(str, " %d ", (int) (s[i]));
1076 appendStringInfo(str, "] ");
1080 s = (char *) DatumGetPointer(value);
1081 if (!PointerIsValid(s))
1082 appendStringInfo(str, " 0 [ ] ");
1087 * length is unsigned - very bad to do < comparison to -1
1088 * without casting it to int first!! -mer 8 Jan 1991
1090 if (((int) length) <= -1)
1091 length = VARSIZE(s);
1092 appendStringInfo(str, " %d [ ", length);
1093 for (i = 0; i < length; i++)
1094 appendStringInfo(str, " %d ", (int) (s[i]));
1095 appendStringInfo(str, "] ");
1101 _outIter(StringInfo str, Iter *node)
1103 appendStringInfo(str, " ITER :iterexpr ");
1104 _outNode(str, node->iterexpr);
1108 _outStream(StringInfo str, Stream *node)
1110 appendStringInfo(str,
1111 " STREAM :pathptr @ 0x%x :cinfo @ 0x%x :clausetype %d :upstream @ 0x%x ",
1112 (int) node->pathptr,
1114 (int) node->clausetype,
1115 (int) node->upstream);
1117 appendStringInfo(str,
1118 " :downstream @ 0x%x :groupup %d :groupcost %f :groupsel %f ",
1119 (int) node->downstream,
1126 _outAExpr(StringInfo str, A_Expr *node)
1128 appendStringInfo(str, "EXPR ");
1132 appendStringInfo(str, "AND");
1135 appendStringInfo(str, "OR");
1138 appendStringInfo(str, "NOT");
1141 appendStringInfo(str, "ISNULL");
1144 appendStringInfo(str, "NOTNULL");
1147 appendStringInfo(str, stringStringInfo(node->opname));
1150 _outNode(str, node->lexpr);
1151 _outNode(str, node->rexpr);
1156 _outValue(StringInfo str, Value *value)
1158 switch (value->type)
1161 appendStringInfo(str, " \"%s\" ", stringStringInfo(value->val.str));
1164 appendStringInfo(str, " %ld ", value->val.ival);
1167 appendStringInfo(str, " %f ", value->val.dval);
1176 _outIdent(StringInfo str, Ident *node)
1178 appendStringInfo(str, " IDENT \"%s\" ", stringStringInfo(node->name));
1183 _outAttr(StringInfo str, Attr *node)
1187 appendStringInfo(str, " ATTR \"%s\" ", stringStringInfo(node->relname));
1189 appendStringInfo(str, "(");
1190 foreach(l, node->attrs)
1192 _outNode(str, lfirst(l));
1194 appendStringInfo(str, ",");
1196 appendStringInfo(str, ")");
1201 _outAConst(StringInfo str, A_Const *node)
1203 appendStringInfo(str, "CONST ");
1204 _outValue(str, &(node->val));
1209 _outConstraint(StringInfo str, Constraint *node)
1211 appendStringInfo(str, " %s :type", stringStringInfo(node->name));
1213 switch (node->contype)
1215 case CONSTR_PRIMARY:
1216 appendStringInfo(str, " PRIMARY KEY ");
1217 _outNode(str, node->keys);
1221 appendStringInfo(str, " CHECK :raw ");
1222 _outNode(str, node->raw_expr);
1223 appendStringInfo(str, " :cooked %s ",
1224 stringStringInfo(node->cooked_expr));
1227 case CONSTR_DEFAULT:
1228 appendStringInfo(str, " DEFAULT :raw ");
1229 _outNode(str, node->raw_expr);
1230 appendStringInfo(str, " :cooked %s ",
1231 stringStringInfo(node->cooked_expr));
1234 case CONSTR_NOTNULL:
1235 appendStringInfo(str, " NOT NULL ");
1239 appendStringInfo(str, " UNIQUE ");
1240 _outNode(str, node->keys);
1244 appendStringInfo(str, "<unrecognized constraint>");
1250 _outCaseExpr(StringInfo str, CaseExpr *node)
1252 appendStringInfo(str, "CASE ");
1253 _outNode(str, node->args);
1255 appendStringInfo(str, " :default ");
1256 _outNode(str, node->defresult);
1262 _outCaseWhen(StringInfo str, CaseWhen *node)
1264 appendStringInfo(str, " WHEN ");
1265 _outNode(str, node->expr);
1267 appendStringInfo(str, " :then ");
1268 _outNode(str, node->result);
1275 * converts a Node into ascii string and append it to 'str'
1278 _outNode(StringInfo str, void *obj)
1282 appendStringInfo(str, "<>");
1286 if (nodeTag(obj) == T_List)
1290 appendStringInfo(str, "(");
1291 foreach(l, (List *) obj)
1293 _outNode(str, lfirst(l));
1295 appendStringInfo(str, " ");
1297 appendStringInfo(str, ")");
1301 appendStringInfo(str, "{");
1302 switch (nodeTag(obj))
1305 _outCreateStmt(str, obj);
1308 _outIndexStmt(str, obj);
1312 _outColumnDef(str, obj);
1315 _outTypeName(str, obj);
1318 _outIndexElem(str, obj);
1321 _outQuery(str, obj);
1324 _outSortClause(str, obj);
1327 _outGroupClause(str, obj);
1333 _outResult(str, obj);
1336 _outAppend(str, obj);
1342 _outNestLoop(str, obj);
1345 _outMergeJoin(str, obj);
1348 _outHashJoin(str, obj);
1354 _outSeqScan(str, obj);
1357 _outIndexScan(str, obj);
1360 _outNoname(str, obj);
1369 _outGroup(str, obj);
1372 _outUnique(str, obj);
1378 _outSubPlan(str, obj);
1381 _outResdom(str, obj);
1384 _outFjoin(str, obj);
1393 _outConst(str, obj);
1396 _outAggref(str, obj);
1399 _outSubLink(str, obj);
1402 _outArray(str, obj);
1405 _outArrayRef(str, obj);
1414 _outParam(str, obj);
1417 _outEState(str, obj);
1420 _outRelOptInfo(str, obj);
1423 _outTargetEntry(str, obj);
1425 case T_RangeTblEntry:
1426 _outRangeTblEntry(str, obj);
1429 _outRowMark(str, obj);
1435 _outIndexPath(str, obj);
1438 _outNestPath(str, obj);
1441 _outMergePath(str, obj);
1444 _outHashPath(str, obj);
1447 _outPathKeyItem(str, obj);
1449 case T_RestrictInfo:
1450 _outRestrictInfo(str, obj);
1453 _outJoinInfo(str, obj);
1459 _outStream(str, obj);
1464 _outValue(str, obj);
1467 _outAExpr(str, obj);
1470 _outIdent(str, obj);
1473 _outAConst(str, obj);
1476 _outConstraint(str, obj);
1479 _outCaseExpr(str, obj);
1482 _outCaseWhen(str, obj);
1485 case T_VariableSetStmt:
1488 _outSelectStmt(str, obj);
1491 _outFuncCall(str, obj);
1498 elog(NOTICE, "_outNode: don't know how to print type %d ",
1502 appendStringInfo(str, "}");
1509 * returns the ascii representation of the Node as a palloc'd string
1512 nodeToString(void *obj)
1516 /* see stringinfo.h for an explanation of this maneuver */
1517 initStringInfo(&str);
1518 _outNode(&str, obj);