explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uGko

Settings
# exclusive inclusive rows x rows loops node
1. 35.244 122,293.514 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=5,602.57..32,882.54 rows=1 width=660) (actual time=53.274..122,293.514 rows=1,000 loops=1)

2. 2.930 325.704 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=5,602.15..5,625.86 rows=1 width=840) (actual time=38.591..325.704 rows=1,000 loops=1)

3. 2.545 249.774 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=5,601.73..5,625.29 rows=1 width=645) (actual time=38.585..249.774 rows=1,000 loops=1)

4. 2.216 234.229 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=5,601.31..5,624.78 rows=1 width=641) (actual time=38.578..234.229 rows=1,000 loops=1)

  • Join Filter: (it_accounts.id = it_collections.it_account_id)
  • Rows Removed by Join Filter: 10
5. 2.445 223.013 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=5,601.02..5,624.37 rows=1 width=491) (actual time=38.570..223.013 rows=1,000 loops=1)

6. 78.223 216.568 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=5,600.73..5,624.04 rows=1 width=487) (actual time=38.557..216.568 rows=1,000 loops=1)

7. 50.399 133.345 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=21.06..36.35 rows=1 width=354) (actual time=38.484..133.345 rows=1,000 loops=1)

8. 3.983 78.946 ↓ 1,000.0 1,000 1

Nested Loop (cost=0.42..7.70 rows=1 width=112) (actual time=38.363..78.946 rows=1,000 loops=1)

  • Join Filter: (occ_chart_editions.occ_chart_source_id = occ_chart_sources.id)
9. 11.551 72.963 ↓ 1,000.0 1,000 1

Nested Loop (cost=0.42..6.68 rows=1 width=120) (actual time=38.350..72.963 rows=1,000 loops=1)

10. 52.412 52.412 ↓ 1,000.0 1,000 1

Index Scan using index_occ_chart_listings_on_occ_chart_edition_id on occ_chart_listings (cost=0.42..4.48 rows=1 width=112) (actual time=38.322..52.412 rows=1,000 loops=1)

  • Index Cond: (occ_chart_edition_id = 17)
  • Filter: (("position" >= 11,000) AND ("position" <= 11,999))
  • Rows Removed by Filter: 49,000
11. 9.000 9.000 ↑ 1.0 1 1,000

Seq Scan on occ_chart_editions (cost=0.00..2.19 rows=1 width=16) (actual time=0.008..0.009 rows=1 loops=1,000)

  • Filter: (id = 17)
  • Rows Removed by Filter: 14
12. 2.000 2.000 ↑ 1.0 1 1,000

Seq Scan on occ_chart_sources (cost=0.00..1.01 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1,000)

13. 0.000 4.000 ↓ 0.0 0 1,000

Index Scan using it_songs_pkey on it_songs (cost=20.63..28.65 rows=1 width=242) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Index Cond: (id = (SubPlan 15))
14.          

SubPlan (for Index Scan)

15. 2.000 45.000 ↓ 0.0 0 1,000

Limit (cost=20.21..20.22 rows=1 width=8) (actual time=0.045..0.045 rows=0 loops=1,000)

16. 9.000 43.000 ↓ 0.0 0 1,000

Sort (cost=20.21..20.22 rows=4 width=8) (actual time=0.043..0.043 rows=0 loops=1,000)

  • Sort Key: (char_length((it_songs_2.composer_names)::text)) DESC NULLS LAST
  • Sort Method: quicksort Memory: 25kB
17. 3.000 34.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on it_songs it_songs_2 (cost=4.46..20.19 rows=4 width=8) (actual time=0.033..0.034 rows=0 loops=1,000)

  • Recheck Cond: ((isrc IS NOT NULL) AND ((isrc)::text = (COALESCE(occ_chart_listings.expected_isrc, occ_chart_listings.primary_isrc))::text))
  • Heap Blocks: exact=114
18. 31.000 31.000 ↓ 0.0 0 1,000

Bitmap Index Scan on index_it_songs_on_isrc (cost=0.00..4.46 rows=4 width=0) (actual time=0.031..0.031 rows=0 loops=1,000)

  • Index Cond: ((isrc IS NOT NULL) AND ((isrc)::text = (COALESCE(occ_chart_listings.expected_isrc, occ_chart_listings.primary_isrc))::text))
