# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.000 | 52.413 | ↓ 2.0 | 40 | 1 |
→
Gather Merge (cost=17,055.32..17,057.62 rows=20 width=68) (actual time=43.455..52.413 rows=40 loops=1)
|
2. | 0.232 | 71.940 | ↑ 1.0 | 20 | 2 |
→
Sort (cost=16,055.31..16,055.36 rows=20 width=68) (actual time=35.965..35.970 rows=20 loops=2)
|
3. | 2.615 | 71.708 | ↑ 1.0 | 20 | 2 |
→
Nested Loop (cost=67.14..16,054.88 rows=20 width=68) (actual time=6.443..35.854 rows=20 loops=2)
|
4. | 15.374 | 17.430 | ↑ 1.1 | 1,520 | 2 |
→
Parallel Bitmap Heap Scan on people_nondist p (cost=66.71..5,991.51 rows=1,692 width=36) (actual time=1.678..8.715 rows=1,520 loops=2)
|
5. | 2.056 | 2.056 | ↓ 1.1 | 3,039 | 1 |
→
Bitmap Index Scan on people_nondist_cob_idx (cost=0.00..65.99 rows=2,876 width=0) (actual time=2.056..2.056 rows=3,039 loops=1)
|
6. | 3.039 | 51.663 | ↓ 0.0 | 0 | 3,039 |
→
Append (cost=0.42..5.94 rows=1 width=32) (actual time=0.017..0.017 rows=0 loops=3,039)
|
7. | 48.624 | 48.624 | ↓ 0.0 | 0 | 3,039 |
→
Index Scan using transactions_pt_11_13_people_id_created_at_idx on transactions_pt_11_13 t (cost=0.42..5.93 rows=1 width=32) (actual time=0.016..0.016 rows=0 loops=3,039)
|