explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Py5q

Settings
# exclusive inclusive rows x rows loops node
1. 6.433 130.129 ↑ 1.0 931 1

Seq Scan on droid (cost=0.00..154,727.62 rows=931 width=925) (actual time=0.367..130.129 rows=931 loops=1)

  • Filter: (NOT is_deleted)
2.          

SubPlan (forSeq Scan)

3. 1.862 1.862 ↑ 1.0 1 931

Seq Scan on currency (cost=0.00..1.06 rows=1 width=32) (actual time=0.001..0.002 rows=1 loops=931)

  • Filter: (id = droid.currency_id)
  • Rows Removed by Filter: 4
4. 1.862 1.862 ↑ 1.0 1 931

Index Scan using player_pkey on player (cost=0.28..2.29 rows=1 width=9) (actual time=0.002..0.002 rows=1 loops=931)

  • Index Cond: (id = droid.player_id)
5. 0.930 118.110 ↓ 0.0 0 930

Limit (cost=157.70..157.70 rows=1 width=43) (actual time=0.127..0.127 rows=0 loops=930)

6. 1.860 117.180 ↓ 0.0 0 930

Sort (cost=157.70..157.70 rows=1 width=43) (actual time=0.126..0.126 rows=0 loops=930)

  • Sort Key: attack_address.id DESC
  • Sort Method: quicksort Memory: 25kB
7. 115.320 115.320 ↓ 0.0 0 930

Index Scan using address_type on address attack_address (cost=0.29..157.69 rows=1 width=43) (actual time=0.107..0.124 rows=0 loops=930)

  • Index Cond: (address_type = 'Attack'::e_address_type)
  • Filter: (reference_id = droid.id)
  • Rows Removed by Filter: 334
8. 0.931 0.931 ↓ 0.0 0 931

Index Scan using address_pkey on address track_address (cost=0.29..2.31 rows=1 width=35) (actual time=0.001..0.001 rows=0 loops=931)

  • Index Cond: (id = droid.payout_address)
9. 0.931 0.931 ↓ 0.0 0 931

Index Scan using droid_pending_pkey on droid_pending (cost=0.12..2.14 rows=1 width=955) (actual time=0.001..0.001 rows=0 loops=931)

  • Index Cond: (droid_id = droid.id)
Planning time : 0.418 ms
Execution time : 130.472 ms