explain.depesz.com

A tool for finding a real cause for slow queries.

Result: P2P

options
# exclusive inclusive rows x rows loops node
1. 0.000 5.234 ↓ 7.0 7 1
→

Limit (cost=33.49..33.50 rows=1 width=150) (actual time=5.233..5.234 rows=7 loops=1)

2.          

Initplan (forLimit)
3. 0.073 0.073 ↑ 1.0 1 1
→

Index Scan using "idx1:player_name_search" on player (cost=0.00..6.28 rows=1 width=4) (actual time=0.071..0.073 rows=1 loops=1)

  • Index Cond: (player_name_search = 'absoluteaces'::text)
  • Filter: (id_site = 100::smallint)
4. 0.084 5.232 ↓ 7.0 7 1
→

Sort (cost=27.22..27.22 rows=1 width=150) (actual time=5.231..5.232 rows=7 loops=1)

  • Sort Key: (timezone('UTC'::text, (cash_hand_player_statistics.date_played + '00:00:00'::interval)))
  • Sort Method: quicksort Memory: 26kB
5. 0.056 5.148 ↓ 7.0 7 1
→

Nested Loop (cost=14.73..27.21 rows=1 width=150) (actual time=4.741..5.148 rows=7 loops=1)

6. 0.011 5.057 ↓ 7.0 7 1
→

Nested Loop (cost=14.73..26.81 rows=1 width=145) (actual time=4.714..5.057 rows=7 loops=1)

7. 0.047 4.899 ↓ 7.0 7 1
→

Nested Loop (cost=14.73..24.69 rows=1 width=140) (actual time=4.698..4.899 rows=7 loops=1)

8. 0.018 4.789 ↓ 7.0 7 1
→

Nested Loop (cost=14.73..23.28 rows=1 width=131) (actual time=4.671..4.789 rows=7 loops=1)

9. 0.060 4.666 ↓ 7.0 7 1
→

Hash Join (cost=14.73..16.95 rows=1 width=79) (actual time=4.631..4.666 rows=7 loops=1)

  • Hash Cond: ((lookup_positions."position" = cash_hand_player_statistics."position") AND (lookup_positions.cnt_players = cash_hand_player_statistics.cnt_players_lookup_position))
10. 0.013 0.013 ↑ 1.0 69 1
→

Seq Scan on lookup_positions (cost=0.00..1.69 rows=69 width=10) (actual time=0.006..0.013 rows=69 loops=1)

11. 0.011 4.593 ↓ 7.0 7 1
→

Hash (cost=14.71..14.71 rows=1 width=77) (actual time=4.593..4.593 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
12. 0.044 4.582 ↓ 7.0 7 1
→

Hash Join (cost=12.71..14.71 rows=1 width=77) (actual time=4.554..4.582 rows=7 loops=1)

  • Hash Cond: (lookup_actions_r.id_action = cash_hand_player_statistics.id_action_r)
13. 0.008 0.008 ↑ 1.0 72 1
→

Seq Scan on lookup_actions lookup_actions_r (cost=0.00..1.72 rows=72 width=8) (actual time=0.002..0.008 rows=72 loops=1)

14. 0.009 4.530 ↓ 7.0 7 1
→

Hash (cost=12.70..12.70 rows=1 width=77) (actual time=4.530..4.530 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
15. 0.034 4.521 ↓ 7.0 7 1
→

Hash Join (cost=10.70..12.70 rows=1 width=77) (actual time=4.493..4.521 rows=7 loops=1)

  • Hash Cond: (lookup_actions_t.id_action = cash_hand_player_statistics.id_action_t)
16. 0.008 0.008 ↑ 1.0 72 1
→

Seq Scan on lookup_actions lookup_actions_t (cost=0.00..1.72 rows=72 width=8) (actual time=0.001..0.008 rows=72 loops=1)

17. 0.010 4.479 ↓ 7.0 7 1
→

Hash (cost=10.69..10.69 rows=1 width=77) (actual time=4.479..4.479 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
18. 0.032 4.469 ↓ 7.0 7 1
→

Hash Join (cost=8.69..10.69 rows=1 width=77) (actual time=4.442..4.469 rows=7 loops=1)

  • Hash Cond: (lookup_actions_f.id_action = cash_hand_player_statistics.id_action_f)
19. 0.007 0.007 ↑ 1.0 72 1
→

Seq Scan on lookup_actions lookup_actions_f (cost=0.00..1.72 rows=72 width=8) (actual time=0.001..0.007 rows=72 loops=1)

20. 0.010 4.430 ↓ 7.0 7 1
→

Hash (cost=8.68..8.68 rows=1 width=77) (actual time=4.430..4.430 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
21. 0.037 4.420 ↓ 7.0 7 1
→

Hash Join (cost=6.68..8.68 rows=1 width=77) (actual time=4.392..4.420 rows=7 loops=1)

  • Hash Cond: (lookup_actions_p.id_action = cash_hand_player_statistics.id_action_p)
22. 0.007 0.007 ↑ 1.0 72 1
→

Seq Scan on lookup_actions lookup_actions_p (cost=0.00..1.72 rows=72 width=8) (actual time=0.001..0.007 rows=72 loops=1)

23. 0.014 4.376 ↓ 7.0 7 1
→

Hash (cost=6.66..6.66 rows=1 width=77) (actual time=4.376..4.376 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
24. 4.362 4.362 ↓ 7.0 7 1
→

Index Scan using "chps:idx2-id_player" on cash_hand_player_statistics (cost=0.00..6.66 rows=1 width=77) (actual time=4.307..4.362 rows=7 loops=1)

  • Index Cond: ((id_player = $0) AND (id_limit = 30))
  • Filter: ((date_played >= '2007-07-20 20:00:00'::timestamp without time zone) AND (date_played <= '2007-07-21 19:59:59'::timestamp without time zone))
25. 0.105 0.105 ↑ 1.0 1 7
→

Index Scan using cash_hand_summary_primary_key on cash_hand_summary (cost=0.00..6.32 rows=1 width=56) (actual time=0.014..0.015 rows=1 loops=7)

  • Index Cond: ((cash_hand_summary.id_hand = cash_hand_player_statistics.id_hand) AND (cash_hand_summary.id_limit = 30))
26. 0.063 0.063 ↑ 1.0 1 7
→

Seq Scan on cash_limit (cost=0.00..1.40 rows=1 width=13) (actual time=0.009..0.009 rows=1 loops=7)

  • Filter: (cash_limit.id_limit = 30)
27. 0.147 0.147 ↑ 1.0 1 7
→

Index Scan using player_primary_key on player player_winner (cost=0.00..2.11 rows=1 width=13) (actual time=0.020..0.021 rows=1 loops=7)

  • Index Cond: (player_winner.id_player = cash_hand_summary.id_winner)
28. 0.035 0.035 ↑ 1.0 1 7
→

Index Scan using cash_table_primary_key on cash_table (cost=0.00..0.36 rows=1 width=13) (actual time=0.004..0.005 rows=1 loops=7)

  • Index Cond: (cash_table.id_table = cash_hand_summary.id_table)