NotificationsYou must be signed in to change notification settings
Fork15
Star22

Commit249c232

Vitaly Davydov

committed

Rebase the branch and adjust expected/moc100_4.out

1 parentf174282 commit249c232Copy full SHA for 249c232

File tree

2 files changed

+18

-18

lines changed

Makefile
expected
- moc100_4.out

2 files changed

+18

-18

lines changed

`‎Makefile`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -33,7 +33,7 @@ DATA_built = $(RELEASE_SQL) \`
`33`	`33`	`DOCS = README.pg_sphere COPYRIGHT.pg_sphere`
`34`	`34`	`REGRESS = init tables points euler circle line ellipse poly path box index\`
`35`	`35`	`contains_ops contains_ops_compat bounding_box_gist gnomo epochprop\`
`36`		`- contains overlaps spoint_brin`
	`36`	`+ contains overlaps spoint_brin sbox_brin`
`37`	`37`
`38`	`38`	`ifneq ($(USE_HEALPIX),0)`
`39`	`39`	`REGRESS += healpix moc mocautocast`

`‎expected/moc100_4.out`

Lines changed: 17 additions & 17 deletions

Original file line number	Diff line number	Diff line change
`@@ -72,10 +72,10 @@ EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`72`	`72`	`SELECT * FROM moc100 WHERE coverage && '4/0';`
`73`	`73`	`QUERY PLAN`
`74`	`74`	`--------------------------------------------------------------------------------`
`75`		`- Seq Scan on moc100 (cost=0.00..6.26 rows=1 width=96) (actual rows=35 loops=1)`
	`75`	`+ Seq Scan on moc100 (cost=0.00..7.26 rows=1 width=96) (actual rows=35 loops=1)`
`76`	`76`	`Filter: (coverage && '4/0'::smoc)`
`77`	`77`	`Rows Removed by Filter: 66`
`78`		`- Buffers: shared hit=114`
	`78`	`+ Buffers: shared hit=115`
`79`	`79`	`Planning:`
`80`	`80`	`Buffers: shared hit=1`
`81`	`81`	`(6 rows)`
`@@ -84,10 +84,10 @@ EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`84`	`84`	`SELECT * FROM moc100 WHERE coverage = '0/0-11';`
`85`	`85`	`QUERY PLAN`
`86`	`86`	`--------------------------------------------------------------------------------`
`87`		`- Seq Scan on moc100 (cost=0.00..6.26 rows=1 width=96) (actual rows=23 loops=1)`
	`87`	`+ Seq Scan on moc100 (cost=0.00..7.26 rows=1 width=96) (actual rows=23 loops=1)`
`88`	`88`	`Filter: (coverage = '0/0-11'::smoc)`
`89`	`89`	`Rows Removed by Filter: 78`
`90`		`- Buffers: shared hit=59`
	`90`	`+ Buffers: shared hit=60`
`91`	`91`	`Planning:`
`92`	`92`	`Buffers: shared hit=4`
`93`	`93`	`(6 rows)`
`@@ -96,10 +96,10 @@ EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`96`	`96`	`SELECT * FROM moc100 WHERE coverage = '6/43225,43227';`
`97`	`97`	`QUERY PLAN`
`98`	`98`	`-------------------------------------------------------------------------------`
`99`		`- Seq Scan on moc100 (cost=0.00..6.26 rows=1 width=96) (actual rows=1 loops=1)`
	`99`	`+ Seq Scan on moc100 (cost=0.00..7.26 rows=1 width=96) (actual rows=1 loops=1)`
`100`	`100`	`Filter: (coverage = '6/43225 43227'::smoc)`
`101`	`101`	`Rows Removed by Filter: 100`
`102`		`- Buffers: shared hit=59`
	`102`	`+ Buffers: shared hit=60`
`103`	`103`	`Planning:`
`104`	`104`	`Buffers: shared hit=1`
`105`	`105`	`(6 rows)`
`@@ -108,10 +108,10 @@ EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`108`	`108`	`SELECT * FROM moc100 WHERE coverage = '0/';`
`109`	`109`	`QUERY PLAN`
`110`	`110`	`-------------------------------------------------------------------------------`
`111`		`- Seq Scan on moc100 (cost=0.00..6.26 rows=1 width=96) (actual rows=1 loops=1)`
	`111`	`+ Seq Scan on moc100 (cost=0.00..7.26 rows=1 width=96) (actual rows=1 loops=1)`
`112`	`112`	`Filter: (coverage = '0/'::smoc)`
`113`	`113`	`Rows Removed by Filter: 100`
`114`		`- Buffers: shared hit=59`
	`114`	`+ Buffers: shared hit=60`
`115`	`115`	`Planning:`
`116`	`116`	`Buffers: shared hit=1`
`117`	`117`	`(6 rows)`
`@@ -120,10 +120,10 @@ EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`120`	`120`	`SELECT * FROM moc100 WHERE coverage <> '0/0-11';`
`121`	`121`	`QUERY PLAN`
`122`	`122`	`----------------------------------------------------------------------------------`
`123`		`- Seq Scan on moc100 (cost=0.00..6.26 rows=100 width=96) (actual rows=78 loops=1)`
	`123`	`+ Seq Scan on moc100 (cost=0.00..7.26 rows=100 width=96) (actual rows=78 loops=1)`
