explain.depesz.com

A tool for finding a real cause for slow queries.

Result: jk4z

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 3,352.212 6,291.833 ↑ 11.0 1 1

GroupAggregate (cost=3,673.66..3,775.46 rows=11 width=63) (actual time=6,291.832..6,291.833 rows=1 loops=1)

2.          

Initplan (forGroupAggregate)

3. 0.015 0.015 ↑ 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.014..0.015 rows=1 loops=1)

  • Index Cond: (player_name_search = 'absoluteaces'::text)
  • Filter: (id_site = 100::smallint)
4. 380.961 1,890.224 ↓ 756.0 524,691 1

Sort (cost=3,667.38..3,669.12 rows=694 width=63) (actual time=1,841.823..1,890.224 rows=524,691 loops=1)

  • Sort Key: cash_hand_player_statistics.id_player, player_real.id_site, public.player.player_name
  • Sort Method: quicksort Memory: 98361kB
5. 187.345 1,509.263 ↓ 756.0 524,691 1

Hash Join (cost=1,800.68..3,634.63 rows=694 width=63) (actual time=27.838..1,509.263 rows=524,691 loops=1)

  • Hash Cond: (cash_hand_player_statistics.id_limit = cash_limit.id_limit)
6. 64.018 1,321.890 ↓ 756.0 524,691 1

Nested Loop (cost=1,798.96..3,623.37 rows=694 width=58) (actual time=27.798..1,321.890 rows=524,691 loops=1)

7. 0.026 0.026 ↑ 1.0 1 1

Index Scan using player_primary_key on player (cost=0.00..6.27 rows=1 width=13) (actual time=0.025..0.026 rows=1 loops=1)

  • Index Cond: (id_player = $2)
8. 937.214 1,257.846 ↓ 756.0 524,691 1

Hash Join (cost=1,798.96..3,610.15 rows=694 width=49) (actual time=27.771..1,257.846 rows=524,691 loops=1)

  • Hash Cond: (cash_hand_player_statistics.id_player_real = player_real.id_player)
9. 292.911 292.911 ↓ 756.0 524,691 1

Index Scan using "chps:idx2-id_player" on cash_hand_player_statistics (cost=0.00..1,796.44 rows=694 width=51) (actual time=0.010..292.911 rows=524,691 loops=1)

  • Index Cond: (id_player = $2)
10. 15.537 27.721 ↑ 1.0 59,065 1

Hash (cost=1,060.65..1,060.65 rows=59,065 width=6) (actual time=27.721..27.721 rows=59,065 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 2308kB
11. 12.184 12.184 ↑ 1.0 59,065 1

Seq Scan on player player_real (cost=0.00..1,060.65 rows=59,065 width=6) (actual time=0.003..12.184 rows=59,065 loops=1)

12. 0.013 0.028 ↑ 1.0 32 1

Hash (cost=1.32..1.32 rows=32 width=9) (actual time=0.028..0.028 rows=32 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
13. 0.015 0.015 ↑ 1.0 32 1

Seq Scan on cash_limit (cost=0.00..1.32 rows=32 width=9) (actual time=0.005..0.015 rows=32 loops=1)

14.          

SubPlan (forGroupAggregate)

15. 1,049.382 1,049.382 ↓ 0.0 0 524,691

Index Scan using cash_table_session_summary_primary_key on cash_table_session_summary chps_s (cost=0.00..6.28 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=524,691)

  • Index Cond: (id_session = $0)
  • Filter: (date_start = $1)