19. 0.000 5.000 ↓ 0.0 0 1,000

Index Scan using sp_tracks_pkey on sp_tracks (cost=5,579.67..5,587.69 rows=1 width=133) (actual time=0.005..0.005 rows=0 loops=1,000)

  • Index Cond: (id = (SubPlan 16))
20.          

SubPlan (for Index Scan)

21. 2.000 74.000 ↓ 0.0 0 1,000

Limit (cost=5,579.24..5,579.25 rows=1 width=8) (actual time=0.073..0.074 rows=0 loops=1,000)

22. 7.000 72.000 ↓ 0.0 0 1,000

Sort (cost=5,579.24..5,584.28 rows=2,014 width=8) (actual time=0.072..0.072 rows=0 loops=1,000)

  • Sort Key: sp_tracks_2.popularity DESC NULLS LAST
  • Sort Method: quicksort Memory: 25kB
23. 6.000 65.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on sp_tracks sp_tracks_2 (cost=48.05..5,569.17 rows=2,014 width=8) (actual time=0.065..0.065 rows=0 loops=1,000)

  • Recheck Cond: ((upper(replace((isrc)::text, '-'::text, ''::text)))::citext = (COALESCE(occ_chart_listings.expected_isrc, occ_chart_listings.primary_isrc))::citext)
  • Filter: (isrc IS NOT NULL)
  • Heap Blocks: exact=411
24. 59.000 59.000 ↓ 0.0 0 1,000

Bitmap Index Scan on index_sp_tracks_on_sanitized_isrc (cost=0.00..47.54 rows=2,016 width=0) (actual time=0.059..0.059 rows=0 loops=1,000)

  • Index Cond: ((upper(replace((isrc)::text, '-'::text, ''::text)))::citext = (COALESCE(occ_chart_listings.expected_isrc, occ_chart_listings.primary_isrc))::citext)
25. 4.000 4.000 ↓ 0.0 0 1,000

Index Scan using it_accounts_pkey on it_accounts (cost=0.29..0.33 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1,000)

  • Index Cond: (it_songs.it_account_id = id)
26. 9.000 9.000 ↓ 0.0 0 1,000

Index Scan using it_collections_pkey on it_collections (cost=0.29..0.40 rows=1 width=162) (actual time=0.009..0.009 rows=0 loops=1,000)

  • Index Cond: (id = it_songs.it_collection_id)
27. 13.000 13.000 ↓ 0.0 0 1,000

Index Scan using index_sp_account_tracks_on_sp_track_id_and_primary on sp_account_tracks (cost=0.42..0.50 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=1,000)

  • Index Cond: (sp_track_id = sp_tracks.id)
  • Filter: (NOT inactive)
28. 73.000 73.000 ↓ 0.0 0 1,000

Index Scan using sp_accounts_pkey on sp_accounts (cost=0.42..0.57 rows=1 width=199) (actual time=0.073..0.073 rows=0 loops=1,000)

  • Index Cond: (id = sp_account_tracks.sp_account_id)
29. 1.000 1.000 ↓ 0.0 0 1,000

Index Scan using artists_pkey on artists (cost=0.42..1.27 rows=1 width=353) (actual time=0.001..0.001 rows=0 loops=1,000)

  • Index Cond: (id = it_accounts.artist_id)
30.          

SubPlan (for Nested Loop Left Join)

31. 40.000 174.000 ↑ 1.0 1 1,000

Aggregate (cost=50.34..50.35 rows=1 width=8) (actual time=0.174..0.174 rows=1 loops=1,000)

32. 9.424 134.000 ↓ 1.2 5 1,000

Nested Loop (cost=0.85..50.33 rows=4 width=36) (actual time=0.024..0.134 rows=5 loops=1,000)

33. 65.000 65.000 ↓ 1.2 5 1,000

Index Scan using index_sp_account_tracks_on_sp_account_id on sp_account_tracks sp_account_tracks_1 (cost=0.42..16.57 rows=4 width=4) (actual time=0.017..0.065 rows=5 loops=1,000)

  • Index Cond: (sp_account_id = sp_accounts.id)
  • Filter: ("primary" AND (NOT inactive))
  • Rows Removed by Filter: 2
