explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Js0T

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

Gather (cost=7,876.92..337,988,712.81 rows=1,293,316,582 width=16) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6,876.92..208,656,054.61 rows=538,881,909 width=16) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Parallel Append (cost=6,876.50..398,349.49 rows=266,673 width=190) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on parcel_stg_oh (cost=6,876.50..397,016.13 rows=266,673 width=190) (actual rows= loops=)

  • Recheck Cond: (wa_parcel_id IS NULL)
  • Filter: ((state)::text = OH::text)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on parcel_stg_oh_wa_parcel_id_null (cost=0.00..6,716.50 rows=640,015 width=0) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using parcel_oh_geometry_idx on parcel_oh d (cost=0.41..778.93 rows=202 width=184) (actual rows= loops=)

  • Index Cond: (parcel_stg_oh.geom && geometry)
  • Filter: _st_intersects(parcel_stg_oh.geom, geometry)