explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 1Yp

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# 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)