explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g4dp

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

Hash Right Join (cost=11,242,942.52..12,258,336.55 rows=857,313 width=100) (actual rows= loops=)

  • Hash Cond: (rgt.event_id = e.id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on result_game_total rgt (cost=0.00..937,119.80 rows=19,002,080 width=77) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=11,232,226.11..11,232,226.11 rows=857,313 width=35) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Merge Join (cost=10,243,341.90..11,232,226.11 rows=857,313 width=35) (actual rows= loops=)

  • Merge Cond: ((COALESCE(l.event_id, m.event_id)) = e.id)
5. 0.000 0.000 ↓ 0.0

Sort (cost=10,243,341.34..10,245,484.62 rows=857,313 width=27) (actual rows= loops=)

  • Sort Key: (COALESCE(l.event_id, m.event_id))
6. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=120,801.22..10,158,855.45 rows=857,313 width=27) (actual rows= loops=)

  • Hash Cond: (m.live_id = l.id)
7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=38,309.43..10,068,188.90 rows=857,313 width=23) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on outcome o (cost=38,308.86..3,005,161.81 rows=857,313 width=15) (actual rows= loops=)

  • Recheck Cond: (((win_lose)::text = ANY ('{win,lose,void}'::text[])) AND (ut >= (now() - '1 day'::interval)) AND (ut < now()))
9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_outcome_win_lose_ut (cost=0.00..38,094.53 rows=857,313 width=0) (actual rows= loops=)

  • Index Cond: (((win_lose)::text = ANY ('{win,lose,void}'::text[])) AND (ut >= (now() - '1 day'::interval)) AND (ut < now()))
10. 0.000 0.000 ↓ 0.0

Index Scan using market_pkey on market m (cost=0.57..8.23 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (id = o.event_market_id)
11. 0.000 0.000 ↓ 0.0

Hash (cost=59,476.35..59,476.35 rows=1,841,235 width=8) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on live l (cost=0.00..59,476.35 rows=1,841,235 width=8) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Index Only Scan using event_pkey on event e (cost=0.56..917,980.10 rows=23,217,992 width=8) (actual rows= loops=)