# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.366 | 16,781.661 | ↓ 7.0 | 362 | 1 |
→
Sort (cost=4,022.76..4,022.89 rows=52 width=156) (actual time=16,781.619..16,781.661 rows=362 loops=1)
|
2. | 3.504 | 16,781.295 | ↓ 7.0 | 362 | 1 |
→
GroupAggregate (cost=4,018.42..4,021.28 rows=52 width=156) (actual time=16,777.779..16,781.295 rows=362 loops=1)
|
3. | 3.462 | 16,777.791 | ↓ 8.7 | 452 | 1 |
→
Sort (cost=4,018.42..4,018.55 rows=52 width=160) (actual time=16,777.728..16,777.791 rows=452 loops=1)
|
4. | 2.824 | 16,774.329 | ↓ 8.7 | 452 | 1 |
→
Nested Loop Left Join (cost=3.10..4,016.94 rows=52 width=160) (actual time=85.583..16,774.329 rows=452 loops=1) |
5. | 2.391 | 15,258.505 | ↓ 8.2 | 425 | 1 |
→
Nested Loop Left Join (cost=2.54..1,642.17 rows=52 width=153) (actual time=67.987..15,258.505 rows=425 loops=1) |
6. | 2.031 | 9,966.932 | ↓ 7.0 | 362 | 1 |
→
Nested Loop Left Join (cost=1.99..1,148.87 rows=52 width=115) (actual time=42.858..9,966.932 rows=362 loops=1) |
7. | 2.971 | 8,953.111 | ↓ 7.0 | 362 | 1 |
→
Nested Loop Left Join (cost=1.55..903.15 rows=52 width=109) (actual time=42.800..8,953.111 rows=362 loops=1) |
8. | 2.303 | 4,885.604 | ↓ 7.0 | 362 | 1 |
→
Nested Loop (cost=1.12..659.63 rows=52 width=99) (actual time=19.575..4,885.604 rows=362 loops=1) |
9. | 4.265 | 4.265 | ↓ 7.0 | 362 | 1 |
→
Index Scan using object_adress_index on object_address a (cost=0.56..213.60 rows=52 width=51) (actual time=0.177..4.265 rows=362 loops=1)
|
10. | 4,879.036 | 4,879.036 | ↑ 1.0 | 1 | 362 |
→
Index Scan using object_data_pkey on object_data d (cost=0.56..8.58 rows=1 width=63) (actual time=13.478..13.478 rows=1 loops=362)
|
11. | 4,064.536 | 4,064.536 | ↓ 0.0 | 0 | 362 |
→
Index Scan using premises_data_pkey on premises_data p (cost=0.43..4.68 rows=1 width=25) (actual time=11.228..11.228 rows=0 loops=362)
|
12. | 1,011.790 | 1,011.790 | ↑ 1.0 | 1 | 362 |
→
Index Scan using parcel_data_pkey on parcel_data par (cost=0.43..4.73 rows=1 width=21) (actual time=2.795..2.795 rows=1 loops=362)
|
13. | 5,289.182 | 5,289.182 | ↑ 3.0 | 1 | 362 |
→
Index Scan using right_data_pkey on right_data r (cost=0.56..9.46 rows=3 width=53) (actual time=14.200..14.611 rows=1 loops=362)
|
14. | 1,513.000 | 1,513.000 | ↓ 0.0 | 0 | 425 |
→
Index Scan using encumbrance_data_pkey on encumbrance_data e (cost=0.56..45.47 rows=20 width=22) (actual time=3.559..3.560 rows=0 loops=425)
|