|
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> |
|