explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cxAx : Optimization for: plan #bqH

Settings

Optimization path:

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

Merge Join (cost=144.18..1,787,459.22 rows=49,012,515 width=481) (actual rows= loops=)

  • Merge Cond: (ra.id = mo.rangebook_id)
2. 0.000 0.000 ↓ 0.0

Merge Join (cost=112.71..332,134.79 rows=3,458,032 width=243) (actual rows= loops=)

  • Merge Cond: (ra.id = ev.rangebook_id)
3. 0.000 0.000 ↓ 0.0

Index Scan using rb_rangebook_id_uindex on rb_rangebook ra (cost=0.42..37,828.74 rows=543,372 width=61) (actual rows= loops=)

  • Filter: (((week)::text = '20'::text) OR ((week)::text = '44'::text))
4. 0.000 0.000 ↓ 0.0

Index Scan using rb_event_rangebook_id on rb_event ev (cost=0.43..245,315.44 rows=5,474,657 width=182) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Materialize (cost=0.43..751,770.35 rows=12,192,793 width=238) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using rb_model_rangebook_id on rb_model mo (cost=0.43..721,288.37 rows=12,192,793 width=238) (actual rows= loops=)