34. 59.576 59.576 ↑ 1.0 1 5,416

Index Scan using sp_tracks_pkey on sp_tracks sp_tracks_1 (cost=0.42..8.44 rows=1 width=40) (actual time=0.011..0.011 rows=1 loops=5,416)

  • Index Cond: (id = sp_account_tracks_1.sp_track_id)
35. 17.000 29.000 ↑ 1.0 1 1,000

Aggregate (cost=53.03..53.04 rows=1 width=8) (actual time=0.029..0.029 rows=1 loops=1,000)

36. 12.000 12.000 ↑ 4.7 3 1,000

Index Scan using index_it_songs_on_it_account_id on it_songs it_songs_1 (cost=0.42..52.89 rows=14 width=17) (actual time=0.002..0.012 rows=3 loops=1,000)

  • Index Cond: (it_account_id = it_accounts.id)
37. 15.000 120,245.000 ↑ 1.0 1 1,000

Aggregate (cost=26,820.74..26,820.75 rows=1 width=8) (actual time=120.245..120.245 rows=1 loops=1,000)

38. 80.000 120,230.000 ↑ 3,755.0 1 1,000

HashAggregate (cost=26,736.25..26,773.80 rows=3,755 width=8) (actual time=120.202..120.230 rows=1 loops=1,000)

  • Group Key: sp_playlists.id, sp_playlists.followers_count
39. 2.000 120,150.000 ↑ 1,877.5 2 1,000

Append (cost=0.99..26,717.47 rows=3,755 width=8) (actual time=1.949..120.150 rows=2 loops=1,000)

40. 2.586 38.000 ↑ 5.0 1 1,000

Nested Loop (cost=0.99..58.66 rows=5 width=8) (actual time=0.026..0.038 rows=1 loops=1,000)

41. 2.635 29.000 ↑ 5.0 1 1,000

Nested Loop (cost=0.71..55.68 rows=5 width=4) (actual time=0.022..0.029 rows=1 loops=1,000)

42. 21.000 21.000 ↑ 5.0 1 1,000

Index Scan using index_sp_playlist_listings_on_sp_track_id on sp_playlist_listings (cost=0.42..14.18 rows=5 width=4) (actual time=0.017..0.021 rows=1 loops=1,000)

  • Index Cond: (sp_track_id = sp_tracks.id)
43. 5.365 5.365 ↑ 1.0 1 1,073

Index Scan using sp_playlist_editions_pkey on sp_playlist_editions (cost=0.28..8.30 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=1,073)

  • Index Cond: (id = sp_playlist_listings.sp_playlist_edition_id)
  • Filter: current
  • Rows Removed by Filter: 0
44. 6.414 6.414 ↑ 1.0 1 1,069

Index Scan using sp_playlists_pkey on sp_playlists (cost=0.29..0.60 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=1,069)

  • Index Cond: (id = sp_playlist_editions.sp_playlist_id)
45. 3.336 120,110.000 ↑ 3,750.0 1 1,000

Hash Join (cost=6,526.91..26,621.26 rows=3,750 width=8) (actual time=40.811..120.110 rows=1 loops=1,000)

  • Hash Cond: (sp_playlist_editions_1.sp_playlist_id = sp_playlists_1.id)
46. 7.720 120,099.000 ↑ 3,750.0 1 1,000

Hash Join (cost=5,833.39..25,917.89 rows=3,750 width=4) (actual time=40.802..120.099 rows=1 loops=1,000)

  • Hash Cond: (sp_playlist_listings_1.sp_playlist_edition_id = sp_playlist_editions_1.id)
47. 69,223.504 120,087.000 ↑ 3,876.0 1 1,000

Hash Join (cost=5,604.43..25,678.76 rows=3,876 width=4) (actual time=40.738..120.087 rows=1 loops=1,000)

  • Hash Cond: (sp_playlist_listings_1.sp_track_id = s.id)
48. 50,843.496 50,843.496 ↑ 1.0 773,873 348

