explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t5Ha

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 76.388 ↑ 1.0 1 1

Limit (cost=168.96..168.97 rows=1 width=8) (actual time=76.387..76.388 rows=1 loops=1)

2. 0.011 76.381 ↑ 1.0 1 1

Aggregate (cost=168.96..168.97 rows=1 width=8) (actual time=76.381..76.381 rows=1 loops=1)

3. 0.111 76.370 ↓ 20.0 20 1

Sort (cost=168.95..168.95 rows=1 width=36) (actual time=76.368..76.370 rows=20 loops=1)

  • Sort Key: (max(raw_unetsafe_orders.created_at)) DESC
  • Sort Method: quicksort Memory: 26kB
4. 0.032 76.259 ↓ 20.0 20 1

GroupAggregate (cost=168.91..168.94 rows=1 width=36) (actual time=76.240..76.259 rows=20 loops=1)

  • Group Key: live_players.project_id, live_players.external_id
5. 0.092 76.227 ↓ 24.0 24 1

Sort (cost=168.91..168.92 rows=1 width=20) (actual time=76.224..76.227 rows=24 loops=1)

  • Sort Key: live_players.project_id, live_players.external_id
  • Sort Method: quicksort Memory: 26kB
6. 0.032 76.135 ↓ 24.0 24 1

Nested Loop Left Join (cost=1.25..168.90 rows=1 width=20) (actual time=2.156..76.135 rows=24 loops=1)

7. 0.188 68.183 ↓ 24.0 24 1

Nested Loop (cost=0.84..162.43 rows=1 width=32) (actual time=0.366..68.183 rows=24 loops=1)

8. 66.012 66.012 ↓ 55.1 661 1

Index Scan using live_players_personal_manager_id_index on live_players (cost=0.56..156.40 rows=12 width=12) (actual time=0.317..66.012 rows=661 loops=1)

  • Index Cond: (personal_manager_id = 17,853)
  • Filter: (deposit_status_id > 1)
9. 1.983 1.983 ↓ 0.0 0 661

Index Scan using raw_unetsafe_orders_project_id_player_external_id_created_a_idx on raw_unetsafe_orders (cost=0.28..0.49 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=661)

  • Index Cond: ((project_id = live_players.project_id) AND (player_external_id = live_players.external_id))
10. 7.920 7.920 ↑ 124.0 1 24

Index Only Scan using exchange_rates_period_currency_excl on exchange_rates (cost=0.41..5.23 rows=124 width=25) (actual time=0.254..0.330 rows=1 loops=24)

  • Index Cond: ((period @> raw_unetsafe_orders.status_updated_at) AND (currency = raw_unetsafe_orders.currency))
  • Heap Fetches: 663
Planning time : 6.292 ms
Execution time : 76.768 ms