# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 3.298 | 54.020 | ↓ 0.0 | 0 | 1 |
→
Delete on fact_paths fp (cost=3,138.38..5,778.74 rows=3,080 width=12) (actual time=54.020..54.020 rows=0 loops=1) |
2. | 2.656 | 50.722 | ↓ 1.7 | 5,344 | 1 |
→
Hash Anti Join (cost=3,138.38..5,778.74 rows=3,080 width=12) (actual time=46.266..50.722 rows=5,344 loops=1)
|
3. | 2.219 | 2.219 | ↑ 1.0 | 6,161 | 1 |
→
Seq Scan on fact_paths fp (cost=0.00..287.61 rows=6,161 width=106) (actual time=0.011..2.219 rows=6,161 loops=1) |
4. | 26.536 | 45.847 | ↓ 1.2 | 122,513 | 1 |
→
Hash (cost=1,824.28..1,824.28 rows=105,128 width=38) (actual time=45.847..45.847 rows=122,513 loops=1)
|
5. | 19.311 | 19.311 | ↓ 1.2 | 122,513 | 1 |
→
Seq Scan on tmp_live_paths (cost=0.00..1,824.28 rows=105,128 width=38) (actual time=0.012..19.311 rows=122,513 loops=1) |