explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4KUh

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

Hash Join (cost=10.76..21.19 rows=1 width=524) (actual rows= loops=)

  • Hash Cond: ((stage.team_id)::text = (t.team_id)::text)
  • Join Filter: ((t.start_date <= stage.effective_date) AND (t.end_date > stage.effective_date))
2. 0.000 0.000 ↓ 0.0

Seq Scan on temp_stage stage (cost=0.00..10.30 rows=30 width=520) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=10.75..10.75 rows=1 width=532) (actual rows= loops=)

  • -> Seq Scan on team t (cost=0.00..10.75 rows=1 width=532)" Filter: ((superseded IS NULL) AND (request_id = 0))