#	exclusive	inclusive	rows x	rows	loops	node
1.	165.684	4051.468	↓ 3944.0	3944	1	→ Sort (cost=16.66..16.67 rows=1 width=445) (actual time=4045.665..4051.468 rows=3944 loops=1) Sort Key: pdsll.game_point_id, pdsll.session_id, pdsll.device_id, pdsl.log_date, pdsll.meter_id, pdsll.currency_id, pdsll.denomination_value_cg, pdsll.game_id
2.	1167.490	3885.784	↓ 3944.0	3944	1	→ Nested Loop (cost=1.03..16.65 rows=1 width=445) (actual time=0.519..3885.784 rows=3944 loops=1) Join Filter: (("outer".device_id = "inner".device_id) AND ("outer".log_date = "inner".log_date))
3.	96.491	856.726	↓ 3944.0	3944	1	→ Nested Loop (cost=1.03..10.65 rows=1 width=244) (actual time=0.469..856.726 rows=3944 loops=1) Join Filter: ("outer".meter_id = "inner".meter_id)
4.	21.684	685.299	↓ 3944.0	3944	1	→ Nested Loop (cost=1.03..9.23 rows=1 width=229) (actual time=0.456..685.299 rows=3944 loops=1) Join Filter: ("outer".currency_id = "inner".currency_id)
5.	177.238	651.783	↓ 3944.0	3944	1	→ Nested Loop (cost=1.03..8.18 rows=1 width=236) (actual time=0.443..651.783 rows=3944 loops=1) Join Filter: (("inner".currency_id = "outer".currency_id) AND ("inner".currency_date = "outer".currency_date))
6.	22.150	312.841	↓ 3944.0	3944	1	→ Nested Loop (cost=1.03..7.13 rows=1 width=221) (actual time=0.388..312.841 rows=3944 loops=1) Join Filter: ("inner".currency_id = "outer".currency_id)
7.	14.611	14.611	↓ 3944.0	3944	1	→ Index Scan using prm_device_session_lines_log_pkey on prm_device_session_line_log pdsll (cost=0.00..6.02 rows=1 width=203) (actual time=0.135..14.611 rows=3944 loops=1) Index Cond: ((game_point_id = 2000::numeric) AND (session_id = 2::numeric) AND (game_id = 0::numeric))
8.	201.144	276.080	↑ 1.0	2	3944	→ GroupAggregate (cost=1.03..1.07 rows=2 width=18) (actual time=0.032..0.070 rows=2 loops=3944)
9.	74.886	74.936	↓ 16.5	33	3944	→ Sort (cost=1.03..1.03 rows=2 width=18) (actual time=0.001..0.019 rows=33 loops=3944) Sort Key: public.scm_currency_cguitas.currency_id
10.	0.050	0.050	↓ 16.5	33	1	→ Seq Scan on scm_currency_cguitas (cost=0.00..1.02 rows=2 width=18) (actual time=0.007..0.050 rows=33 loops=1)
11.	161.704	161.704	↓ 16.5	33	3944	→ Seq Scan on scm_currency_cguitas (cost=0.00..1.02 rows=2 width=31) (actual time=0.002..0.041 rows=33 loops=3944)
12.	11.832	11.832	↑ 1.0	2	3944	→ Seq Scan on scm_currencies sc (cost=0.00..1.02 rows=2 width=23) (actual time=0.001..0.003 rows=2 loops=3944)
13.	74.936	74.936	↑ 1.0	19	3944	→ Seq Scan on acm_meters am (cost=0.00..1.19 rows=19 width=24) (actual time=0.002..0.019 rows=19 loops=3944)
14.	1861.568	1861.568	↓ 232.0	232	3944	→ Index Scan using prm_device_sessions_log_pkey on prm_device_session_log pdsl (cost=0.00..5.98 rows=1 width=248) (actual time=0.015..0.472 rows=232 loops=3944) Index Cond: ((2000::numeric = game_point_id) AND (2::numeric = session_id))

 Sort  (cost=16.66..16.67 rows=1 width=445) (actual time=4045.665..4051.468 rows=3944 loops=1)
   Sort Key: pdsll.game_point_id, pdsll.session_id, pdsll.device_id, pdsl.log_date, pdsll.meter_id, pdsll.currency_id, pdsll.denomination_value_cg, pdsll.game_id
   ->  Nested Loop  (cost=1.03..16.65 rows=1 width=445) (actual time=0.519..3885.784 rows=3944 loops=1)
         Join Filter: (("outer".device_id = "inner".device_id) AND ("outer".log_date = "inner".log_date))
         ->  Nested Loop  (cost=1.03..10.65 rows=1 width=244) (actual time=0.469..856.726 rows=3944 loops=1)
               Join Filter: ("outer".meter_id = "inner".meter_id)
               ->  Nested Loop  (cost=1.03..9.23 rows=1 width=229) (actual time=0.456..685.299 rows=3944 loops=1)
                     Join Filter: ("outer".currency_id = "inner".currency_id)
                     ->  Nested Loop  (cost=1.03..8.18 rows=1 width=236) (actual time=0.443..651.783 rows=3944 loops=1)
                           Join Filter: (("inner".currency_id = "outer".currency_id) AND ("inner".currency_date = "outer".currency_date))
                           ->  Nested Loop  (cost=1.03..7.13 rows=1 width=221) (actual time=0.388..312.841 rows=3944 loops=1)
                                 Join Filter: ("inner".currency_id = "outer".currency_id)
                                 ->  Index Scan using prm_device_session_lines_log_pkey on prm_device_session_line_log pdsll  (cost=0.00..6.02 rows=1 width=203) (actual time=0.135..14.611 rows=3944 loops=1)
                                       Index Cond: ((game_point_id = 2000::numeric) AND (session_id = 2::numeric) AND (game_id = 0::numeric))
                                 ->  GroupAggregate  (cost=1.03..1.07 rows=2 width=18) (actual time=0.032..0.070 rows=2 loops=3944)
                                       ->  Sort  (cost=1.03..1.03 rows=2 width=18) (actual time=0.001..0.019 rows=33 loops=3944)
                                             Sort Key: public.scm_currency_cguitas.currency_id
                                             ->  Seq Scan on scm_currency_cguitas  (cost=0.00..1.02 rows=2 width=18) (actual time=0.007..0.050 rows=33 loops=1)
                           ->  Seq Scan on scm_currency_cguitas  (cost=0.00..1.02 rows=2 width=31) (actual time=0.002..0.041 rows=33 loops=3944)
                     ->  Seq Scan on scm_currencies sc  (cost=0.00..1.02 rows=2 width=23) (actual time=0.001..0.003 rows=2 loops=3944)
               ->  Seq Scan on acm_meters am  (cost=0.00..1.19 rows=19 width=24) (actual time=0.002..0.019 rows=19 loops=3944)
         ->  Index Scan using prm_device_sessions_log_pkey on prm_device_session_log pdsl  (cost=0.00..5.98 rows=1 width=248) (actual time=0.015..0.472 rows=232 loops=3944)
               Index Cond: ((2000::numeric = game_point_id) AND (2::numeric = session_id))
 Total runtime: 4054.718 ms

Per node type stats

node type	count	sum of times	% of query
GroupAggregate	1	201.144 ms	5.0 %
Index Scan	2	1876.179 ms	46.3 %
Nested Loop	5	1485.053 ms	36.7 %
Seq Scan	4	248.522 ms	6.1 %
Sort	2	240.570 ms	5.9 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
acm_meters	1	74.936 ms	1.8 %
Seq Scan	1	74.936 ms	100.0 %
prm_device_session_line_log	1	14.611 ms	0.4 %
Index Scan	1	14.611 ms	100.0 %
prm_device_session_log	1	1861.568 ms	45.9 %
Index Scan	1	1861.568 ms	100.0 %
scm_currencies	1	11.832 ms	0.3 %
Seq Scan	1	11.832 ms	100.0 %
scm_currency_cguitas	2	161.754 ms	4.0 %
Seq Scan	2	161.754 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: QCg

Colorize:

Columns visibility:

Per node type stats

Per table stats