Seq Scan on sp_playlist_listings sp_playlist_listings_1 (cost=0.00..18,037.03 rows=776,103 width=8) (actual time=0.005..146.102 rows=773,873 loops=348)

49. 3.000 20.000 ↓ 0.0 0 1,000

Hash (cost=5,579.26..5,579.26 rows=2,014 width=4) (actual time=0.020..0.020 rows=0 loops=1,000)

  • Buckets: 2,048 Batches: 1 Memory Usage: 16kB
50. 4.000 17.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on sp_tracks s (cost=48.05..5,579.26 rows=2,014 width=4) (actual time=0.017..0.017 rows=0 loops=1,000)

  • Recheck Cond: ((upper(replace((isrc)::text, '-'::text, ''::text)))::citext = (upper(replace((sp_tracks.isrc)::text, '-'::text, ''::text)))::citext)
  • Filter: (isrc IS NOT NULL)
  • Heap Blocks: exact=411
51. 13.000 13.000 ↓ 0.0 0 1,000

Bitmap Index Scan on index_sp_tracks_on_sanitized_isrc (cost=0.00..47.55 rows=2,016 width=0) (actual time=0.013..0.013 rows=0 loops=1,000)

  • Index Cond: ((upper(replace((isrc)::text, '-'::text, ''::text)))::citext = (upper(replace((sp_tracks.isrc)::text, '-'::text, ''::text)))::citext)
52. 2.041 4.280 ↑ 1.0 6,829 1

