Commit5163b94

committed

Allow EXPLAIN on CREATE TABLE AS.

1 parente5da8e1 commit5163b94Copy full SHA for 5163b94

File tree

-5

lines changed

-5

lines changed

Lines changed: 6 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$PostgreSQL: pgsql/doc/src/sgml/ref/explain.sgml,v 1.42 2008/04/18 01:42:17 tgl Exp $`
	`2`	`+$PostgreSQL: pgsql/doc/src/sgml/ref/explain.sgml,v 1.43 2008/10/27 08:47:13 petere Exp $`
`3`	`3`	`PostgreSQL documentation`
`4`	`4`	`-->`
`5`	`5`
`@@ -78,7 +78,8 @@ EXPLAIN [ ANALYZE ] [ VERBOSE ] <replaceable class="parameter">statement</replac`
`78`	`78`	`statement will happen as usual. If you wish to use`
`79`	`79`	`<command>EXPLAIN ANALYZE</command> on an`
`80`	`80`	`<command>INSERT</command>, <command>UPDATE</command>,`
`81`		`- <command>DELETE</command>, or <command>EXECUTE</command> statement`
	`81`	`+ <command>DELETE</command>, <command>CREATE TABLE AS</command>,`
	`82`	`+ or <command>EXECUTE</command> statement`
`82`	`83`	`without letting the command affect your data, use this approach:`
`83`	`84`	`<programlisting>`
`84`	`85`	`BEGIN;`
`@@ -116,8 +117,9 @@ ROLLBACK;`
`116`	`117`	`<listitem>`
`117`	`118`	`<para>`
`118`	`119`	`Any <command>SELECT</>, <command>INSERT</>, <command>UPDATE</>,`
`119`		`- <command>DELETE</>, <command>VALUES</>, <command>EXECUTE</>, or`
`120`		`- <command>DECLARE</> statement, whose execution plan you wish to see.`
	`120`	`+ <command>DELETE</>, <command>VALUES</>, <command>EXECUTE</>,`
	`121`	`+ <command>DECLARE</>, or <command>CREATE TABLE AS</command>`
	`122`	`+ statement, whose execution plan you wish to see.`
`121`	`123`	`</para>`
`122`	`124`	`</listitem>`
`123`	`125`	`</varlistentry>`

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -11,7 +11,7 @@`
`11`	`11`	`*`
`12`	`12`	`*`
`13`	`13`	`* IDENTIFICATION`
`14`		`- * $PostgreSQL: pgsql/src/backend/parser/gram.y,v 2.628 2008/10/22 11:00:34 petere Exp $`
	`14`	`+ * $PostgreSQL: pgsql/src/backend/parser/gram.y,v 2.629 2008/10/27 08:47:14 petere Exp $`
`15`	`15`	`*`
`16`	`16`	`* HISTORY`
`17`	`17`	`* AUTHORDATEMAJOR EVENT`
`@@ -5898,6 +5898,7 @@ ExplainableStmt:`
`5898`	`5898`	`\| UpdateStmt`
`5899`	`5899`	`\| DeleteStmt`
`5900`	`5900`	`\| DeclareCursorStmt`
	`5901`	`+\| CreateAsStmt`
`5901`	`5902`	`\| ExecuteStmt/* by default all are $$=$1*/`
`5902`	`5903`	`;`
`5903`	`5904`

Comments

(0)