Hi,
Documentation of run-time pruning tells readers to inspect "nloops"
property of the EXPLAIN ANALYZE output, but I think that's a typo of
"loops" which is actually output ("internal variable to track that
property is indeed nloops).
However, for pruned partitions' subplans, what's actually shown is the
string "(never executed)", not loops. So, wouldn't it be better to tell
the readers to look for that instead of "loops"?
Attached is what I have in mind.
(cc'ing David Rowley to get his opinion, as he presumably wrote that line.)
Thanks,
Amit
diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml
index 676a87aeb9..5730f359c8 100644
--- a/doc/src/sgml/ddl.sgml
+++ b/doc/src/sgml/ddl.sgml
@@ -4395,8 +4395,9 @@ EXPLAIN SELECT count(*) FROM measurement WHERE logdate
>= DATE '2008-01-01';
query, partition pruning is performed whenever one of the
execution parameters being used by partition pruning changes.
Determining if partitions were pruned during this phase requires
- careful inspection of the <literal>nloops</literal> property in
- the <command>EXPLAIN ANALYZE</command> output.
+ careful inspection of the timing information in the
+ <command>EXPLAIN ANALYZE</command> output. Subplans corresponding
+ to pruned partitions are shown as <literal>(never executed)</literal>.
</para>
</listitem>
</itemizedlist>
