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 194,889.527 ↓ 7.6 219 1

Sort (cost=5,975,352.27..5,975,352.35 rows=29 width=128) (actual time=194,889.514..194,889.527 rows=219 loops=1)

  • Sort Key: release_name.name
  • Sort Method: quicksort Memory: 74kB
2. 1,923.365 194,888.510 ↓ 7.6 219 1

Hash Join (cost=4,418,433.33..5,975,351.57 rows=29 width=128) (actual time=128,766.805..194,888.510 rows=219 loops=1)

  • Hash Cond: (artist_credit_name.artist = artist.id)
3. 77,045.248 192,965.118 ↑ 1.4 13,918,662 1

Hash Join (cost=4,418,416.53..5,903,619.93 rows=19,123,687 width=99) (actual time=99,629.620..192,965.118 rows=13,918,662 loops=1)

  • Hash Cond: (track.recording = recording.id)
4. 13,056.777 24,354.107 ↑ 1.0 13,320,091 1

Hash Join (cost=277,973.99..851,624.15 rows=13,395,750 width=54) (actual time=7,898.848..24,354.107 rows=13,320,091 loops=1)

  • Hash Cond: (track.tracklist = tracklist.id)
5. 3,400.940 3,400.940 ↓ 1.0 12,302,425 1

Seq Scan on track (cost=0.00..238,994.09 rows=12,302,209 width=8) (actual time=0.048..3,400.940 rows=12,302,425 loops=1)

6. 643.876 7,896.390 ↑ 1.0 1,146,834 1

Hash (cost=251,318.56..251,318.56 rows=1,146,834 width=58) (actual time=7,896.390..7,896.390 rows=1,146,834 loops=1)

  • Buckets: 2048 Batches: 128 Memory Usage: 742kB
7. 1,500.218 7,252.514 ↑ 1.0 1,146,834 1

Hash Join (cost=111,319.81..251,318.56 rows=1,146,834 width=58) (actual time=2,632.367..7,252.514 rows=1,146,834 loops=1)

  • Hash Cond: (release.name = release_name.id)
8. 1,549.514 4,906.272 ↑ 1.0 1,146,834 1

Hash Join (cost=77,886.13..169,446.66 rows=1,146,834 width=34) (actual time=1,667.173..4,906.272 rows=1,146,834 loops=1)

  • Hash Cond: (medium.release = release.id)
9. 1,354.739 2,204.631 ↑ 1.0 1,146,834 1

Hash Join (cost=33,506.32..86,669.25 rows=1,146,834 width=12) (actual time=514.516..2,204.631 rows=1,146,834 loops=1)

  • Hash Cond: (medium.tracklist = tracklist.id)
10. 335.974 335.974 ↑ 1.0 1,146,834 1

Seq Scan on medium (cost=0.00..20,018.34 rows=1,146,834 width=8) (actual time=0.013..335.974 rows=1,146,834 loops=1)

11. 316.905 513.918 ↑ 1.0 1,053,214 1

Hash (cost=16,226.14..16,226.14 rows=1,053,214 width=4) (actual time=513.918..513.918 rows=1,053,214 loops=1)

  • Buckets: 4096 Batches: 64 Memory Usage: 590kB
12. 197.013 197.013 ↑ 1.0 1,053,214 1

Seq Scan on tracklist (cost=0.00..16,226.14 rows=1,053,214 width=4) (actual time=0.029..197.013 rows=1,053,214 loops=1)

13. 649.114 1,152.127 ↑ 1.0 1,042,703 1

Hash (cost=24,218.03..24,218.03 rows=1,042,703 width=30) (actual time=1,152.127..1,152.127 rows=1,042,703 loops=1)

  • Buckets: 2048 Batches: 128 Memory Usage: 494kB
14. 503.013 503.013 ↑ 1.0 1,042,703 1

Seq Scan on release (cost=0.00..24,218.03 rows=1,042,703 width=30) (actual time=0.004..503.013 rows=1,042,703 loops=1)

15. 566.250 846.024 ↑ 1.0 899,319 1

Hash (cost=16,044.19..16,044.19 rows=899,319 width=32) (actual time=846.024..846.024 rows=899,319 loops=1)

  • Buckets: 2048 Batches: 64 Memory Usage: 924kB
16. 279.774 279.774 ↑ 1.0 899,319 1

Seq Scan on release_name (cost=0.00..16,044.19 rows=899,319 width=32) (actual time=0.004..279.774 rows=899,319 loops=1)

17. 14,068.839 91,565.763 ↑ 1.4 11,805,145 1

Hash (cost=3,781,854.22..3,781,854.22 rows=16,104,986 width=53) (actual time=91,565.763..91,565.763 rows=11,805,145 loops=1)

  • Buckets: 2048 Batches: 2048 Memory Usage: 484kB
18. 17,268.069 77,496.924 ↑ 1.4 11,805,145 1

Hash Join (cost=2,925,881.26..3,781,854.22 rows=16,104,986 width=53) (actual time=47,726.840..77,496.924 rows=11,805,145 loops=1)

  • Hash Cond: (recording.name = track_name.id)
19. 3,780.480 51,817.816 ↑ 1.4 11,805,145 1

Merge Join (cost=2,708,053.07..2,981,336.30 rows=16,104,986 width=32) (actual time=39,315.095..51,817.816 rows=11,805,145 loops=1)

  • Merge Cond: (artist_credit_name.artist_credit = recording.artist_credit)
20. 1,590.402 1,802.878 ↑ 1.0 707,996 1

Sort (cost=99,249.74..101,019.73 rows=707,996 width=8) (actual time=1,436.012..1,802.878 rows=707,996 loops=1)

  • Sort Key: artist_credit_name.artist_credit
  • Sort Method: external merge Disk: 12448kB
21. 212.476 212.476 ↑ 1.0 707,996 1

Seq Scan on artist_credit_name (cost=0.00..11,093.96 rows=707,996 width=8) (actual time=0.007..212.476 rows=707,996 loops=1)

22. 4,210.775 46,234.458 ↓ 1.0 11,805,145 1

Materialize (cost=2,608,769.51..2,665,175.57 rows=11,281,212 width=32) (actual time=37,879.070..46,234.458 rows=11,805,145 loops=1)

23. 35,046.573 42,023.683 ↑ 1.0 11,280,557 1

Sort (cost=2,608,769.51..2,636,972.54 rows=11,281,212 width=32) (actual time=37,879.065..42,023.683 rows=11,280,557 loops=1)

  • Sort Key: recording.artist_credit
  • Sort Method: external merge Disk: 458688kB
24. 6,977.110 6,977.110 ↑ 1.0 11,280,557 1

Seq Scan on recording (cost=0.00..207,669.12 rows=11,281,212 width=32) (actual time=0.010..6,977.110 rows=11,280,557 loops=1)

25. 3,379.023 8,411.039 ↓ 1.0 5,910,582 1

Hash (cost=103,543.53..103,543.53 rows=5,910,453 width=29) (actual time=8,411.039..8,411.039 rows=5,910,582 loops=1)

  • Buckets: 2048 Batches: 512 Memory Usage: 731kB
26. 5,032.016 5,032.016 ↓ 1.0 5,910,582 1

Seq Scan on track_name (cost=0.00..103,543.53 rows=5,910,453 width=29) (actual time=0.008..5,032.016 rows=5,910,582 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)