explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8Nvh

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

Seq Scan on valid_addresses_se_test (cost=0.00..11.88 rows=1 width=1,572) (actual time=0.021..0.157 rows=21 loops=1)

  • Filter: ((((locality_ix)::text = 'bagarmossen'::text) OR ((postalcode)::text ~~ '123%'::text)) AND ((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)))))
Planning time : 0.088 ms