explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VN3C

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 156.887 ↑ 1.0 5 1

Limit (cost=37,939.38..37,939.39 rows=5 width=3,569) (actual time=156.882..156.887 rows=5 loops=1)

2. 11.285 156.881 ↑ 1,440.0 5 1

Sort (cost=37,939.38..37,957.38 rows=7,200 width=3,569) (actual time=156.880..156.881 rows=5 loops=1)

  • Sort Key: this_.finished, this_.last_user_activity
  • Sort Method: top-N heapsort Memory: 29kB
3. 32.446 145.596 ↓ 1.5 10,688 1

Hash Join (cost=13,577.80..37,819.79 rows=7,200 width=3,569) (actual time=53.542..145.596 rows=10,688 loops=1)

  • Hash Cond: (this_.player_id = p1_.player_id)
4. 59.730 59.730 ↓ 1.5 10,688 1

Index Scan using be_player_task_task_player_id_key on be_player_task this_ (cost=0.43..13,057.42 rows=7,200 width=174) (actual time=0.051..59.730 rows=10,688 loops=1)

  • Index Cond: (task = 8,479)
  • Filter: (((state)::text = 'FINISHED'::text) OR ((state)::text = 'PENDING'::text))
5. 29.773 53.420 ↓ 1.0 25,577 1

Hash (cost=2,568.72..2,568.72 rows=25,572 width=3,395) (actual time=53.420..53.420 rows=25,577 loops=1)

  • Buckets: 1,024 Batches: 4 Memory Usage: 2,304kB
6. 23.647 23.647 ↓ 1.0 25,577 1

Seq Scan on gf_player p1_ (cost=0.00..2,568.72 rows=25,572 width=3,395) (actual time=0.006..23.647 rows=25,577 loops=1)

  • Filter: active
Total runtime : 156.979 ms