`124`	`124`	`Filter: (coverage <> '0/0-11'::smoc)`
`125`	`125`	`Rows Removed by Filter: 23`
`126`		`- Buffers: shared hit=59`
	`126`	`+ Buffers: shared hit=60`
`127`	`127`	`Planning:`
`128`	`128`	`Buffers: shared hit=4`
`129`	`129`	`(6 rows)`
`@@ -132,10 +132,10 @@ EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`132`	`132`	`SELECT * FROM moc100 WHERE coverage <> '6/43225,43227';`
`133`	`133`	`QUERY PLAN`
`134`	`134`	`-----------------------------------------------------------------------------------`
`135`		`- Seq Scan on moc100 (cost=0.00..6.26 rows=100 width=96) (actual rows=100 loops=1)`
	`135`	`+ Seq Scan on moc100 (cost=0.00..7.26 rows=100 width=96) (actual rows=100 loops=1)`
`136`	`136`	`Filter: (coverage <> '6/43225 43227'::smoc)`
`137`	`137`	`Rows Removed by Filter: 1`
`138`		`- Buffers: shared hit=59`
	`138`	`+ Buffers: shared hit=60`
`139`	`139`	`Planning:`
`140`	`140`	`Buffers: shared hit=1`
`141`	`141`	`(6 rows)`
`@@ -144,10 +144,10 @@ EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`144`	`144`	`SELECT * FROM moc100 WHERE coverage <> '0/';`
`145`	`145`	`QUERY PLAN`
`146`	`146`	`-----------------------------------------------------------------------------------`
`147`		`- Seq Scan on moc100 (cost=0.00..6.26 rows=100 width=96) (actual rows=100 loops=1)`
	`147`	`+ Seq Scan on moc100 (cost=0.00..7.26 rows=100 width=96) (actual rows=100 loops=1)`
`148`	`148`	`Filter: (coverage <> '0/'::smoc)`
`149`	`149`	`Rows Removed by Filter: 1`
`150`		`- Buffers: shared hit=59`
	`150`	`+ Buffers: shared hit=60`
`151`	`151`	`Planning:`
`152`	`152`	`Buffers: shared hit=1`
`153`	`153`	`(6 rows)`
`@@ -254,7 +254,7 @@ EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`254`	`254`	`SELECT * FROM moc100 WHERE coverage <> '0/0-11';`
`255`	`255`	`QUERY PLAN`
`256`	`256`	`-------------------------------------------------------------------------------------------------------------------`
`257`		`- Bitmap Heap Scan on moc100 (cost=106888.23..106894.48 rows=100 width=96) (actual rows=78 loops=1)`
	`257`	`+ Bitmap Heap Scan on moc100 (cost=106888.23..106895.48 rows=100 width=96) (actual rows=78 loops=1)`
`258`	`258`	`Recheck Cond: (coverage <> '0/0-11'::smoc)`
`259`	`259`	`Rows Removed by Index Recheck: 23`
`260`	`260`	`Heap Blocks: exact=5`
`@@ -273,7 +273,7 @@ EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`273`	`273`	`SELECT * FROM moc100 WHERE coverage <> '6/43225,43227';`
`274`	`274`	`QUERY PLAN`
`275`	`275`	`-------------------------------------------------------------------------------------------------------------------`
`276`		`- Bitmap Heap Scan on moc100 (cost=106888.23..106894.48 rows=100 width=96) (actual rows=100 loops=1)`
	`276`	`+ Bitmap Heap Scan on moc100 (cost=106888.23..106895.48 rows=100 width=96) (actual rows=100 loops=1)`
`277`	`277`	`Recheck Cond: (coverage <> '6/43225 43227'::smoc)`
`278`	`278`	`Rows Removed by Index Recheck: 1`
`279`	`279`	`Heap Blocks: exact=5`
`@@ -292,7 +292,7 @@ EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`292`	`292`	`SELECT * FROM moc100 WHERE coverage <> '0/';`
`293`	`293`	`QUERY PLAN`
`294`	`294`	`-------------------------------------------------------------------------------------------------------------------`
`295`		`- Bitmap Heap Scan on moc100 (cost=106888.23..106894.48 rows=100 width=96) (actual rows=100 loops=1)`
	`295`	`+ Bitmap Heap Scan on moc100 (cost=106888.23..106895.48 rows=100 width=96) (actual rows=100 loops=1)`
`296`	`296`	`Recheck Cond: (coverage <> '0/'::smoc)`
`297`	`297`	`Rows Removed by Index Recheck: 1`
`298`	`298`	`Heap Blocks: exact=5`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit249c232

File tree

2 files changed

2 files changed

`‎Makefile`

`‎expected/moc100_4.out`

0 commit comments