# | 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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
Planning time | : | 0.857 ms |
---|