explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9UwX7

Settings
# exclusive inclusive rows x rows loops node
1. 65.075 75.593 ↓ 21.0 21 1

Bitmap Heap Scan on valid_addresses_se_test (cost=82.91..7,009.43 rows=1 width=116) (actual time=16.092..75.593 rows=21 loops=1)

  • Recheck Cond: (((locality_ix)::text = 'bagarmossen'::text) OR ((postalcode)::text ~~ '123%'::text))
  • Rows Removed by Index Recheck: 14
  • Filter: (((address_type = 'NA'::bpchar) OR (address_type = 'NB'::bpchar) OR (address_type = 'NC'::bpchar)) AND (((street_ix)::text = 'xvoxnegraend'::text) OR (((street)::text % 'XVoxnegränd'::text) AND ((levenshtein('xvoxnegränd'::text, street_lower, 1, 1, 2) <= 3) OR (similarity('xvoxnegränd'::text, street_lower) >= '0.5'::double precision)))))
  • Rows Removed by Filter: 6513
  • Heap Blocks: exact=6336
2. 0.001 10.518 ↓ 0.0 0 1

BitmapOr (cost=82.91..82.91 rows=1,931 width=0) (actual time=10.518..10.518 rows=0 loops=1)

3. 0.299 0.299 ↑ 1.2 1,342 1

Bitmap Index Scan on valid_addresses_se_test_locality_ix_like (cost=0.00..36.11 rows=1,557 width=0) (actual time=0.298..0.299 rows=1,342 loops=1)

  • Index Cond: ((locality_ix)::text = 'bagarmossen'::text)
4. 10.218 10.218 ↓ 13.9 5,206 1

Bitmap Index Scan on valid_addresses_se_test_postalcode_ix_trgm (cost=0.00..46.81 rows=374 width=0) (actual time=10.218..10.218 rows=5,206 loops=1)

  • Index Cond: ((postalcode)::text ~~ '123%'::text)
Planning time : 0.255 ms