explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5vPI

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 580.903 ↑ 610.0 114 1

Unique (cost=490,434.16..491,224.10 rows=69,540 width=4) (actual time=580.874..580.903 rows=114 loops=1)

2. 0.050 580.882 ↑ 1,136.6 139 1

Sort (cost=490,434.16..490,829.13 rows=157,988 width=4) (actual time=580.872..580.882 rows=139 loops=1)

  • Sort Key: events.id
  • Sort Method: quicksort Memory: 31kB
3. 7.434 580.832 ↑ 1,136.6 139 1

Hash Join (cost=25,734.69..474,629.33 rows=157,988 width=4) (actual time=77.466..580.832 rows=139 loops=1)

  • Hash Cond: (picks.game_id = events.id)
4. 496.083 496.083 ↑ 1.9 91,439 1

Index Scan using picks_status_idx on picks (cost=0.57..448,440.52 rows=173,205 width=4) (actual time=0.013..496.083 rows=91,439 loops=1)

  • Index Cond: (status = 'published'::pick_status)
5. 14.106 77.315 ↑ 1.0 69,434 1

Hash (cost=24,864.87..24,864.87 rows=69,540 width=4) (actual time=77.315..77.315 rows=69,434 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 3466kB
6. 63.209 63.209 ↑ 1.0 69,434 1

Seq Scan on games events (cost=0.00..24,864.87 rows=69,540 width=4) (actual time=0.007..63.209 rows=69,434 loops=1)

  • Filter: (status = ANY ('{closed,complete,postponed,suspended,cancelled}'::game_status_type[]))
  • Rows Removed by Filter: 6804
Planning time : 0.200 ms
Execution time : 580.943 ms