explain analyze automod

query1: 42 secs 302 msec.

1.	Update on osm_housenumber as housenumber (rows=0 loops=1)
2.	Nested Loop Inner Join (rows=3875429 loops=1)
3.	Seq Scan on osm_housenumber as housenumber (rows=743077 loops=1)

    Filter: ((street_id IS NULL) AND (normalized_street <> ''::text))
    Rows Removed by Filter: 2007

4.	Index Scan using osm_linestring_normalized_name on osm_linestring as street (rows=5 loops=743077)

    Filter: (housenumber.parent_id = parent_id)
    Index Cond: (normalized_name = housenumber.normalized_street)
    Rows Removed by Filter: 53






query2: 53 secs 294 msec.

1.	Update on osm_housenumber as housenumber (rows=0 loops=1)
2.	Nested Loop Inner Join (rows=113092 loops=1)
3.	Seq Scan on osm_housenumber as housenumber (rows=43241 loops=1)

    Filter: ((street_id IS NULL) AND (normalized_street <> ''::text))
    Rows Removed by Filter: 701843

4.	Bitmap Heap Scan on osm_linestring as street (rows=3 loops=43241)

    Filter: st_dwithin(geometry, housenumber.geometry_center, '1000'::double precision)
    Rows Removed by Filter: 0
    Recheck Cond: (normalized_name = housenumber.normalized_street)
    Heap Blocks: exact=72507

5.	Bitmap AND (rows=0 loops=43241)
6.	Bitmap Index Scan using osm_linestring_normalized_name_trgm (rows=77 loops=43241)

    Index Cond: (normalized_name = housenumber.normalized_street)

7.	Bitmap Index Scan using osm_linestring_geometry (rows=68 loops=39732)

    Index Cond: (geometry && st_expand(housenumber.geometry_center, '1000'::double precision))


query3: 1 secs 803 msec.

1.	Update on osm_housenumber as osm_housenumber (rows=0 loops=1)
2.	Seq Scan on osm_housenumber as osm_housenumber (rows=5876 loops=1)

    Filter: ((street_id IS NULL) AND (parent_id IS NOT NULL) AND (normalized_street <> ''::text))
    Rows Removed by Filter: 739208

explain analyze master

query1: 40 secs 987 msec.

1.	Update on osm_housenumber as housenumber (rows=0 loops=1)
2.	Nested Loop Inner Join (rows=3875486 loops=1)
3.	Seq Scan on osm_housenumber as housenumber (rows=743077 loops=1)

    Filter: ((street_id IS NULL) AND (normalized_street <> ''::text))
    Rows Removed by Filter: 2007

4.	Memoize (rows=5 loops=743077)

    Buckets: Batches: Memory Usage: 10105 kB

5.	Index Scan using osm_linestring_normalized_name on osm_linestring as street (rows=3 loops=33389)

    Filter: (housenumber.parent_id = parent_id)
    Index Cond: (normalized_name = housenumber.normalized_street)
    Rows Removed by Filter: 42


query2: 52 secs 22 msec.

1.	Update on osm_housenumber as housenumber (rows=0 loops=1)
2.	Nested Loop Inner Join (rows=113112 loops=1)
3.	Seq Scan on osm_housenumber as housenumber (rows=43261 loops=1)

    Filter: ((street_id IS NULL) AND (normalized_street <> ''::text))
    Rows Removed by Filter: 701823

4.	Bitmap Heap Scan on osm_linestring as street (rows=3 loops=43261)

    Filter: st_dwithin(geometry, housenumber.geometry_center, '1000'::double precision)
    Rows Removed by Filter: 0
    Recheck Cond: (normalized_name = housenumber.normalized_street)
    Heap Blocks: exact=71536

5.	Bitmap AND (rows=0 loops=43261)
6.	Bitmap Index Scan using osm_linestring_normalized_name_trgm (rows=77 loops=43261)

    Index Cond: (normalized_name = housenumber.normalized_street)

7.	Bitmap Index Scan using osm_linestring_geometry (rows=68 loops=39752)

    Index Cond: (geometry && st_expand(housenumber.geometry_center, '1000'::double precision))


query3: 1 secs 768 msec.

1.	Update on osm_housenumber as osm_housenumber (rows=0 loops=1)
2.	Seq Scan on osm_housenumber as osm_housenumber (rows=5876 loops=1)

    Filter: ((street_id IS NULL) AND (parent_id IS NOT NULL) AND (normalized_street <> ''::text))
    Rows Removed by Filter: 739208