#	exclusive	inclusive	rows x	rows	loops	node
1.	0.040	340.333	↓ 2.3	144	1	→ Subquery Scan on a (cost=102,145.02..102,154.06 rows=63 width=120) (actual time=340.002..340.333 rows=144 loops=1)
2.	0.000	340.293	↓ 2.3	144	1	→ Group (cost=102,145.02..102,153.43 rows=63 width=161) (actual time=340.001..340.293 rows=144 loops=1) Group Key: valid_addresses_se.street, valid_addresses_se.street_number, valid_addresses_se.extra_number, valid_addresses_se.letter, valid_addresses_se.premise, valid_addresses_se.postalcode, valid_addresses_se.locality, valid_addresses_se.locality_ix, valid_addresses_se.address_type, valid_addresses_se.uuid, valid_addresses_se.municipality_area, valid_addresses_se.street_ix
3.	0.000	340.675	↓ 2.8	144	1	→ Gather Merge (cost=102,145.02..102,151.87 rows=52 width=129) (actual time=339.998..340.675 rows=144 loops=1) Workers Planned: 2 Workers Launched: 2
4.	0.114	992.724	↓ 1.8	48	3	→ Group (cost=101,144.99..101,145.84 rows=26 width=129) (actual time=330.869..330.908 rows=48 loops=3) Group Key: valid_addresses_se.street, valid_addresses_se.street_number, valid_addresses_se.extra_number, valid_addresses_se.letter, valid_addresses_se.premise, valid_addresses_se.postalcode, valid_addresses_se.locality, valid_addresses_se.locality_ix, valid_addresses_se.address_type, valid_addresses_se.uuid, valid_addresses_se.municipality_area, valid_addresses_se.street_ix
5.	0.645	992.610	↓ 1.8	48	3	→ Sort (cost=101,144.99..101,145.06 rows=26 width=129) (actual time=330.865..330.870 rows=48 loops=3) Sort Key: valid_addresses_se.street, valid_addresses_se.street_number, valid_addresses_se.extra_number, valid_addresses_se.letter, valid_addresses_se.premise, valid_addresses_se.postalcode, valid_addresses_se.locality, valid_addresses_se.locality_ix, valid_addresses_se.address_type, valid_addresses_se.uuid, valid_addresses_se.municipality_area, valid_addresses_se.street_ix Sort Method: quicksort Memory: 30kB
6.	981.471	991.965	↓ 1.8	48	3	→ Parallel Bitmap Heap Scan on valid_addresses_se (cost=855.53..101,144.38 rows=26 width=129) (actual time=23.328..330.655 rows=48 loops=3) Recheck Cond: (((locality_ix)::text = 'umeaa'::text) OR ((postalcode)::text ~~ '903%'::text)) 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: 9663 Heap Blocks: exact=7501
7.	0.002	10.494	↓ 0.0	0	1	→ BitmapOr (cost=855.53..855.53 rows=51,075 width=0) (actual time=10.494..10.494 rows=0 loops=1)
8.	6.331	6.331	↑ 1.0	29,133	1	→ Bitmap Index Scan on valid_addresses_se_locality_ix_like (cost=0.00..645.45 rows=30,536 width=0) (actual time=6.331..6.331 rows=29,133 loops=1) Index Cond: ((locality_ix)::text = 'umeaa'::text)
9.	4.161	4.161	↑ 2.5	8,070	1	→ Bitmap Index Scan on valid_addresses_se_postalcode_gin (cost=0.00..210.05 rows=20,540 width=0) (actual time=4.161..4.161 rows=8,070 loops=1) Index Cond: ((postalcode)::text ~~ '903%'::text)

Planning time	:	0.857 ms

"Subquery Scan on a  (cost=102145.02..102154.06 rows=63 width=120) (actual time=340.002..340.333 rows=144 loops=1)"
"  ->  Group  (cost=102145.02..102153.43 rows=63 width=161) (actual time=340.001..340.293 rows=144 loops=1)"
"        Group Key: valid_addresses_se.street, valid_addresses_se.street_number, valid_addresses_se.extra_number, valid_addresses_se.letter, valid_addresses_se.premise, valid_addresses_se.postalcode, valid_addresses_se.locality, valid_addresses_se.locality_ix, valid_addresses_se.address_type, valid_addresses_se.uuid, valid_addresses_se.municipality_area, valid_addresses_se.street_ix"
"        ->  Gather Merge  (cost=102145.02..102151.87 rows=52 width=129) (actual time=339.998..340.675 rows=144 loops=1)"
"              Workers Planned: 2"
"              Workers Launched: 2"
"              ->  Group  (cost=101144.99..101145.84 rows=26 width=129) (actual time=330.869..330.908 rows=48 loops=3)"
"                    Group Key: valid_addresses_se.street, valid_addresses_se.street_number, valid_addresses_se.extra_number, valid_addresses_se.letter, valid_addresses_se.premise, valid_addresses_se.postalcode, valid_addresses_se.locality, valid_addresses_se.locality_ix, valid_addresses_se.address_type, valid_addresses_se.uuid, valid_addresses_se.municipality_area, valid_addresses_se.street_ix"
"                    ->  Sort  (cost=101144.99..101145.06 rows=26 width=129) (actual time=330.865..330.870 rows=48 loops=3)"
"                          Sort Key: valid_addresses_se.street, valid_addresses_se.street_number, valid_addresses_se.extra_number, valid_addresses_se.letter, valid_addresses_se.premise, valid_addresses_se.postalcode, valid_addresses_se.locality, valid_addresses_se.locality_ix, valid_addresses_se.address_type, valid_addresses_se.uuid, valid_addresses_se.municipality_area, valid_addresses_se.street_ix"
"                          Sort Method: quicksort  Memory: 30kB"
"                          ->  Parallel Bitmap Heap Scan on valid_addresses_se  (cost=855.53..101144.38 rows=26 width=129) (actual time=23.328..330.655 rows=48 loops=3)"
"                                Recheck Cond: (((locality_ix)::text = 'umeaa'::text) OR ((postalcode)::text ~~ '903%'::text))"
"                                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: 9663"
"                                Heap Blocks: exact=7501"
"                                ->  BitmapOr  (cost=855.53..855.53 rows=51075 width=0) (actual time=10.494..10.494 rows=0 loops=1)"
"                                      ->  Bitmap Index Scan on valid_addresses_se_locality_ix_like  (cost=0.00..645.45 rows=30536 width=0) (actual time=6.331..6.331 rows=29133 loops=1)"
"                                            Index Cond: ((locality_ix)::text = 'umeaa'::text)"
"                                      ->  Bitmap Index Scan on valid_addresses_se_postalcode_gin  (cost=0.00..210.05 rows=20540 width=0) (actual time=4.161..4.161 rows=8070 loops=1)"
"                                            Index Cond: ((postalcode)::text ~~ '903%'::text)"
"Planning time: 0.857 ms"
"Execution time: 340.913 ms"

Per node type stats

node type	count	sum of times	% of query
Bitmap Index Scan	2	10.492 ms	3.1 %
BitmapOr	1	0.002 ms	0.0 %
Gather Merge	1	0.000 ms	0.0 %
Group	2	0.114 ms	0.0 %
Parallel Bitmap Heap Scan	1	981.471 ms	288.4 %
Sort	1	0.645 ms	0.2 %
Subquery Scan	1	0.040 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
valid_addresses_se	1	981.471 ms	288.4 %
Parallel Bitmap Heap Scan	1	981.471 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sqjbP

Color mode:

Visible columns:

Per node type stats

Per table stats