explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lGfO

Settings
# exclusive inclusive rows x rows loops node
1. 54.133 39,985.529 ↑ 6.6 767 1

Gather (cost=1,000.00..263,985.09 rows=5,045 width=81) (actual time=111.732..39,985.529 rows=767 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 39,931.396 39,931.396 ↑ 8.2 256 3

Parallel Seq Scan on valid_addresses_se a (cost=0.00..262,480.59 rows=2,102 width=81) (actual time=163.187..39,931.396 rows=256 loops=3)

  • Filter: (((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, lower((street)::text), 1, 1, 2) <= 3) OR (similarity('sandbeckav'::text, lower((street)::text)) >= '0.5'::double precision))) OR ((street_ix)::text = 'sandbeckavaegen'::text) OR (((street)::text % 'Sandbeckavägen'::text) AND ((levenshtein('sandbeckavägen'::text, lower((street)::text), 1, 1, 2) <= 3) OR (similarity('sandbeckavägen'::text, lower((street)::text)) >= '0.5'::double precision))) OR ((street_ix)::text = 'sandbeckavaeg'::text) OR (((street)::text % 'Sandbeckaväg'::text) AND ((levenshtein('sandbeckaväg'::text, lower((street)::text), 1, 1, 2) <= 3) OR (similarity('sandbeckaväg'::text, lower((street)::text)) >= '0.5'::double precision)))))
  • Rows Removed by Filter: 1369412
Planning time : 0.534 ms