Hash (cost=143.59..143.59 rows=6,829 width=8) (actual time=4.280..4.280 rows=6,829 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 331kB
53. 2.239 2.239 ↑ 1.0 6,829 1

Seq Scan on sp_playlist_editions sp_playlist_editions_1 (cost=0.00..143.59 rows=6,829 width=8) (actual time=0.023..2.239 rows=6,829 loops=1)

  • Filter: current
  • Rows Removed by Filter: 230
54. 2.750 7.664 ↑ 1.0 9,890 1

Hash (cost=569.90..569.90 rows=9,890 width=8) (actual time=7.664..7.664 rows=9,890 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 503kB
55. 4.914 4.914 ↑ 1.0 9,890 1

Seq Scan on sp_playlists sp_playlists_1 (cost=0.00..569.90 rows=9,890 width=8) (actual time=0.016..4.914 rows=9,890 loops=1)

56. 4.000 113.000 ↑ 1.0 1 1,000

Limit (cost=0.42..8.45 rows=1 width=4) (actual time=0.112..0.113 rows=1 loops=1,000)

57. 109.000 109.000 ↑ 1.0 1 1,000

Index Scan using index_occ_chart_listings_on_edition_id_and_isrc on occ_chart_listings ocl (cost=0.42..8.45 rows=1 width=4) (actual time=0.109..0.109 rows=1 loops=1,000)

  • Index Cond: ((occ_chart_edition_id = 16) AND (primary_isrc IS NOT NULL) AND ((primary_isrc)::text = (occ_chart_listings.primary_isrc)::text))
58. 21.000 956.000 ↑ 1.0 1 1,000

Aggregate (cost=56.10..56.11 rows=1 width=4) (actual time=0.955..0.956 rows=1 loops=1,000)

59. 697.000 935.000 ↓ 1.1 14 1,000

Bitmap Heap Scan on occ_chart_listings ocl_1 (cost=4.56..56.07 rows=13 width=4) (actual time=0.309..0.935 rows=14 loops=1,000)

  • Recheck Cond: ((primary_isrc IS NOT NULL) AND ((primary_isrc)::text = (occ_chart_listings.primary_isrc)::text))
  • Filter: (occ_chart_edition_id = ANY ('{3,4,5,6,7,8,9,10,11,12,13,14,15,16,17}'::bigint[]))
  • Heap Blocks: exact=14,082
60. 238.000 238.000 ↓ 1.1 14 1,000

Bitmap Index Scan on index_occ_chart_listings_on_isrc_and_year_week (cost=0.00..4.55 rows=13 width=0) (actual time=0.238..0.238 rows=14 loops=1,000)

  • Index Cond: ((primary_isrc IS NOT NULL) AND ((primary_isrc)::text = (occ_chart_listings.primary_isrc)::text))
61. 9.000 77.000 ↑ 1.0 1 1,000

Aggregate (cost=56.10..56.11 rows=1 width=8) (actual time=0.077..0.077 rows=1 loops=1,000)

62. 25.000 68.000 ↓ 1.1 14 1,000

Bitmap Heap Scan on occ_chart_listings ocl_2 (cost=4.56..56.07 rows=13 width=0) (actual time=0.050..0.068 rows=14 loops=1,000)

  • Recheck Cond: ((primary_isrc IS NOT NULL) AND ((primary_isrc)::text = (occ_chart_listings.primary_isrc)::text))
  • Filter: (occ_chart_edition_id = ANY ('{3,4,5,6,7,8,9,10,11,12,13,14,15,16,17}'::bigint[]))
  • Heap Blocks: exact=14,082
63. 43.000 43.000 ↓ 1.1 14 1,000

Bitmap Index Scan on index_occ_chart_listings_on_isrc_and_year_week (cost=0.00..4.55 rows=13 width=0) (actual time=0.043..0.043 rows=14 loops=1,000)

  • Index Cond: ((primary_isrc IS NOT NULL) AND ((primary_isrc)::text = (occ_chart_listings.primary_isrc)::text))
64. 2.000 30.000 ↑ 1.0 1 1,000

Limit (cost=0.42..8.45 rows=1 width=4) (actual time=0.030..0.030 rows=1 loops=1,000)

65. 28.000 28.000 ↑ 1.0 1 1,000

Index Scan using index_occ_chart_listings_on_edition_id_and_isrc on occ_chart_listings ocl_3 (cost=0.42..8.45 rows=1 width=4) (actual time=0.028..0.028 rows=1 loops=1,000)

  • Index Cond: ((occ_chart_edition_id = 16) AND (primary_isrc IS NOT NULL) AND ((primary_isrc)::text = (occ_chart_listings.primary_isrc)::text))
66. 9.000 60.000 ↑ 1.0 1 1,000

Aggregate (cost=56.10..56.11 rows=1 width=4) (actual time=0.060..0.060 rows=1 loops=1,000)

67. 22.000 51.000 ↓ 1.1 14 1,000

Bitmap Heap Scan on occ_chart_listings ocl_4 (cost=4.56..56.07 rows=13 width=4) (actual time=0.035..0.051 rows=14 loops=1,000)

  • Recheck Cond: ((primary_isrc IS NOT NULL) AND ((primary_isrc)::text = (occ_chart_listings.primary_isrc)::text))
  • Filter: (occ_chart_edition_id = ANY ('{3,4,5,6,7,8,9,10,11,12,13,14,15,16,17}'::bigint[]))
  • Heap Blocks: exact=14,082
68. 29.000 29.000 ↓ 1.1 14 1,000

Bitmap Index Scan on index_occ_chart_listings_on_isrc_and_year_week (cost=0.00..4.55 rows=13 width=0) (actual time=0.029..0.029 rows=14 loops=1,000)

  • Index Cond: ((primary_isrc IS NOT NULL) AND ((primary_isrc)::text = (occ_chart_listings.primary_isrc)::text))
69. 2.000 26.000 ↑ 1.0 1 1,000

Limit (cost=0.42..8.45 rows=1 width=4) (actual time=0.025..0.026 rows=1 loops=1,000)

70. 24.000 24.000 ↑ 1.0 1 1,000

Index Scan using index_occ_chart_listings_on_edition_id_and_isrc on occ_chart_listings ocl_5 (cost=0.42..8.45 rows=1 width=4) (actual time=0.024..0.024 rows=1 loops=1,000)

  • Index Cond: ((occ_chart_edition_id = 16) AND (primary_isrc IS NOT NULL) AND ((primary_isrc)::text = (occ_chart_listings.primary_isrc)::text))
71. 1.000 23.000 ↑ 1.0 1 1,000

Limit (cost=0.42..8.45 rows=1 width=4) (actual time=0.023..0.023 rows=1 loops=1,000)

72. 22.000 22.000 ↑ 1.0 1 1,000

Index Scan using index_occ_chart_listings_on_edition_id_and_isrc on occ_chart_listings ocl_6 (cost=0.42..8.45 rows=1 width=4) (actual time=0.022..0.022 rows=1 loops=1,000)

  • Index Cond: ((occ_chart_edition_id = 16) AND (primary_isrc IS NOT NULL) AND ((primary_isrc)::text = (occ_chart_listings.primary_isrc)::text))
73. 7.000 53.000 ↑ 1.0 1 1,000

Aggregate (cost=56.10..56.11 rows=1 width=8) (actual time=0.053..0.053 rows=1 loops=1,000)

74. 20.000 46.000 ↓ 1.1 14 1,000

Bitmap Heap Scan on occ_chart_listings ocl_7 (cost=4.56..56.07 rows=13 width=0) (actual time=0.031..0.046 rows=14 loops=1,000)

  • Recheck Cond: ((primary_isrc IS NOT NULL) AND ((primary_isrc)::text = (occ_chart_listings.primary_isrc)::text))
  • Filter: (occ_chart_edition_id = ANY ('{3,4,5,6,7,8,9,10,11,12,13,14,15,16,17}'::bigint[]))
  • Heap Blocks: exact=14,082
75. 26.000 26.000 ↓ 1.1 14 1,000

Bitmap Index Scan on index_occ_chart_listings_on_isrc_and_year_week (cost=0.00..4.55 rows=13 width=0) (actual time=0.026..0.026 rows=14 loops=1,000)

  • Index Cond: ((primary_isrc IS NOT NULL) AND ((primary_isrc)::text = (occ_chart_listings.primary_isrc)::text))
76. 1.986 36.741 ↑ 1.0 1 993

Limit (cost=0.42..8.45 rows=1 width=4) (actual time=0.037..0.037 rows=1 loops=993)

77. 34.755 34.755 ↑ 1.0 1 993

Index Scan using index_occ_chart_listings_on_edition_id_and_isrc on occ_chart_listings ocl_8 (cost=0.42..8.45 rows=1 width=4) (actual time=0.035..0.035 rows=1 loops=993)

  • Index Cond: ((occ_chart_edition_id = 16) AND (primary_isrc IS NOT NULL) AND ((primary_isrc)::text = (occ_chart_listings.primary_isrc)::text))
78. 6.000 84.000 ↑ 1.0 1 1,000

Aggregate (cost=56.10..56.11 rows=1 width=8) (actual time=0.084..0.084 rows=1 loops=1,000)

79. 19.000 78.000 ↓ 1.1 14 1,000

Bitmap Heap Scan on occ_chart_listings ocl_9 (cost=4.56..56.07 rows=13 width=0) (actual time=0.063..0.078 rows=14 loops=1,000)

  • Recheck Cond: ((primary_isrc IS NOT NULL) AND ((primary_isrc)::text = (occ_chart_listings.primary_isrc)::text))
  • Filter: (occ_chart_edition_id = ANY ('{3,4,5,6,7,8,9,10,11,12,13,14,15,16,17}'::bigint[]))
  • Heap Blocks: exact=14,082
80. 59.000 59.000 ↓ 1.1 14 1,000

Bitmap Index Scan on index_occ_chart_listings_on_isrc_and_year_week (cost=0.00..4.55 rows=13 width=0) (actual time=0.059..0.059 rows=14 loops=1,000)

  • Index Cond: ((primary_isrc IS NOT NULL) AND ((primary_isrc)::text = (occ_chart_listings.primary_isrc)::text))
81. 1.986 24.825 ↑ 1.0 1 993

Limit (cost=0.42..8.45 rows=1 width=4) (actual time=0.024..0.025 rows=1 loops=993)

82. 22.839 22.839 ↑ 1.0 1 993

Index Scan using index_occ_chart_listings_on_edition_id_and_isrc on occ_chart_listings ocl_10 (cost=0.42..8.45 rows=1 width=4) (actual time=0.023..0.023 rows=1 loops=993)

  • Index Cond: ((occ_chart_edition_id = 16) AND (primary_isrc IS NOT NULL) AND ((primary_isrc)::text = (occ_chart_listings.primary_isrc)::text))
Planning time : 12.889 ms
Execution time : 122,295.506 ms