explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0fas

Settings
# exclusive inclusive rows x rows loops node
1. 1,369.224 100,647.000 ↑ 88,195.5 2 1

GroupAggregate (cost=411,519.48..415,488.27 rows=176,391 width=33) (actual time=99,288.776..100,647.000 rows=2 loops=1)

  • Group Key: o.outcome_type_cname, o.name, o.cname
2. 3,296.487 99,277.776 ↑ 1.1 167,592 1

Sort (cost=411,519.48..411,960.45 rows=176,391 width=33) (actual time=97,901.572..99,277.776 rows=167,592 loops=1)

  • Sort Key: o.outcome_type_cname, o.name, o.cname
  • Sort Method: external merge Disk: 5232kB
3. 4,494.170 95,981.289 ↑ 1.1 167,592 1

Nested Loop (cost=3,011.97..391,321.90 rows=176,391 width=33) (actual time=1,157.054..95,981.289 rows=167,592 loops=1)

4. 1,928.720 74,496.019 ↓ 2.0 113,274 1

Hash Join (cost=3,011.53..231,214.61 rows=55,770 width=4) (actual time=1,156.976..74,496.019 rows=113,274 loops=1)

  • Hash Cond: (m.event_id = e.id)
5. 36,286.730 71,413.330 ↓ 2.0 113,274 1

Hash Join (cost=31.00..226,909.54 rows=55,770 width=8) (actual time=2.962..71,413.330 rows=113,274 loops=1)

  • Hash Cond: ((m.name)::text = (mt.name)::text)
6. 35,124.627 35,124.627 ↑ 1.0 4,388,315 1

Seq Scan on markets m (cost=0.00..138,528.28 rows=4,389,628 width=40) (actual time=0.020..35,124.627 rows=4,388,315 loops=1)

7. 0.167 1.973 ↑ 1.0 14 1

Hash (cost=30.83..30.83 rows=14 width=33) (actual time=1.973..1.973 rows=14 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
8. 1.806 1.806 ↑ 1.0 14 1

Seq Scan on market_types mt (cost=0.00..30.83 rows=14 width=33) (actual time=1.558..1.806 rows=14 loops=1)

  • Filter: ((name2)::text = '[Total Goals] X.5'::text)
  • Rows Removed by Filter: 772
9. 578.993 1,153.969 ↑ 1.0 70,468 1

Hash (cost=2,099.68..2,099.68 rows=70,468 width=4) (actual time=1,153.969..1,153.969 rows=70,468 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 2478kB
10. 574.976 574.976 ↑ 1.0 70,468 1

Seq Scan on events e (cost=0.00..2,099.68 rows=70,468 width=4) (actual time=0.522..574.976 rows=70,468 loops=1)

11. 16,991.100 16,991.100 ↑ 74.0 1 113,274

Index Scan using outcomes_market_id_index on outcomes o (cost=0.43..2.13 rows=74 width=37) (actual time=0.134..0.150 rows=1 loops=113,274)

  • Index Cond: (market_id = m.id)
Planning time : 325.108 ms
Execution time : 100,648.854 ms