explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GBJh

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

Nested Loop (cost=0.14..18.92 rows=1 width=524) (actual rows= loops=)

  • -> Index Only Scan using idx_temp_stage_multicolumn on temp_stage stage (cost=0.14..8.16 rows=1 width=520)" Index Cond: ((team_id = (t.team_id)::text) AND (effective_date >= t.start_date) AND (effective_date < t.end_date))
2. 0.000 0.000 ↓ 0.0

Seq Scan on team t (cost=0.00..10.75 rows=1 width=532) (actual rows= loops=)

  • Filter: ((superseded IS NULL) AND (request_id = 0))