explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gAVt

Settings
# exclusive inclusive rows x rows loops node
1. 26.360 1,159.662 ↓ 1.7 144 1

Gather (cost=1,000.00..192,302.97 rows=83 width=80) (actual time=5.023..1,159.662 rows=144 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1,133.302 1,133.302 ↓ 1.4 48 3

Parallel Seq Scan on valid_addresses_se_t2 (cost=0.00..191,294.67 rows=35 width=80) (actual time=28.351..1,133.302 rows=48 loops=3)

  • 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: 1369620
Planning time : 0.235 ms