explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YenV

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

Update on zip_alignment_stage stage (cost=23.17..36.37 rows=3 width=885) (actual rows= loops=)

2.          

CTE cte

3. 0.000 0.000 ↓ 0.0

Hash Join (cost=10.68..23.08 rows=3 width=524) (actual rows= loops=)

  • Hash Cond: ((g.geography_id)::text = (stage_1.geography_id)::text)
  • Join Filter: ((g.start_date <= stage_1.effective_date) AND (g.end_date > stage_1.effective_date))
4. 0.000 0.000 ↓ 0.0

Seq Scan on geographies g (cost=0.00..11.50 rows=120 width=26) (actual rows= loops=)

  • Filter: ((superseded IS NULL) AND (request_id = 0))
5. 0.000 0.000 ↓ 0.0

Hash (cost=10.30..10.30 rows=30 width=520) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

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

7. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..13.29 rows=3 width=885) (actual rows= loops=)

  • Hash Cond: ((stage.geography_id)::text = (cte.geography_id)::text)
8. 0.000 0.000 ↓ 0.0

Seq Scan on zip_alignment_stage stage (cost=0.00..12.30 rows=230 width=325) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=1072)" -> CTE Scan on cte (cost=0.00..0.06 rows=3 width=1,072) (actual rows= loops=)