Commit1e6240a

committed

Clarify runtime pruning in EXPLAIN

1 parent3abb11e commit1e6240aCopy full SHA for 1e6240a

File tree

-2

lines changed

-2

lines changed

Lines changed: 6 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -4421,8 +4421,12 @@ EXPLAIN SELECT count(*) FROM measurement WHERE logdate >= DATE '2008-01-01';`
`4421`	`4421`	`query, partition pruning is performed whenever one of the`
`4422`	`4422`	`execution parameters being used by partition pruning changes.`
`4423`	`4423`	`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.`
`4426`	`4430`	`</para>`
`4427`	`4431`	`</listitem>`
`4428`	`4432`	`</itemizedlist>`

Comments

(0)