explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rvf6

Settings
# exclusive inclusive rows x rows loops node
1. 19.867 1,087.784 ↓ 1.7 144 1

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

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

Parallel Seq Scan on valid_addresses_se_t2 (cost=0.00..191,294.67 rows=35 width=80) (actual time=4.881..1,067.917 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.159 ms