explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4AoP

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

Limit (cost=38,003.31..38,003.32 rows=5 width=3,569) (actual time=127.071..127.076 rows=5 loops=1)

2. 10.630 127.070 ↑ 1,440.0 5 1

Sort (cost=38,003.31..38,021.31 rows=7,200 width=3,569) (actual time=127.069..127.070 rows=5 loops=1)

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

Hash Join (cost=13,641.73..37,883.72 rows=7,200 width=3,569) (actual time=50.699..116.440 rows=10,688 loops=1)

  • Hash Cond: (this_.player_id = p1_.player_id)
4. 35.776 35.776 ↓ 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.848..35.776 rows=10,688 loops=1)

  • Index Cond: (task = 8479)
  • Filter: (((state)::text = 'FINISHED'::text) OR ((state)::text = 'PENDING'::text))
5. 27.939 49.755 ↓ 1.0 25,577 1

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

  • Buckets: 1024 Batches: 4 Memory Usage: 2304kB
6. 21.816 21.816 ↓ 1.0 25,577 1

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

  • Filter: ((player_registration_state)::text <> 'ERASED'::text)
Total runtime : 128.198 ms