Commitf760a8b

committed

Clarify runtime pruning in EXPLAIN

1 parentf88dd4f commitf760a8bCopy full SHA for f760a8b

File tree

-2

lines changed

-2

lines changed

Lines changed: 6 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -3921,8 +3921,12 @@ EXPLAIN SELECT count(*) FROM measurement WHERE logdate >= DATE '2008-01-01';`
`3921`	`3921`	`query, partition pruning is performed whenever one of the`
`3922`	`3922`	`execution parameters being used by partition pruning changes.`
`3923`	`3923`	`Determining if partitions were pruned during this phase requires`
`3924`		`- careful inspection of the <literal>nloops</literal> property in`
`3925`		`- the <command>EXPLAIN ANALYZE</command> output.`
	`3924`	`+ careful inspection of the <literal>loops</literal> property in`
	`3925`	`+ the <command>EXPLAIN ANALYZE</command> output. Subplans`
	`3926`	`+ corresponding to different partitions may have different values`
	`3927`	`+ for it depending on how many times each of them was pruned during`
	`3928`	`+ execution. Some may be shown as <literal>(never executed)</literal>`
	`3929`	`+ if they were pruned every time.`
`3926`	`3930`	`</para>`
`3927`	`3931`	`</listitem>`
`3928`	`3932`	`</itemizedlist>`

Comments

(0)