diff options
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/perform.sgml | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/doc/src/sgml/perform.sgml b/doc/src/sgml/perform.sgml index ff689b65245..cd12b9ce48b 100644 --- a/doc/src/sgml/perform.sgml +++ b/doc/src/sgml/perform.sgml @@ -579,6 +579,31 @@ WHERE t1.unique1 < 100 AND t1.unique2 = t2.unique2; </para> <para> + When using the enable/disable flags to disable plan node types, many of + the flags only discourage the use of the corresponding plan node and don't + outright disallow the planner's ability to use the plan node type. This + is by design so that the planner still maintains the ability to form a + plan for a given query. When the resulting plan contains a disabled node, + the <command>EXPLAIN</command> output will indicate this fact. + +<screen> +SET enable_seqscan = off; +EXPLAIN SELECT * FROM unit; + + QUERY PLAN +--------------------------------------------------------- + Seq Scan on unit (cost=0.00..21.30 rows=1130 width=44) + Disabled: true +</screen> + </para> + + <para> + Because the <literal>unit</literal> table has no indexes, there is no + other means to read the table data, so the sequential scan is the only + option available to the query planner. + </para> + + <para> <indexterm> <primary>subplan</primary> </indexterm> |