#	exclusive	inclusive	rows x	rows	loops	node
1.	1.017	194889.527	↓ 7.6	219	1	→ Sort (cost=5975352.27..5975352.35 rows=29 width=128) (actual time=194889.514..194889.527 rows=219 loops=1) Sort Key: release_name.name Sort Method: quicksort Memory: 74kB
2.	1923.365	194888.510	↓ 7.6	219	1	→ Hash Join (cost=4418433.33..5975351.57 rows=29 width=128) (actual time=128766.805..194888.510 rows=219 loops=1) Hash Cond: (artist_credit_name.artist = artist.id)
3.	77045.248	192965.118	↑ 1.4	13918662	1	→ Hash Join (cost=4418416.53..5903619.93 rows=19123687 width=99) (actual time=99629.620..192965.118 rows=13918662 loops=1) Hash Cond: (track.recording = recording.id)
4.	13056.777	24354.107	↑ 1.0	13320091	1	→ Hash Join (cost=277973.99..851624.15 rows=13395750 width=54) (actual time=7898.848..24354.107 rows=13320091 loops=1) Hash Cond: (track.tracklist = tracklist.id)
5.	3400.940	3400.940	↓ 1.0	12302425	1	→ Seq Scan on track (cost=0.00..238994.09 rows=12302209 width=8) (actual time=0.048..3400.940 rows=12302425 loops=1)
6.	643.876	7896.390	↑ 1.0	1146834	1	→ Hash (cost=251318.56..251318.56 rows=1146834 width=58) (actual time=7896.390..7896.390 rows=1146834 loops=1) Buckets: 2048 Batches: 128 Memory Usage: 742kB
7.	1500.218	7252.514	↑ 1.0	1146834	1	→ Hash Join (cost=111319.81..251318.56 rows=1146834 width=58) (actual time=2632.367..7252.514 rows=1146834 loops=1) Hash Cond: (release.name = release_name.id)
8.	1549.514	4906.272	↑ 1.0	1146834	1	→ Hash Join (cost=77886.13..169446.66 rows=1146834 width=34) (actual time=1667.173..4906.272 rows=1146834 loops=1) Hash Cond: (medium.release = release.id)
9.	1354.739	2204.631	↑ 1.0	1146834	1	→ Hash Join (cost=33506.32..86669.25 rows=1146834 width=12) (actual time=514.516..2204.631 rows=1146834 loops=1) Hash Cond: (medium.tracklist = tracklist.id)
10.	335.974	335.974	↑ 1.0	1146834	1	→ Seq Scan on medium (cost=0.00..20018.34 rows=1146834 width=8) (actual time=0.013..335.974 rows=1146834 loops=1)
11.	316.905	513.918	↑ 1.0	1053214	1	→ Hash (cost=16226.14..16226.14 rows=1053214 width=4) (actual time=513.918..513.918 rows=1053214 loops=1) Buckets: 4096 Batches: 64 Memory Usage: 590kB
12.	197.013	197.013	↑ 1.0	1053214	1	→ Seq Scan on tracklist (cost=0.00..16226.14 rows=1053214 width=4) (actual time=0.029..197.013 rows=1053214 loops=1)
13.	649.114	1152.127	↑ 1.0	1042703	1	→ Hash (cost=24218.03..24218.03 rows=1042703 width=30) (actual time=1152.127..1152.127 rows=1042703 loops=1) Buckets: 2048 Batches: 128 Memory Usage: 494kB
14.	503.013	503.013	↑ 1.0	1042703	1	→ Seq Scan on release (cost=0.00..24218.03 rows=1042703 width=30) (actual time=0.004..503.013 rows=1042703 loops=1)
15.	566.250	846.024	↑ 1.0	899319	1	→ Hash (cost=16044.19..16044.19 rows=899319 width=32) (actual time=846.024..846.024 rows=899319 loops=1) Buckets: 2048 Batches: 64 Memory Usage: 924kB
16.	279.774	279.774	↑ 1.0	899319	1	→ Seq Scan on release_name (cost=0.00..16044.19 rows=899319 width=32) (actual time=0.004..279.774 rows=899319 loops=1)
17.	14068.839	91565.763	↑ 1.4	11805145	1	→ Hash (cost=3781854.22..3781854.22 rows=16104986 width=53) (actual time=91565.763..91565.763 rows=11805145 loops=1) Buckets: 2048 Batches: 2048 Memory Usage: 484kB
18.	17268.069	77496.924	↑ 1.4	11805145	1	→ Hash Join (cost=2925881.26..3781854.22 rows=16104986 width=53) (actual time=47726.840..77496.924 rows=11805145 loops=1) Hash Cond: (recording.name = track_name.id)
19.	3780.480	51817.816	↑ 1.4	11805145	1	→ Merge Join (cost=2708053.07..2981336.30 rows=16104986 width=32) (actual time=39315.095..51817.816 rows=11805145 loops=1) Merge Cond: (artist_credit_name.artist_credit = recording.artist_credit)
20.	1590.402	1802.878	↑ 1.0	707996	1	→ Sort (cost=99249.74..101019.73 rows=707996 width=8) (actual time=1436.012..1802.878 rows=707996 loops=1) Sort Key: artist_credit_name.artist_credit Sort Method: external merge Disk: 12448kB
21.	212.476	212.476	↑ 1.0	707996	1	→ Seq Scan on artist_credit_name (cost=0.00..11093.96 rows=707996 width=8) (actual time=0.007..212.476 rows=707996 loops=1)
22.	4210.775	46234.458	↓ 1.0	11805145	1	→ Materialize (cost=2608769.51..2665175.57 rows=11281212 width=32) (actual time=37879.070..46234.458 rows=11805145 loops=1)
23.	35046.573	42023.683	↑ 1.0	11280557	1	→ Sort (cost=2608769.51..2636972.54 rows=11281212 width=32) (actual time=37879.065..42023.683 rows=11280557 loops=1) Sort Key: recording.artist_credit Sort Method: external merge Disk: 458688kB
24.	6977.110	6977.110	↑ 1.0	11280557	1	→ Seq Scan on recording (cost=0.00..207669.12 rows=11281212 width=32) (actual time=0.010..6977.110 rows=11280557 loops=1)
25.	3379.023	8411.039	↓ 1.0	5910582	1	→ Hash (cost=103543.53..103543.53 rows=5910453 width=29) (actual time=8411.039..8411.039 rows=5910582 loops=1) Buckets: 2048 Batches: 512 Memory Usage: 731kB
26.	5032.016	5032.016	↓ 1.0	5910582	1	→ Seq Scan on track_name (cost=0.00..103543.53 rows=5910453 width=29) (actual time=0.008..5032.016 rows=5910582 loops=1)
27.	0.003	0.027	↑ 1.0	1	1	→ Hash (cost=16.78..16.78 rows=1 width=37) (actual time=0.027..0.027 rows=1 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 1kB
28.	0.005	0.024	↑ 1.0	1	1	→ Nested Loop (cost=0.00..16.78 rows=1 width=37) (actual time=0.023..0.024 rows=1 loops=1)
29.	0.012	0.012	↑ 1.0	1	1	→ Index Scan using artist_idx_gid on artist (cost=0.00..8.37 rows=1 width=24) (actual time=0.012..0.012 rows=1 loops=1) Index Cond: (gid = 'd0416e54-bd61-4498-af75-34ebf0cb84d0'::uuid)
30.	0.007	0.007	↑ 1.0	1	1	→ Index Scan using artist_name_pkey on artist_name (cost=0.00..8.40 rows=1 width=21) (actual time=0.007..0.007 rows=1 loops=1) Index Cond: (id = artist.name)

Sort  (cost=5975352.27..5975352.35 rows=29 width=128) (actual time=194889.514..194889.527 rows=219 loops=1)
  Sort Key: release_name.name
  Sort Method: quicksort  Memory: 74kB
  ->  Hash Join  (cost=4418433.33..5975351.57 rows=29 width=128) (actual time=128766.805..194888.510 rows=219 loops=1)
        Hash Cond: (artist_credit_name.artist = artist.id)
        ->  Hash Join  (cost=4418416.53..5903619.93 rows=19123687 width=99) (actual time=99629.620..192965.118 rows=13918662 loops=1)
              Hash Cond: (track.recording = recording.id)
              ->  Hash Join  (cost=277973.99..851624.15 rows=13395750 width=54) (actual time=7898.848..24354.107 rows=13320091 loops=1)
                    Hash Cond: (track.tracklist = tracklist.id)
                    ->  Seq Scan on track  (cost=0.00..238994.09 rows=12302209 width=8) (actual time=0.048..3400.940 rows=12302425 loops=1)
                    ->  Hash  (cost=251318.56..251318.56 rows=1146834 width=58) (actual time=7896.390..7896.390 rows=1146834 loops=1)
                          Buckets: 2048  Batches: 128  Memory Usage: 742kB
                          ->  Hash Join  (cost=111319.81..251318.56 rows=1146834 width=58) (actual time=2632.367..7252.514 rows=1146834 loops=1)
                                Hash Cond: (release.name = release_name.id)
                                ->  Hash Join  (cost=77886.13..169446.66 rows=1146834 width=34) (actual time=1667.173..4906.272 rows=1146834 loops=1)
                                      Hash Cond: (medium.release = release.id)
                                      ->  Hash Join  (cost=33506.32..86669.25 rows=1146834 width=12) (actual time=514.516..2204.631 rows=1146834 loops=1)
                                            Hash Cond: (medium.tracklist = tracklist.id)
                                            ->  Seq Scan on medium  (cost=0.00..20018.34 rows=1146834 width=8) (actual time=0.013..335.974 rows=1146834 loops=1)
                                            ->  Hash  (cost=16226.14..16226.14 rows=1053214 width=4) (actual time=513.918..513.918 rows=1053214 loops=1)
                                                  Buckets: 4096  Batches: 64  Memory Usage: 590kB
                                                  ->  Seq Scan on tracklist  (cost=0.00..16226.14 rows=1053214 width=4) (actual time=0.029..197.013 rows=1053214 loops=1)
                                      ->  Hash  (cost=24218.03..24218.03 rows=1042703 width=30) (actual time=1152.127..1152.127 rows=1042703 loops=1)
                                            Buckets: 2048  Batches: 128  Memory Usage: 494kB
                                            ->  Seq Scan on release  (cost=0.00..24218.03 rows=1042703 width=30) (actual time=0.004..503.013 rows=1042703 loops=1)
                                ->  Hash  (cost=16044.19..16044.19 rows=899319 width=32) (actual time=846.024..846.024 rows=899319 loops=1)
                                      Buckets: 2048  Batches: 64  Memory Usage: 924kB
                                      ->  Seq Scan on release_name  (cost=0.00..16044.19 rows=899319 width=32) (actual time=0.004..279.774 rows=899319 loops=1)
              ->  Hash  (cost=3781854.22..3781854.22 rows=16104986 width=53) (actual time=91565.763..91565.763 rows=11805145 loops=1)
                    Buckets: 2048  Batches: 2048  Memory Usage: 484kB
                    ->  Hash Join  (cost=2925881.26..3781854.22 rows=16104986 width=53) (actual time=47726.840..77496.924 rows=11805145 loops=1)
                          Hash Cond: (recording.name = track_name.id)
                          ->  Merge Join  (cost=2708053.07..2981336.30 rows=16104986 width=32) (actual time=39315.095..51817.816 rows=11805145 loops=1)
                                Merge Cond: (artist_credit_name.artist_credit = recording.artist_credit)
                                ->  Sort  (cost=99249.74..101019.73 rows=707996 width=8) (actual time=1436.012..1802.878 rows=707996 loops=1)
                                      Sort Key: artist_credit_name.artist_credit
                                      Sort Method: external merge  Disk: 12448kB
                                      ->  Seq Scan on artist_credit_name  (cost=0.00..11093.96 rows=707996 width=8) (actual time=0.007..212.476 rows=707996 loops=1)
                                ->  Materialize  (cost=2608769.51..2665175.57 rows=11281212 width=32) (actual time=37879.070..46234.458 rows=11805145 loops=1)
                                      ->  Sort  (cost=2608769.51..2636972.54 rows=11281212 width=32) (actual time=37879.065..42023.683 rows=11280557 loops=1)
                                            Sort Key: recording.artist_credit
                                            Sort Method: external merge  Disk: 458688kB
                                            ->  Seq Scan on recording  (cost=0.00..207669.12 rows=11281212 width=32) (actual time=0.010..6977.110 rows=11280557 loops=1)
                          ->  Hash  (cost=103543.53..103543.53 rows=5910453 width=29) (actual time=8411.039..8411.039 rows=5910582 loops=1)
                                Buckets: 2048  Batches: 512  Memory Usage: 731kB
                                ->  Seq Scan on track_name  (cost=0.00..103543.53 rows=5910453 width=29) (actual time=0.008..5032.016 rows=5910582 loops=1)
        ->  Hash  (cost=16.78..16.78 rows=1 width=37) (actual time=0.027..0.027 rows=1 loops=1)
              Buckets: 1024  Batches: 1  Memory Usage: 1kB
              ->  Nested Loop  (cost=0.00..16.78 rows=1 width=37) (actual time=0.023..0.024 rows=1 loops=1)
                    ->  Index Scan using artist_idx_gid on artist  (cost=0.00..8.37 rows=1 width=24) (actual time=0.012..0.012 rows=1 loops=1)
                          Index Cond: (gid = 'd0416e54-bd61-4498-af75-34ebf0cb84d0'::uuid)
                    ->  Index Scan using artist_name_pkey on artist_name  (cost=0.00..8.40 rows=1 width=21) (actual time=0.007..0.007 rows=1 loops=1)
                          Index Cond: (id = artist.name)
Total runtime: 195101.576 ms

Per node type stats

node type	count	sum of times	% of query
Hash	7	19624.010 ms	10.1 %
Hash Join	7	113697.930 ms	58.3 %
Index Scan	2	0.019 ms	0.0 %
Materialize	1	4210.775 ms	2.2 %
Merge Join	1	3780.480 ms	1.9 %
Nested Loop	1	0.005 ms	0.0 %
Seq Scan	8	16938.316 ms	8.7 %
Sort	3	36637.992 ms	18.8 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
artist	1	0.012 ms	0.0 %
Index Scan	1	0.012 ms	100.0 %
artist_credit_name	1	212.476 ms	0.1 %
Seq Scan	1	212.476 ms	100.0 %
artist_name	1	0.007 ms	0.0 %
Index Scan	1	0.007 ms	100.0 %
medium	1	335.974 ms	0.2 %
Seq Scan	1	335.974 ms	100.0 %
recording	1	6977.110 ms	3.6 %
Seq Scan	1	6977.110 ms	100.0 %
release	1	503.013 ms	0.3 %
Seq Scan	1	503.013 ms	100.0 %
release_name	1	279.774 ms	0.1 %
Seq Scan	1	279.774 ms	100.0 %
track	1	3400.940 ms	1.7 %
Seq Scan	1	3400.940 ms	100.0 %
track_name	1	5032.016 ms	2.6 %
Seq Scan	1	5032.016 ms	100.0 %
tracklist	1	197.013 ms	0.1 %
Seq Scan	1	197.013 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 1Yp

Colorize:

Columns visibility:

Per node type stats

Per table stats