Commitb2ff37d

committed

Add minimal test for EXPLAIN ANALYZE of parallel query.

This displays the number of workers launched, thus the test isdependant on configuration to some degree. We'll see whether thatturns out ot be a problem.Author: Rafia SabihDiscussion:https://postgr.es/m/20170331185540.zmsue4ndvqtnayqw@alap3.anarazel.de

1 parent5a59315 commitb2ff37dCopy full SHA for b2ff37d

File tree

+13

-0

lines changed

+13

-0

lines changed

Lines changed: 10 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -280,6 +280,16 @@ explain (costs off)`
`280`	`280`	`Index Cond: (unique1 = 1)`
`281`	`281`	`(5 rows)`
`282`	`282`
	`283`	`+-- to increase the parallel query test coverage`
	`284`	`+EXPLAIN (analyze, timing off, summary off, costs off) SELECT * FROM tenk1;`
	`285`	`+ QUERY PLAN`
	`286`	`+-------------------------------------------------------------`
	`287`	`+ Gather (actual rows=10000 loops=1)`
	`288`	`+ Workers Planned: 4`
	`289`	`+ Workers Launched: 4`
	`290`	`+ -> Parallel Seq Scan on tenk1 (actual rows=2000 loops=5)`
	`291`	`+(4 rows)`
	`292`	`+`
`283`	`293`	`-- provoke error in worker`
`284`	`294`	`select stringu1::int2 from tenk1 where unique1 = 1;`
`285`	`295`	`ERROR: invalid input syntax for integer: "BAAAAA"`

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -116,6 +116,9 @@ set force_parallel_mode=1;`
`116`	`116`	`explain (costs off)`
`117`	`117`	`select stringu1::int2from tenk1where unique1=1;`
`118`	`118`
	`119`	`+-- to increase the parallel query test coverage`
	`120`	`+EXPLAIN (analyze, timing off, summary off, costs off)SELECT*FROM tenk1;`
	`121`	`+`
`119`	`122`	`-- provoke error in worker`
`120`	`123`	`select stringu1::int2from tenk1where unique1=1;`
`121`	`124`

Comments

(0)