Commit679744c

committed

Fix sample output of EXPLAIN ANALYZE.

Since commitf0f13a3, we estimateModifyTable paths without a RETURNING clause differently. Update anexample from the manual that showed the old behavior.Author: Takayuki Tsunakawa <tsunakawa.takay@fujitsu.com>Reviewed-by: Laurenz Albe <laurenz.albe@cybertec.at>Discussion:https://postgr.es/m/TYAPR01MB29905674F41693BBA9DA28CAFEA20%40TYAPR01MB2990.jpnprd01.prod.outlook.com

1 parenta36dc04 commit679744cCopy full SHA for 679744c

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -773,7 +773,7 @@ EXPLAIN ANALYZE UPDATE tenk1 SET hundred = hundred + 1 WHERE unique1 < 100;`
`773`	`773`
`774`	`774`	`QUERY PLAN`
`775`	`775`	`-------------------------------------------------------------------&zwsp;-------------------------------------------------------------`
`776`		`- Update on tenk1 (cost=5.07..229.46 rows=101 width=250) (actual time=14.628..14.628 rows=0 loops=1)`
	`776`	`+ Update on tenk1 (cost=5.07..229.46 rows=0 width=0) (actual time=14.628..14.628 rows=0 loops=1)`
`777`	`777`	`-> Bitmap Heap Scan on tenk1 (cost=5.07..229.46 rows=101 width=250) (actual time=0.101..0.439 rows=100 loops=1)`
`778`	`778`	`Recheck Cond: (unique1 < 100)`
`779`	`779`	`-> Bitmap Index Scan on tenk1_unique1 (cost=0.00..5.04 rows=101 width=0) (actual time=0.043..0.043 rows=100 loops=1)`
`@@ -809,7 +809,7 @@ ROLLBACK;`
`809`	`809`	`EXPLAIN UPDATE parent SET f2 = f2 + 1 WHERE f1 = 101;`
`810`	`810`	`QUERY PLAN`
`811`	`811`	`-------------------------------------------------------------------&zwsp;----------------`
`812`		`- Update on parent (cost=0.00..24.53 rows=4 width=14)`
	`812`	`+ Update on parent (cost=0.00..24.53 rows=0 width=0)`
`813`	`813`	`Update on parent`
`814`	`814`	`Update on child1`
`815`	`815`	`Update on child2`

Comments

(0)