explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yoqc

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

Update on zip_alignment_stage stage (cost=0.14..18.94 rows=1 width=343) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.14..18.94 rows=1 width=343) (actual rows= loops=)

  • Join Filter: (((stage.team_id)::text = (t.team_id)::text) AND (t.start_date <= (stage.effective_date)::date) AND (t.end_date > (stage.effective_date)::date))
  • -> Seq Scan on team t (cost=0.00..10.75 rows=1 width=538)" Filter: ((superseded IS NULL) AND (request_id = 0))
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=325) (actual rows= loops=)

  • Index Cond: (request_id = 0)