explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tkIQ

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

Gather (cost=7,733.11..34,656,124.90 rows=130,927,048 width=16) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6,733.11..21,562,420.10 rows=54,552,937 width=16) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Parallel Append (cost=6,732.70..397,007.30 rows=26,996 width=190) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on parcel_stg_oh (cost=6,732.70..396,872.32 rows=26,996 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..782.00 rows=202 width=184) (actual rows= loops=)

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