explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DuxM

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 376.221 ↑ 1.0 5 1

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

2. 11.799 376.213 ↑ 1,440.0 5 1

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

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

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

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

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

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

  • Buckets: 1024 Batches: 4 Memory Usage: 2304kB
6. 94.539 94.539 ↓ 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.006..94.539 rows=25,577 loops=1)

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