explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RKta

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 1.578 ↑ 1.0 5 1

Limit (cost=199.63..199.65 rows=5 width=3,569) (actual time=1.574..1.578 rows=5 loops=1)

2. 0.045 1.575 ↑ 4.0 5 1

Sort (cost=199.63..199.68 rows=20 width=3,569) (actual time=1.573..1.575 rows=5 loops=1)

  • Sort Key: pt.finished, pt.last_user_activity
  • Sort Method: top-N heapsort Memory: 28kB
3. 0.082 1.530 ↑ 1.0 20 1

Nested Loop (cost=0.72..199.30 rows=20 width=3,569) (actual time=1.122..1.530 rows=20 loops=1)

4. 0.013 1.348 ↑ 1.0 20 1

Limit (cost=0.43..36.70 rows=20 width=182) (actual time=1.109..1.348 rows=20 loops=1)

5. 1.335 1.335 ↑ 360.0 20 1

Index Scan using be_player_task_task_player_id_key on be_player_task pt (cost=0.43..13,057.42 rows=7,200 width=182) (actual time=1.107..1.335 rows=20 loops=1)

  • Index Cond: (task = 8479)
  • Filter: (((state)::text = 'FINISHED'::text) OR ((state)::text = 'PENDING'::text))
6. 0.100 0.100 ↑ 1.0 1 20

Index Scan using gf_player_pkey on gf_player p1_ (cost=0.29..8.11 rows=1 width=3,395) (actual time=0.004..0.005 rows=1 loops=20)

  • Index Cond: (player_id = pt.player_id)
  • Filter: ((player_registration_state)::text <> 'ERASED'::text)
Total runtime : 1.672 ms