explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i7N : plan level G

Settings

Optimization(s) for this plan:

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

GroupAggregate (cost=1.13..58,046,764.32 rows=19,111 width=72) (actual rows= loops=)

  • Group Key: o.id
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..50,313,263.28 rows=618,660,972 width=16) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Merge Join (cost=0.71..91,769.74 rows=274,819 width=1,956) (actual rows= loops=)

  • Merge Cond: (o.id = os.origin_id)
4. 0.000 0.000 ↓ 0.0

Index Only Scan using outline_pkey on outline o (cost=0.29..5,792.60 rows=19,111 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using outline_subdivided_origin_id_idx on outline_subdivided os (cost=0.42..82,494.13 rows=274,819 width=1,956) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using depcnt_l_geometry_idx on depcnt_l c (cost=0.41..180.54 rows=220 width=1,086) (actual rows= loops=)

  • Index Cond: (os.geometry && geometry)" Filter: _st_intersects(os.geometry, geometry)