explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 14aX

Settings

Optimization(s) for this plan:

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

Update on zip_alignment_stage stage (cost=4.32..19.52 rows=1 width=343) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.32..19.52 rows=1 width=343) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan using idx_zip_alignment_stage_requestid on zip_alignment_stage stage (cost=0.14..8.16 rows=1 width=312) (actual rows= loops=)

  • Index Cond: (request_id = 0)
  • Filter: ((from_id IS NULL) AND (record_status = 1))
4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on zip_alignment base (cost=4.17..11.35 rows=1 width=38) (actual rows= loops=)

  • Recheck Cond: (zip_internal_id = stage.zip_internal_id)
  • Filter: ((superseded IS NULL) AND (start_date <> end_date) AND (request_id = 0) AND (stage.team_internal_id = team_internal_id) AND (start_date <= (stage.effective_date)::date) AND (end_date > (stage.effective_date)::date))
  • -> Bitmap Index Scan on zip_alignment_zip_internal_id_idx (cost=0.00..4.17 rows=3 width=0)" Index Cond: (zip_internal_id = stage.zip_internal_id)