#	exclusive	inclusive	rows x	rows	loops	node
1.	3352.212	6291.833	↑ 11.0	1	1	→ GroupAggregate (cost=3673.66..3775.46 rows=11 width=63) (actual time=6291.832..6291.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	1890.224	↓ 756.0	524691	1	→ Sort (cost=3667.38..3669.12 rows=694 width=63) (actual time=1841.823..1890.224 rows=524691 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	1509.263	↓ 756.0	524691	1	→ Hash Join (cost=1800.68..3634.63 rows=694 width=63) (actual time=27.838..1509.263 rows=524691 loops=1) Hash Cond: (cash_hand_player_statistics.id_limit = cash_limit.id_limit)
6.	64.018	1321.890	↓ 756.0	524691	1	→ Nested Loop (cost=1798.96..3623.37 rows=694 width=58) (actual time=27.798..1321.890 rows=524691 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	1257.846	↓ 756.0	524691	1	→ Hash Join (cost=1798.96..3610.15 rows=694 width=49) (actual time=27.771..1257.846 rows=524691 loops=1) Hash Cond: (cash_hand_player_statistics.id_player_real = player_real.id_player)
9.	292.911	292.911	↓ 756.0	524691	1	→ Index Scan using "chps:idx2-id_player" on cash_hand_player_statistics (cost=0.00..1796.44 rows=694 width=51) (actual time=0.010..292.911 rows=524691 loops=1) Index Cond: (id_player = $2)
10.	15.537	27.721	↑ 1.0	59065	1	→ Hash (cost=1060.65..1060.65 rows=59065 width=6) (actual time=27.721..27.721 rows=59065 loops=1) Buckets: 8192 Batches: 1 Memory Usage: 2308kB
11.	12.184	12.184	↑ 1.0	59065	1	→ Seq Scan on player player_real (cost=0.00..1060.65 rows=59065 width=6) (actual time=0.003..12.184 rows=59065 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.	1049.382	1049.382	↓ 0.0	0	524691	→ 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=524691) Index Cond: (id_session = $0) Filter: (date_start = $1)

"GroupAggregate  (cost=3673.66..3775.46 rows=11 width=63) (actual time=6291.832..6291.833 rows=1 loops=1)"
"  InitPlan 2 (returns $2)"
"    ->  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)"
"  ->  Sort  (cost=3667.38..3669.12 rows=694 width=63) (actual time=1841.823..1890.224 rows=524691 loops=1)"
"        Sort Key: cash_hand_player_statistics.id_player, player_real.id_site, public.player.player_name"
"        Sort Method:  quicksort  Memory: 98361kB"
"        ->  Hash Join  (cost=1800.68..3634.63 rows=694 width=63) (actual time=27.838..1509.263 rows=524691 loops=1)"
"              Hash Cond: (cash_hand_player_statistics.id_limit = cash_limit.id_limit)"
"              ->  Nested Loop  (cost=1798.96..3623.37 rows=694 width=58) (actual time=27.798..1321.890 rows=524691 loops=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)"
"                    ->  Hash Join  (cost=1798.96..3610.15 rows=694 width=49) (actual time=27.771..1257.846 rows=524691 loops=1)"
"                          Hash Cond: (cash_hand_player_statistics.id_player_real = player_real.id_player)"
"                          ->  Index Scan using "chps:idx2-id_player" on cash_hand_player_statistics  (cost=0.00..1796.44 rows=694 width=51) (actual time=0.010..292.911 rows=524691 loops=1)"
"                                Index Cond: (id_player = $2)"
"                          ->  Hash  (cost=1060.65..1060.65 rows=59065 width=6) (actual time=27.721..27.721 rows=59065 loops=1)"
"                                Buckets: 8192  Batches: 1  Memory Usage: 2308kB"
"                                ->  Seq Scan on player player_real  (cost=0.00..1060.65 rows=59065 width=6) (actual time=0.003..12.184 rows=59065 loops=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"
"                    ->  Seq Scan on cash_limit  (cost=0.00..1.32 rows=32 width=9) (actual time=0.005..0.015 rows=32 loops=1)"
"  SubPlan 1"
"    ->  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=524691)"
"          Index Cond: (id_session = $0)"
"          Filter: (date_start = $1)"
"Total runtime: 6298.594 ms"

Per node type stats

node type	count	sum of times	% of query
GroupAggregate	1	3352.212 ms	53.3 %
Hash	2	15.550 ms	0.2 %
Hash Join	2	1124.559 ms	17.9 %
Index Scan	4	1342.334 ms	21.3 %
Nested Loop	1	64.018 ms	1.0 %
Seq Scan	2	12.199 ms	0.2 %
Sort	1	380.961 ms	6.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
cash_hand_player_statistics	1	292.911 ms	4.7 %
Index Scan	1	292.911 ms	100.0 %
cash_limit	1	0.015 ms	0.0 %
Seq Scan	1	0.015 ms	100.0 %
cash_table_session_summary	1	1049.382 ms	16.7 %
Index Scan	1	1049.382 ms	100.0 %
player	3	12.225 ms	0.2 %
Index Scan	2	0.041 ms	0.3 %
Seq Scan	1	12.184 ms	99.7 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: jk4z

Colorize:

Columns visibility:

Per node type stats

Per table stats