8000 Clarify runtime pruning in EXPLAIN · postgres/postgres@1e6240a · GitHub
[go: up one dir, main page]
Skip to content

Commit 1e6240a

Browse files
alvherrealvherre
committed
Clarify runtime pruning in EXPLAIN
Author: Amit Langote Reviewed-by: David Rowley Discussion: https://postgr.es/m/002dec69-9afb-b621-5630-235eceafe0bd@lab.ntt.co.jp
1 parent 3abb11e commit 1e6240a

File tree

1 file changed

+6
-2
lines changed

1 file changed

+6
-2
lines changed

‎doc/src/sgml/ddl.sgml

Lines changed: 6 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -4421,8 +4421,12 @@ EXPLAIN SELECT count(*) FROM measurement WHERE logdate >= DATE '2008-01-01';
44214421
query, partition pruning is performed whenever one of the
44224422
execution parameters being used by partition pruning changes.
44234423
Determining if partitions were pruned during this phase requires
4424-
careful inspection of the <literal>nloops</literal> property in
4425-
the <command>EXPLAIN ANALYZE</command> output.
4424+
careful inspection of the <literal>loops</literal> property in
4425+
the <command>EXPLAIN ANALYZE</command> output. Subplans
4426+
corresponding to different partitions may have different values
4427+
for it depending on how many times each of them was pruned during
4428+
execution. Some may be shown as <literal>(never executed)</literal>
4429+
if they were pruned every time.
44264430
</para>
44274431
</listitem>
44284432
</itemizedlist>

0 commit comments

Comments
 (0)
0