#	exclusive	inclusive	rows x	rows	loops	node
1.	0.033	442.503	↓ 8.1	65	1	→ Nested Loop (cost=11358.29..11374.92 rows=8 width=16) (actual time=442.021..442.503 rows=65 loops=1)
2.	0.080	442.015	↓ 32.5	65	1	→ HashAggregate (cost=11358.29..11358.31 rows=2 width=8) (actual time=441.988..442.015 rows=65 loops=1)
3.	0.696	441.935	↓ 8.1	65	1	→ Hash Join (cost=11305.93..11358.27 rows=8 width=8) (actual time=440.322..441.935 rows=65 loops=1) Hash Cond: (t.artist_id = ntile.artist_id)
4.	27.813	426.210	↑ 1.2	2823	1	→ HashAggregate (cost=10721.59..10754.89 rows=3330 width=4) (actual time=425.219..426.210 rows=2823 loops=1)
5.	173.132	398.397	↑ 1.0	53093	1	→ Hash Join (cost=6265.80..10588.85 rows=53093 width=4) (actual time=181.988..398.397 rows=53093 loops=1) Hash Cond: (mf.track_id = t.id)
6.	43.537	43.537	↑ 1.0	53093	1	→ Seq Scan on musicfile mf (cost=0.00..2411.93 rows=53093 width=4) (actual time=0.045..43.537 rows=53093 loops=1)
7.	92.651	181.728	↓ 1.0	145690	1	→ Hash (cost=3891.02..3891.02 rows=144702 width=8) (actual time=181.728..181.728 rows=145690 loops=1) Buckets: 4096 Batches: 8 Memory Usage: 726kB
8.	89.077	89.077	↓ 1.0	145690	1	→ Seq Scan on track t (cost=0.00..3891.02 rows=144702 width=8) (actual time=0.022..89.077 rows=145690 loops=1)
9.	0.048	15.029	↓ 6.6	99	1	→ Hash (cost=584.16..584.16 rows=15 width=4) (actual time=15.029..15.029 rows=99 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 4kB
10.	0.620	14.981	↓ 6.6	99	1	→ Subquery Scan on ntile (cost=495.84..584.16 rows=15 width=4) (actual time=12.525..14.981 rows=99 loops=1) Filter: (ntile.ntile = 1)
11.	2.461	14.361	↓ 1.0	2956	1	→ WindowAgg (cost=495.84..547.36 rows=2944 width=12) (actual time=12.518..14.361 rows=2956 loops=1)
12.	3.906	11.900	↓ 1.0	2956	1	→ Sort (cost=495.84..503.20 rows=2944 width=12) (actual time=11.534..11.900 rows=2956 loops=1) Sort Key: webservice_history.invocation_time Sort Method: quicksort Memory: 235kB
13.	7.994	7.994	↓ 1.0	2956	1	→ Seq Scan on webservice_history (cost=0.00..326.21 rows=2944 width=12) (actual time=0.071..7.994 rows=2956 loops=1) Filter: (calltype_id = 2)
14.	0.455	0.455	↑ 1.0	1	65	→ Index Scan using artist_pkey on artist (cost=0.00..8.29 rows=1 width=20) (actual time=0.006..0.007 rows=1 loops=65) Index Cond: (id = ntile.artist_id)

                                                                          QUERY PLAN                                                                           
---------------------------------------------------------------------------------------------------------------------------------------------------------------
 Nested Loop  (cost=11358.29..11374.92 rows=8 width=16) (actual time=442.021..442.503 rows=65 loops=1)
   ->  HashAggregate  (cost=11358.29..11358.31 rows=2 width=8) (actual time=441.988..442.015 rows=65 loops=1)
         ->  Hash Join  (cost=11305.93..11358.27 rows=8 width=8) (actual time=440.322..441.935 rows=65 loops=1)
               Hash Cond: (t.artist_id = ntile.artist_id)
               ->  HashAggregate  (cost=10721.59..10754.89 rows=3330 width=4) (actual time=425.219..426.210 rows=2823 loops=1)
                     ->  Hash Join  (cost=6265.80..10588.85 rows=53093 width=4) (actual time=181.988..398.397 rows=53093 loops=1)
                           Hash Cond: (mf.track_id = t.id)
                           ->  Seq Scan on musicfile mf  (cost=0.00..2411.93 rows=53093 width=4) (actual time=0.045..43.537 rows=53093 loops=1)
                           ->  Hash  (cost=3891.02..3891.02 rows=144702 width=8) (actual time=181.728..181.728 rows=145690 loops=1)
                                 Buckets: 4096  Batches: 8  Memory Usage: 726kB
                                 ->  Seq Scan on track t  (cost=0.00..3891.02 rows=144702 width=8) (actual time=0.022..89.077 rows=145690 loops=1)
               ->  Hash  (cost=584.16..584.16 rows=15 width=4) (actual time=15.029..15.029 rows=99 loops=1)
                     Buckets: 1024  Batches: 1  Memory Usage: 4kB
                     ->  Subquery Scan on ntile  (cost=495.84..584.16 rows=15 width=4) (actual time=12.525..14.981 rows=99 loops=1)
                           Filter: (ntile.ntile = 1)
                           ->  WindowAgg  (cost=495.84..547.36 rows=2944 width=12) (actual time=12.518..14.361 rows=2956 loops=1)
                                 ->  Sort  (cost=495.84..503.20 rows=2944 width=12) (actual time=11.534..11.900 rows=2956 loops=1)
                                       Sort Key: webservice_history.invocation_time
                                       Sort Method: quicksort  Memory: 235kB
                                       ->  Seq Scan on webservice_history  (cost=0.00..326.21 rows=2944 width=12) (actual time=0.071..7.994 rows=2956 loops=1)
                                             Filter: (calltype_id = 2)
   ->  Index Scan using artist_pkey on artist  (cost=0.00..8.29 rows=1 width=20) (actual time=0.006..0.007 rows=1 loops=65)
         Index Cond: (id = ntile.artist_id)
 Total runtime: 443.248 ms

Per node type stats

node type	count	sum of times	% of query
Hash	2	92.699 ms	20.9 %
Hash Join	2	173.828 ms	39.3 %
HashAggregate	2	27.893 ms	6.3 %
Index Scan	1	0.455 ms	0.1 %
Nested Loop	1	0.033 ms	0.0 %
Seq Scan	3	140.608 ms	31.8 %
Sort	1	3.906 ms	0.9 %
Subquery Scan on ntile	1	0.620 ms	0.1 %
WindowAgg	1	2.461 ms	0.6 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
artist	1	0.455 ms	0.1 %
Index Scan	1	0.455 ms	100.0 %
musicfile	1	43.537 ms	9.8 %
Seq Scan	1	43.537 ms	100.0 %
track	1	89.077 ms	20.1 %
Seq Scan	1	89.077 ms	100.0 %
webservice_history	1	7.994 ms	1.8 %
Seq Scan	1	7.994 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: qCb

Colorize:

Columns visibility:

Per node type stats

Per table stats