explain.depesz.com

PostgreSQL's explain analyze made readable

Result: B6vw

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Update on geometries (cost=0.00..222,466,332,571.75 rows=11,188,673,725,775 width=216) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..222,466,332,571.75 rows=11,188,673,725,775 width=216) (actual rows= loops=)

  • Join Filter: (geometries.geometry_id <> attached_buildings.geometry_id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on geometries (cost=0.00..146,157.76 rows=3,747,576 width=209) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..147,282.65 rows=2,985,577 width=10) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on attached_buildings (cost=0.00..117,775.77 rows=2,985,577 width=10) (actual rows= loops=)