explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v6EL

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 82.556 ↑ 1.0 5 1

Limit (cost=16,273.31..16,273.32 rows=5 width=174) (actual time=82.552..82.556 rows=5 loops=1)

2. 7.143 82.551 ↑ 1,440.0 5 1

Sort (cost=16,273.31..16,291.31 rows=7,200 width=174) (actual time=82.550..82.551 rows=5 loops=1)

  • Sort Key: this_.finished, this_.last_user_activity
  • Sort Method: top-N heapsort Memory: 26kB
3. 15.616 75.408 ↓ 1.5 10,688 1

Hash Semi Join (cost=2,952.73..16,153.72 rows=7,200 width=174) (actual time=28.378..75.408 rows=10,688 loops=1)

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

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

Hash (cost=2,632.65..2,632.65 rows=25,572 width=8) (actual time=28.203..28.203 rows=25,577 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 1000kB
6. 16.222 16.222 ↓ 1.0 25,577 1

Seq Scan on gf_player pl (cost=0.00..2,632.65 rows=25,572 width=8) (actual time=0.005..16.222 rows=25,577 loops=1)

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