# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.000 | 412.461 | ↓ 2.3 | 144 | 1 |
→
Group (cost=102,145.02..102,153.04 rows=63 width=108) (actual time=412.186..412.461 rows=144 loops=1)
|
2. | 0.000 | 412.826 | ↓ 2.8 | 144 | 1 |
→
Gather Merge (cost=102,145.02..102,151.74 rows=52 width=108) (actual time=412.184..412.826 rows=144 loops=1)
|
3. | 0.108 | 1,187.556 | ↓ 1.8 | 48 | 3 |
→
Group (cost=101,144.99..101,145.71 rows=26 width=108) (actual time=395.814..395.852 rows=48 loops=3)
|
4. | 0.612 | 1,187.448 | ↓ 1.8 | 48 | 3 |
→
Sort (cost=101,144.99..101,145.06 rows=26 width=108) (actual time=395.812..395.816 rows=48 loops=3)
|
5. | 1,160.693 | 1,186.836 | ↓ 1.8 | 48 | 3 |
→
Parallel Bitmap Heap Scan on valid_addresses_se a (cost=855.53..101,144.38 rows=26 width=108) (actual time=34.592..395.612 rows=48 loops=3)
|
6. | 0.001 | 26.143 | ↓ 0.0 | 0 | 1 |
→
BitmapOr (cost=855.53..855.53 rows=51,075 width=0) (actual time=26.143..26.143 rows=0 loops=1) |
7. | 21.023 | 21.023 | ↑ 1.0 | 29,133 | 1 |
→
Bitmap Index Scan on valid_addresses_se_locality_ix_ix (cost=0.00..645.45 rows=30,536 width=0) (actual time=21.023..21.023 rows=29,133 loops=1)
|
8. | 5.119 | 5.119 | ↑ 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=5.119..5.119 rows=8,070 loops=1)
|
Planning time | : | 0.692 ms |
---|