# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.048 | 673.078 | ↑ 1.2 | 130 | 1 |
→
Sort (cost=398,548.09..398,548.47 rows=152 width=156) (actual time=673.074..673.078 rows=130 loops=1)
|
2. | 0.410 | 673.030 | ↑ 1.2 | 130 | 1 |
→
GroupAggregate (cost=398,534.22..398,542.58 rows=152 width=156) (actual time=672.641..673.030 rows=130 loops=1)
|
3. | 0.000 | 672.620 | ↑ 1.1 | 134 | 1 |
→
Sort (cost=398,534.22..398,534.60 rows=152 width=160) (actual time=672.613..672.620 rows=134 loops=1)
|
4. | 10.667 | 673.394 | ↑ 1.1 | 134 | 1 |
→
Gather (cost=1,003.10..398,528.71 rows=152 width=160) (actual time=21.260..673.394 rows=134 loops=1)
|
5. | 0.287 | 662.727 | ↑ 1.4 | 45 | 3 |
→
Nested Loop Left Join (cost=3.10..397,513.51 rows=63 width=160) (actual time=18.212..662.727 rows=45 loops=3) |
6. | 0.240 | 662.434 | ↑ 1.4 | 45 | 3 |
→
Nested Loop Left Join (cost=2.54..394,089.64 rows=63 width=153) (actual time=18.117..662.434 rows=45 loops=3) |
7. | 0.417 | 662.189 | ↑ 1.5 | 43 | 3 |
→
Nested Loop Left Join (cost=1.99..393,396.37 rows=63 width=115) (actual time=18.094..662.189 rows=43 loops=3) |
8. | 0.213 | 661.763 | ↑ 1.5 | 43 | 3 |
→
Nested Loop Left Join (cost=1.55..393,047.28 rows=63 width=109) (actual time=18.057..661.763 rows=43 loops=3) |
9. | 0.367 | 661.546 | ↑ 1.5 | 43 | 3 |
→
Nested Loop Left Join (cost=1.12..392,699.82 rows=63 width=99) (actual time=18.029..661.546 rows=43 loops=3) |
10. | 0.598 | 661.172 | ↑ 1.5 | 43 | 3 |
→
Nested Loop (cost=0.56..392,340.02 rows=63 width=63) (actual time=17.997..661.172 rows=43 loops=3) |
11. | 660.562 | 660.562 | ↑ 1.5 | 43 | 3 |
→
Parallel Seq Scan on object_address (cost=0.00..391,799.64 rows=63 width=15) (actual time=17.934..660.562 rows=43 loops=3)
|
12. | 0.012 | 0.012 | ↑ 1.0 | 1 | 130 |
→
Index Scan using object_data_pkey on object_data d (cost=0.56..8.58 rows=1 width=63) (actual time=0.012..0.012 rows=1 loops=130)
|
13. | 0.007 | 0.007 | ↑ 1.0 | 1 | 130 |
→
Index Scan using object_address_pkey on object_address a (cost=0.56..5.71 rows=1 width=51) (actual time=0.007..0.007 rows=1 loops=130)
|
14. | 0.004 | 0.004 | ↓ 0.0 | 0 | 130 |
→
Index Scan using premises_data_pkey on premises_data p (cost=0.43..5.52 rows=1 width=25) (actual time=0.004..0.004 rows=0 loops=130)
|
15. | 0.009 | 0.009 | ↑ 1.0 | 1 | 130 |
→
Index Scan using parcel_data_pkey on parcel_data par (cost=0.43..5.54 rows=1 width=21) (actual time=0.009..0.009 rows=1 loops=130)
|
16. | 0.005 | 0.005 | ↓ 0.0 | 0 | 130 |
→
Index Scan using right_data_pkey on right_data r (cost=0.56..10.97 rows=3 width=53) (actual time=0.005..0.005 rows=0 loops=130)
|
17. | 0.006 | 0.006 | ↓ 0.0 | 0 | 134 |
→
Index Scan using encumbrance_data_pkey on encumbrance_data e (cost=0.56..54.15 rows=20 width=22) (actual time=0.006..0.006 rows=0 loops=134)
|