explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dnQ7

Settings
# exclusive inclusive rows x rows loops node
1. 647.470 657.565 ↓ 1.7 144 1

Bitmap Heap Scan on valid_addresses_se_t2 (cost=687.38..62,244.23 rows=83 width=80) (actual time=21.640..657.565 rows=144 loops=1)

  • Recheck Cond: (((locality_ix)::text = 'umeaa'::text) OR ((postalcode)::text ~~ '903%'::text))
  • Filter: ((((locality_ix)::text = 'umeaa'::text) OR ((postalcode)::text ~~ '903%'::text)) AND ((address_type = 'NA'::bpchar) OR (address_type = 'NB'::bpchar) OR (address_type = 'NC'::bpchar)) AND (((street_ix)::text = 'sandbeckav'::text) OR (((street)::text % 'Sandbeckav'::text) AND ((levenshtein('sandbeckav'::text, street_lower, 1, 1, 2) <= 3) OR (similarity('sandbeckav'::text, street_lower) >= '0.5'::double precision))) OR ((street_ix)::text = 'sandbeckavaegen'::text) OR (((street)::text % 'Sandbeckavägen'::text) AND ((levenshtein('sandbeckavägen'::text, street_lower, 1, 1, 2) <= 3) OR (similarity('sandbeckavägen'::text, street_lower) >= '0.5'::double precision))) OR ((street_ix)::text = 'sandbeckavaeg'::text) OR (((street)::text % 'Sandbeckaväg'::text) AND ((levenshtein('sandbeckaväg'::text, street_lower, 1, 1, 2) <= 3) OR (similarity('sandbeckaväg'::text, street_lower) >= '0.5'::double precision)))))
  • Rows Removed by Filter: 29000
  • Heap Blocks: exact=24337
2. 0.003 10.095 ↓ 0.0 0 1

BitmapOr (cost=687.38..687.38 rows=32,547 width=0) (actual time=10.095..10.095 rows=0 loops=1)

3. 5.467 5.467 ↑ 1.0 29,144 1

Bitmap Index Scan on valid_addresses_se_t2_locality_ix_like (cost=0.00..633.40 rows=29,996 width=0) (actual time=5.467..5.467 rows=29,144 loops=1)

  • Index Cond: ((locality_ix)::text = 'umeaa'::text)
4. 4.625 4.625 ↓ 3.2 8,076 1

Bitmap Index Scan on valid_addresses_se_t2_postalcode_ix_like (cost=0.00..53.94 rows=2,551 width=0) (actual time=4.625..4.625 rows=8,076 loops=1)

  • Index Cond: (((postalcode)::text ~>=~ '903'::text) AND ((postalcode)::text ~<~ '904'::text))
Planning time : 0.454 ms