explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bqH

Settings

Optimization(s) for this plan:

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

Hash Join (cost=691,329.23..2,724,586.53 rows=49,085,159 width=481) (actual rows= loops=)

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

Seq Scan on rb_model mo (cost=0.00..518,147.87 rows=12,215,487 width=238) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=533,345.19..533,345.19 rows=3,456,723 width=243) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=36,649.92..533,345.19 rows=3,456,723 width=243) (actual rows= loops=)

  • Hash Cond: (ev.rangebook_id = ra.id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on rb_event ev (cost=0.00..157,861.85 rows=5,472,585 width=182) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=24,019.76..24,019.76 rows=543,372 width=61) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on rb_rangebook ra (cost=0.00..24,019.76 rows=543,372 width=61) (actual rows= loops=)

  • Filter: (((week)::text = '20'::text) OR ((week)::text = '44'::text))