explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nnMZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 11,343.028 ↑ 1,479.6 47 1

Unique (cost=490,417.61..491,207.52 rows=69,540 width=4) (actual time=11,343.012..11,343.028 rows=47 loops=1)

2. 0.080 11,343.017 ↑ 1,858.6 85 1

Sort (cost=490,417.61..490,812.57 rows=157,982 width=4) (actual time=11,343.010..11,343.017 rows=85 loops=1)

  • Sort Key: events.id
  • Sort Method: quicksort Memory: 28kB
3. 10.323 11,342.937 ↑ 1,858.6 85 1

Hash Join (cost=25,734.69..474,613.34 rows=157,982 width=4) (actual time=463.075..11,342.937 rows=85 loops=1)

  • Hash Cond: (picks.game_id = events.id)
4. 10,869.742 10,869.742 ↑ 1.9 91,939 1

Index Scan using picks_status_idx on picks (cost=0.57..448,424.55 rows=173,199 width=4) (actual time=0.022..10,869.742 rows=91,939 loops=1)

  • Index Cond: (status = 'published'::pick_status)
5. 15.250 462.872 ↑ 1.0 69,433 1

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

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

Seq Scan on games events (cost=0.00..24,864.87 rows=69,540 width=4) (actual time=0.017..447.622 rows=69,433 loops=1)

  • Filter: (status = ANY ('{closed,complete,postponed,suspended,cancelled}'::game_status_type[]))
  • Rows Removed by Filter: 6805
Planning time : 0.278 ms
Execution time : 11,343.080 ms