explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kNBH

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

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

2. 10.078 143.774 ↑ 1,440.0 5 1

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

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

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

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

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

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

  • Buckets: 1,024 Batches: 4 Memory Usage: 2,304kB
6. 22.700 22.700 ↓ 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.028..22.700 rows=25,577 loops=1)

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