Commit7db9ea5

committed

EXPLAIN VERBOSE prints the plan, and now pretty-prints the plan to

the postmaster log file.

1 parentf71b671 commit7db9ea5Copy full SHA for 7db9ea5

File tree

+10

-6

lines changed

+10

-6

lines changed

Lines changed: 7 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -7,7 +7,7 @@`
`7`	`7`	`*`
`8`	`8`	`*`
`9`	`9`	`* IDENTIFICATION`
`10`		`- * $Header: /cvsroot/pgsql/src/backend/commands/explain.c,v 1.21 1998/08/0404:50:15 momjian Exp $`
	`10`	`+ * $Header: /cvsroot/pgsql/src/backend/commands/explain.c,v 1.22 1998/08/0415:00:26 momjian Exp $`
`11`	`11`	`*`
`12`	`12`	`*-------------------------------------------------------------------------`
`13`	`13`	`*/`
`@@ -30,7 +30,7 @@ typedef struct ExplainState`
`30`	`30`	`{`
`31`	`31`	`/* options */`
`32`	`32`	`boolprintCost;/* print cost */`
`33`		`-boolprintNodes;/* dopprint() instead */`
	`33`	`+boolprintNodes;/* donodeToString() instead */`
`34`	`34`	`/* other states */`
`35`	`35`	`Listrtable;/ range table */`
`36`	`36`	`}ExplainState;`
`@@ -81,8 +81,11 @@ ExplainQuery(Query *query, bool verbose, CommandDest dest)`
`81`	`81`	`es->rtable=query->rtable;`
`82`	`82`
`83`	`83`	`if (es->printNodes)`
`84`		`-s=pprint(plan);`
`85`		`-`
	`84`	`+{`
	`85`	`+pprint(plan);/* display in postmaster log file */`
	`86`	`+s=nodeToString(plan);`
	`87`	`+}`
	`88`	`+`
`86`	`89`	`if (es->printCost)`
`87`	`90`	`{`
`88`	`91`	`s2=Explain_PlanToString(plan,es);`

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,6 +1,6 @@`
`1`	`1`	`.\" This is --nroff--`
`2`	`2`	`.\" XXX standard disclaimer belongs here....`
`3`		`-.\" $Header: /cvsroot/pgsql/src/man/Attic/explain.l,v 1.9 1998/02/10 04:02:59 momjian Exp $`
	`3`	`+.\" $Header: /cvsroot/pgsql/src/man/Attic/explain.l,v 1.10 1998/08/04 15:00:28 momjian Exp $`
`4`	`4`	`.TH EXPLAIN SQL 06/12/97 PostgreSQL PostgreSQL`
`5`	`5`	`.SH NAME`
`6`	`6`	`explain - explains statement execution details`
`@@ -11,7 +11,8 @@ explain - explains statement execution details`
`11`	`11`	`.SH DESCRIPTION`
`12`	`12`	`This command outputs details about the supplied query. The default`
`13`	`13`	`output is the computed query cost.\f2verbose\f1 displays the full query`
`14`		`-plan and cost.`
	`14`	`+plan and cost to your screen, and pretty-prints the plan to the postmaster`
	`15`	`+log file.`
`15`	`16`
`16`	`17`	`.SH EXAMPLES`
`17`	`18`	`In the examples, the table has a single column of float4.`

Comments

(0)