explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NgpW : changed statement on 12b

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 10,038.567 ↑ 303.0 33 1

Limit (cost=779,875.13..779,900.13 rows=10,000 width=688) (actual time=10,038.564..10,038.567 rows=33 loops=1)

2. 0.134 10,038.563 ↑ 7,453.8 33 1

Sort (cost=779,875.13..780,490.07 rows=245,974 width=688) (actual time=10,038.562..10,038.563 rows=33 loops=1)

  • Sort Key: (CASE WHEN (hashed SubPlan 1) THEN 0 ELSE 1 END), (COALESCE(s.ww_cume_rev, '-1'::numeric)) DESC, (COALESCE(s.domestic_release_date, '1901-01-01'::date)) DESC
  • Sort Method: quicksort Memory: 37kB
3. 0.041 10,038.429 ↑ 7,453.8 33 1

Subquery Scan on s (cost=756,768.69..762,303.10 rows=245,974 width=688) (actual time=10,036.548..10,038.429 rows=33 loops=1)

4. 2.835 9,527.511 ↑ 7,453.8 33 1

HashAggregate (cost=704,442.79..706,902.53 rows=245,974 width=652) (actual time=9,525.645..9,527.511 rows=33 loops=1)

  • Group Key: rs_releases_summary.title_no, ti_titles.title_no
5. 0.809 9,524.676 ↑ 342.1 719 1

Hash Left Join (cost=657,411.58..685,994.74 rows=245,974 width=654) (actual time=9,454.226..9,524.676 rows=719 loops=1)

  • Hash Cond: (rs_releases_summary.title_no = ww_cumes.title_no)
6. 8.957 5,610.076 ↑ 95.9 719 1

Hash Right Join (cost=375,387.92..403,790.05 rows=68,952 width=506) (actual time=5,539.816..5,610.076 rows=719 loops=1)

  • Hash Cond: (title_name_for_locale.title_no = ti_titles.title_no)
7. 65.913 65.913 ↑ 1.0 86,088 1

Index Only Scan using unq_idx_ti_rels_ti_no_ctry_id on ti_releases title_name_for_locale (cost=0.42..27,466.96 rows=86,916 width=4) (actual time=0.067..65.913 rows=86,088 loops=1)

  • Index Cond: (country_id = 'US'::text)
  • Heap Fetches: 642
8. 0.296 5,535.206 ↑ 289.7 238 1

Hash (cost=374,525.59..374,525.59 rows=68,952 width=506) (actual time=5,535.206..5,535.206 rows=238 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 1094kB
9. 43.184 5,534.910 ↑ 289.7 238 1

Hash Join (cost=284,206.57..374,525.59 rows=68,952 width=506) (actual time=3,218.669..5,534.910 rows=238 loops=1)

  • Hash Cond: (ti_titles.title_no = ti_keywords.title_no)
10. 147.417 4,344.312 ↓ 1.2 476,109 1

Hash Left Join (cost=216,459.77..304,938.84 rows=408,711 width=510) (actual time=1,893.601..4,344.312 rows=476,109 loops=1)

  • Hash Cond: (rs_releases_summary.title_no = categories.title_no)
11. 141.260 3,952.100 ↓ 4.2 476,109 1

Hash Left Join (cost=161,160.48..249,338.76 rows=114,571 width=446) (actual time=1,648.385..3,952.100 rows=476,109 loops=1)

  • Hash Cond: (ti_releases.title_no = primary_origin_countries.title_no)
12. 108.048 3,691.391 ↓ 10.0 476,109 1

Hash Left Join (cost=126,374.26..214,427.33 rows=47,690 width=414) (actual time=1,528.543..3,691.391 rows=476,109 loops=1)

  • Hash Cond: (ti_releases.title_no = secondary_origin_countries.title_no)
13. 652.177 3,541.865 ↓ 10.0 476,109 1

Nested Loop (cost=118,498.65..206,426.51 rows=47,690 width=382) (actual time=1,487.033..3,541.865 rows=476,109 loops=1)

14. 368.955 1,937.466 ↓ 10.0 476,111 1

Hash Right Join (cost=118,498.22..142,493.89 rows=47,690 width=61) (actual time=1,486.980..1,937.466 rows=476,111 loops=1)

  • Hash Cond: (release_window_summary.release_no = ti_releases.release_no)
15. 147.614 147.614 ↑ 1.0 746,965 1

Seq Scan on release_window_summary (cost=0.00..20,717.65 rows=746,965 width=8) (actual time=65.834..147.614 rows=746,965 loops=1)

16. 120.307 1,420.897 ↓ 10.0 476,111 1

Hash (cost=117,902.10..117,902.10 rows=47,690 width=57) (actual time=1,420.897..1,420.897 rows=476,111 loops=1)

  • Buckets: 524288 (originally 65536) Batches: 1 (originally 1) Memory Usage: 43942kB
17. 111.569 1,300.590 ↓ 10.0 476,111 1

Hash Join (cost=21,019.65..117,902.10 rows=47,690 width=57) (actual time=190.828..1,300.590 rows=476,111 loops=1)

  • Hash Cond: (ti_releases.title_no = ti_titles.title_no)
18. 85.166 1,130.751 ↓ 9.8 478,975 1

Hash Join (cost=14,311.55..111,065.82 rows=48,830 width=14) (actual time=132.129..1,130.751 rows=478,975 loops=1)

  • Hash Cond: ((ti_releases.country_id)::text = (week_definitions_by_country.country_id)::text)
19. 917.619 977.857 ↓ 1.3 478,975 1

Bitmap Heap Scan on ti_releases (cost=14,227.57..108,591.08 rows=380,493 width=17) (actual time=64.376..977.857 rows=478,975 loops=1)

  • Recheck Cond: (((language_format_id)::text = 'DEFAULT'::text) AND (language_no IS NULL) AND ((visual_format_id)::text = 'DEFAULT'::text))
  • Filter: ((NOT is_alt_content) AND ((country_id)::text = ANY ('{AL,DZ,AR,AM,AA,AU,AT,AZ,BH,BD,BY,BE,BO,BA,BR,BG,KH,CA,CL,CN,CO,CR,HR,CU,CZ,DK,DO,EC,EG,SV,EE,ET,FI,FR,GE,DE,GH,GR,GT,HN,HK,HU,IS,IN,ID,IQ,IL,IT,JM,JP,JO,KZ,KE,KW,KG,LV,LB,LT,LU,MA,MY,MX,MD,MN,MZ,MM,NL,NZ,NI,NO,OM,PK,PA,PY,PE,PH,PL,PT,PR,QA,RO,RU,SA,RS,SG,SK,SI,ZA,KR,ES,SL,SR,SE,CH,SY,TW,TJ,TH,TT,TR,TM,UK,UP,AE,UY,US,UZ,VE,VN,WA}'::text[])))
  • Rows Removed by Filter: 17405
  • Heap Blocks: exact=34461
20. 60.238 60.238 ↓ 1.3 496,456 1

Bitmap Index Scan on idx_ti_releases_is_default_rel (cost=0.00..14,132.45 rows=391,682 width=0) (actual time=60.238..60.238 rows=496,456 loops=1)

  • Index Cond: (((language_format_id)::text = 'DEFAULT'::text) AND (language_no IS NULL) AND ((visual_format_id)::text = 'DEFAULT'::text))
21. 0.122 67.728 ↓ 8.3 141 1

Hash (cost=83.77..83.77 rows=17 width=3) (actual time=67.727..67.728 rows=141 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
22. 67.606 67.606 ↓ 8.3 141 1

Seq Scan on week_definitions_by_country (cost=0.00..83.77 rows=17 width=3) (actual time=29.456..67.606 rows=141 loops=1)

  • Filter: ((rtk_time.now() >= from_date) AND (rtk_time.now() <= to_date))
  • Rows Removed by Filter: 10
23. 17.221 58.270 ↑ 1.0 95,956 1

Hash (cost=5,508.01..5,508.01 rows=96,007 width=43) (actual time=58.270..58.270 rows=95,956 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 8029kB
24. 41.049 41.049 ↑ 1.0 95,956 1

Seq Scan on ti_titles (cost=0.00..5,508.01 rows=96,007 width=43) (actual time=0.017..41.049 rows=95,956 loops=1)

  • Filter: (NOT is_alt_content)
  • Rows Removed by Filter: 2345
25. 952.222 952.222 ↑ 1.0 1 476,111

Index Scan using pk_rs_releases_summary on rs_releases_summary (cost=0.42..1.34 rows=1 width=329) (actual time=0.002..0.002 rows=1 loops=476,111)

  • Index Cond: (release_no = ti_releases.release_no)
26. 1.459 41.478 ↑ 1.2 10,462 1

Hash (cost=7,723.99..7,723.99 rows=12,130 width=36) (actual time=41.478..41.478 rows=10,462 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 624kB
27. 0.696 40.019 ↑ 1.2 10,462 1

Subquery Scan on secondary_origin_countries (cost=7,481.39..7,723.99 rows=12,130 width=36) (actual time=37.783..40.019 rows=10,462 loops=1)

28. 13.075 39.323 ↑ 1.2 10,462 1

HashAggregate (cost=7,481.39..7,602.69 rows=12,130 width=36) (actual time=37.781..39.323 rows=10,462 loops=1)

  • Group Key: toc.title_no
29. 7.203 26.248 ↑ 1.0 15,681 1

Sort (cost=3,315.85..3,355.15 rows=15,719 width=150) (actual time=25.452..26.248 rows=15,681 loops=1)

  • Sort Key: (CASE WHEN (c.title_origin_description IS NOT NULL) THEN c.title_origin_description ELSE c.description END)
  • Sort Method: quicksort Memory: 1138kB
30. 2.695 19.045 ↑ 1.0 15,681 1

Hash Join (cost=10.01..2,220.22 rows=15,719 width=150) (actual time=0.146..19.045 rows=15,681 loops=1)

  • Hash Cond: ((toc.country_id)::text = (c.country_id)::text)
31. 16.242 16.242 ↑ 1.0 15,681 1

Seq Scan on title_origin_countries toc (cost=0.00..2,167.98 rows=15,719 width=7) (actual time=0.026..16.242 rows=15,681 loops=1)

  • Filter: ((is_primary)::text = 'N'::text)
  • Rows Removed by Filter: 87037
32. 0.032 0.108 ↑ 1.0 178 1

Hash (cost=7.78..7.78 rows=178 width=19) (actual time=0.108..0.108 rows=178 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
33. 0.076 0.076 ↑ 1.0 178 1

Seq Scan on ti_countries c (cost=0.00..7.78 rows=178 width=19) (actual time=0.007..0.076 rows=178 loops=1)

34. 11.855 119.449 ↓ 1.3 86,370 1

Hash (cost=33,946.99..33,946.99 rows=67,138 width=36) (actual time=119.449..119.449 rows=86,370 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 4717kB
35. 5.719 107.594 ↓ 1.3 86,370 1

Subquery Scan on primary_origin_countries (cost=32,604.23..33,946.99 rows=67,138 width=36) (actual time=89.711..107.594 rows=86,370 loops=1)

36. 37.485 101.875 ↓ 1.3 86,370 1

HashAggregate (cost=32,604.23..33,275.61 rows=67,138 width=36) (actual time=89.709..101.875 rows=86,370 loops=1)

  • Group Key: toc_1.title_no
37. 39.630 64.390 ↓ 1.0 87,037 1

Sort (cost=9,549.50..9,767.00 rows=86,999 width=150) (actual time=59.937..64.390 rows=87,037 loops=1)

  • Sort Key: (CASE WHEN (c_1.title_origin_description IS NOT NULL) THEN c_1.title_origin_description ELSE c_1.description END)
  • Sort Method: quicksort Memory: 7222kB
38. 14.328 24.760 ↓ 1.0 87,037 1

Hash Join (cost=10.01..2,411.79 rows=86,999 width=150) (actual time=0.107..24.760 rows=87,037 loops=1)

  • Hash Cond: ((toc_1.country_id)::text = (c_1.country_id)::text)
39. 10.342 10.342 ↓ 1.0 87,037 1

Seq Scan on title_origin_countries toc_1 (cost=0.00..2,167.98 rows=86,999 width=7) (actual time=0.009..10.342 rows=87,037 loops=1)

  • Filter: ((is_primary)::text = 'Y'::text)
  • Rows Removed by Filter: 15681
40. 0.031 0.090 ↑ 1.0 178 1

Hash (cost=7.78..7.78 rows=178 width=19) (actual time=0.089..0.090 rows=178 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
41. 0.059 0.059 ↑ 1.0 178 1

Seq Scan on ti_countries c_1 (cost=0.00..7.78 rows=178 width=19) (actual time=0.004..0.059 rows=178 loops=1)

42. 15.453 244.795 ↑ 1.0 98,301 1

Hash (cost=54,070.53..54,070.53 rows=98,301 width=68) (actual time=244.795..244.795 rows=98,301 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 5584kB
43. 6.408 229.342 ↑ 1.0 98,301 1

Subquery Scan on categories (cost=52,104.51..54,070.53 rows=98,301 width=68) (actual time=205.031..229.342 rows=98,301 loops=1)

44. 57.326 222.934 ↑ 1.0 98,301 1

HashAggregate (cost=52,104.51..53,087.52 rows=98,301 width=68) (actual time=205.029..222.934 rows=98,301 loops=1)

  • Group Key: t.title_no
45. 16.603 165.608 ↓ 1.1 104,855 1

Hash Left Join (cost=25,113.46..27,037.75 rows=98,301 width=26) (actual time=129.193..165.608 rows=104,855 loops=1)

  • Hash Cond: ((t.primary_genre_id)::text = (c_2.category_id)::text)
46. 17.945 148.986 ↓ 1.1 104,855 1

Hash Right Join (cost=25,111.56..26,753.06 rows=98,301 width=19) (actual time=129.164..148.986 rows=104,855 loops=1)

  • Hash Cond: (t_1.title_no = t.title_no)
47. 12.258 91.795 ↑ 3.3 32,693 1

Sort (cost=18,374.79..18,646.11 rows=108,528 width=15) (actual time=89.499..91.795 rows=32,693 loops=1)

  • Sort Key: t_1.title_no, c_3.description
  • Sort Method: quicksort Memory: 2383kB
48. 5.157 79.537 ↑ 3.3 32,693 1

Hash Join (cost=6,738.67..9,297.66 rows=108,528 width=15) (actual time=36.058..79.537 rows=32,693 loops=1)

  • Hash Cond: ((tc.category_id)::text = (c_3.category_id)::text)
49. 26.536 74.354 ↑ 3.3 32,693 1

Hash Join (cost=6,736.77..8,980.70 rows=108,528 width=8) (actual time=36.022..74.354 rows=32,693 loops=1)

  • Hash Cond: (tc.title_no = t_1.title_no)
  • Join Filter: ((tc.category_id)::text <> (t_1.primary_genre_id)::text)
  • Rows Removed by Join Filter: 96488
50. 12.232 12.232 ↑ 1.0 129,181 1

Seq Scan on ti_title_categories tc (cost=0.00..1,904.81 rows=129,181 width=8) (actual time=0.022..12.232 rows=129,181 loops=1)

51. 12.614 35.586 ↑ 1.0 98,301 1

Hash (cost=5,508.01..5,508.01 rows=98,301 width=8) (actual time=35.586..35.586 rows=98,301 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 4837kB
52. 22.972 22.972 ↑ 1.0 98,301 1

Seq Scan on ti_titles t_1 (cost=0.00..5,508.01 rows=98,301 width=8) (actual time=0.004..22.972 rows=98,301 loops=1)

53. 0.013 0.026 ↑ 1.0 40 1

Hash (cost=1.40..1.40 rows=40 width=15) (actual time=0.026..0.026 rows=40 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
54. 0.013 0.013 ↑ 1.0 40 1

Seq Scan on ti_categories c_3 (cost=0.00..1.40 rows=40 width=15) (actual time=0.006..0.013 rows=40 loops=1)

55. 12.664 39.246 ↑ 1.0 98,301 1

Hash (cost=5,508.01..5,508.01 rows=98,301 width=8) (actual time=39.246..39.246 rows=98,301 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 4837kB
56. 26.582 26.582 ↑ 1.0 98,301 1

Seq Scan on ti_titles t (cost=0.00..5,508.01 rows=98,301 width=8) (actual time=0.006..26.582 rows=98,301 loops=1)

57. 0.010 0.019 ↑ 1.0 40 1

Hash (cost=1.40..1.40 rows=40 width=15) (actual time=0.019..0.019 rows=40 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
58. 0.009 0.009 ↑ 1.0 40 1

Seq Scan on ti_categories c_2 (cost=0.00..1.40 rows=40 width=15) (actual time=0.004..0.009 rows=40 loops=1)

59. 0.033 1,147.414 ↑ 397.4 33 1

Hash (cost=67,582.86..67,582.86 rows=13,115 width=4) (actual time=1,147.414..1,147.414 rows=33 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 130kB
60. 0.173 1,147.381 ↑ 397.4 33 1

HashAggregate (cost=67,451.71..67,582.86 rows=13,115 width=4) (actual time=1,147.288..1,147.381 rows=33 loops=1)

  • Group Key: ti_keywords.title_no
61. 1,147.208 1,147.208 ↑ 144.2 115 1

Seq Scan on ti_keywords (cost=0.00..67,410.25 rows=16,584 width=4) (actual time=15.810..1,147.208 rows=115 loops=1)

  • Filter: ((((entered_by)::text = 'AUTO_NAME'::text) OR ((entered_by)::text ~~ 'AUTO_AKA%'::text)) AND ((upper((word)::text) ~~ 'UNCLE'::text) OR (upper((word)::text) ~~ 'DREW'::text)))
  • Rows Removed by Filter: 2047815
62. 25.913 3,913.791 ↑ 1.0 97,538 1

Hash (cost=280,794.90..280,794.90 rows=98,301 width=152) (actual time=3,913.790..3,913.791 rows=97,538 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 8269kB
63. 10.437 3,887.878 ↑ 1.0 97,538 1

Subquery Scan on ww_cumes (cost=190,731.47..280,794.90 rows=98,301 width=152) (actual time=2,310.199..3,887.878 rows=97,538 loops=1)

64. 1,531.188 3,877.441 ↑ 1.0 97,538 1

GroupAggregate (cost=190,731.47..279,811.89 rows=98,301 width=152) (actual time=2,310.195..3,877.441 rows=97,538 loops=1)

  • Group Key: t_2.title_no
65. 198.176 2,346.253 ↓ 3.0 468,382 1

Sort (cost=190,731.47..191,122.12 rows=156,259 width=67) (actual time=2,309.825..2,346.253 rows=468,382 loops=1)

  • Sort Key: t_2.title_no
  • Sort Method: quicksort Memory: 73268kB
66. 57.448 2,148.077 ↓ 3.0 468,382 1

Merge Left Join (cost=172,793.52..177,251.34 rows=156,259 width=67) (actual time=1,930.815..2,148.077 rows=468,382 loops=1)

  • Merge Cond: (s_1.earliest_release_date_of_title = to_ex.day)
67. 111.406 2,083.553 ↓ 3.0 468,382 1

Merge Left Join (cost=158,455.30..160,869.38 rows=155,096 width=61) (actual time=1,924.624..2,083.553 rows=468,382 loops=1)

  • Merge Cond: (s_1.earliest_release_date_of_title = from_ex.day)
68. 873.617 1,963.945 ↓ 3.0 468,382 1

Sort (cost=144,117.08..144,501.94 rows=153,942 width=51) (actual time=1,917.311..1,963.945 rows=468,382 loops=1)

  • Sort Key: s_1.earliest_release_date_of_title
  • Sort Method: quicksort Memory: 68048kB
69. 80.214 1,090.328 ↓ 3.0 468,382 1

Hash Left Join (cost=127,750.50..130,853.42 rows=153,942 width=51) (actual time=744.445..1,090.328 rows=468,382 loops=1)

  • Hash Cond: ((s_1.country_id)::text = (subscription_countries.country_id)::text)
70. 102.916 1,009.950 ↓ 3.0 468,382 1

Hash Join (cost=127,712.38..130,387.50 rows=153,942 width=48) (actual time=744.265..1,009.950 rows=468,382 loops=1)

  • Hash Cond: (s_1.title_no = t_2.title_no)
71. 100.464 848.333 ↓ 3.0 468,382 1

Merge Left Join (cost=120,975.61..123,246.61 rows=153,942 width=44) (actual time=684.971..848.333 rows=468,382 loops=1)

  • Merge Cond: (s_1.exchange_rate_date = ex.day)
72. 194.921 737.453 ↓ 3.0 468,382 1

Sort (cost=106,637.39..107,022.25 rows=153,942 width=34) (actual time=675.562..737.453 rows=468,382 loops=1)

  • Sort Key: s_1.exchange_rate_date
  • Sort Method: quicksort Memory: 52792kB
73. 149.017 542.532 ↓ 3.0 468,382 1

Hash Join (cost=9.53..93,373.73 rows=153,942 width=34) (actual time=0.124..542.532 rows=468,382 loops=1)

  • Hash Cond: ((s_1.country_id)::text = (c_4.country_id)::text)
74. 393.423 393.423 ↓ 1.2 496,214 1

Seq Scan on rs_releases_summary s_1 (cost=0.00..92,296.92 rows=397,126 width=34) (actual time=0.010..393.423 rows=496,214 loops=1)

  • Filter: ((language_no IS NULL) AND ((language_format_id)::text = 'DEFAULT'::text) AND ((visual_format_id)::text = 'DEFAULT'::text))
  • Rows Removed by Filter: 250283
75. 0.022 0.092 ↓ 1.6 107 1

Hash (cost=8.67..8.67 rows=69 width=3) (actual time=0.092..0.092 rows=107 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
76. 0.070 0.070 ↓ 1.6 107 1

Seq Scan on ti_countries c_4 (cost=0.00..8.67 rows=69 width=3) (actual time=0.015..0.070 rows=107 loops=1)

  • Filter: (((is_supported)::text = 'Y'::text) AND ((is_reporting_srg)::text = 'Y'::text))
  • Rows Removed by Filter: 71
77. 4.288 10.416 ↑ 1.1 17,394 1

Sort (cost=14,338.22..14,384.92 rows=18,682 width=18) (actual time=9.393..10.416 rows=17,394 loops=1)

  • Sort Key: ex.day
  • Sort Method: quicksort Memory: 1584kB
78. 5.116 6.128 ↑ 1.1 17,394 1

Bitmap Heap Scan on exchange_rates_by_day ex (cost=693.21..13,012.79 rows=18,682 width=18) (actual time=1.134..6.128 rows=17,394 loops=1)

  • Recheck Cond: (currency_type_no = 1)
  • Heap Blocks: exact=1376
79. 1.012 1.012 ↑ 1.1 17,394 1

Bitmap Index Scan on exchange_rates_by_day_pkey (cost=0.00..688.54 rows=18,682 width=0) (actual time=1.012..1.012 rows=17,394 loops=1)

  • Index Cond: (currency_type_no = 1)
80. 19.639 58.701 ↑ 1.0 98,301 1

Hash (cost=5,508.01..5,508.01 rows=98,301 width=8) (actual time=58.701..58.701 rows=98,301 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 4831kB
81. 39.062 39.062 ↑ 1.0 98,301 1

Seq Scan on ti_titles t_2 (cost=0.00..5,508.01 rows=98,301 width=8) (actual time=0.011..39.062 rows=98,301 loops=1)

82. 0.017 0.164 ↓ 12.2 110 1

Hash (cost=38.00..38.00 rows=9 width=3) (actual time=0.164..0.164 rows=110 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
83. 0.108 0.147 ↓ 12.2 110 1

Bitmap Heap Scan on subscription_countries (cost=4.36..38.00 rows=9 width=3) (actual time=0.053..0.147 rows=110 loops=1)

  • Recheck Cond: (subscription_no = 11279)
  • Filter: can_access_srg
  • Heap Blocks: exact=8
84. 0.039 0.039 ↓ 11.0 110 1

Bitmap Index Scan on subscription_countries_pkey (cost=0.00..4.36 rows=10 width=0) (actual time=0.039..0.039 rows=110 loops=1)

  • Index Cond: (subscription_no = 11279)
85. 3.794 8.202 ↑ 1.1 17,394 1

Sort (cost=14,338.22..14,384.92 rows=18,682 width=18) (actual time=7.302..8.202 rows=17,394 loops=1)

  • Sort Key: from_ex.day
  • Sort Method: quicksort Memory: 1584kB
86. 3.620 4.408 ↑ 1.1 17,394 1

Bitmap Heap Scan on exchange_rates_by_day from_ex (cost=693.21..13,012.79 rows=18,682 width=18) (actual time=0.908..4.408 rows=17,394 loops=1)

  • Recheck Cond: (currency_type_no = 1)
  • Heap Blocks: exact=1376
87. 0.788 0.788 ↑ 1.1 17,394 1

Bitmap Index Scan on exchange_rates_by_day_pkey (cost=0.00..688.54 rows=18,682 width=0) (actual time=0.788..0.788 rows=17,394 loops=1)

  • Index Cond: (currency_type_no = 1)
88. 4.083 7.076 ↑ 1.1 17,394 1

Sort (cost=14,338.22..14,384.92 rows=18,682 width=18) (actual time=6.178..7.076 rows=17,394 loops=1)

  • Sort Key: to_ex.day
  • Sort Method: quicksort Memory: 1584kB
89. 2.404 2.993 ↑ 1.1 17,394 1

Bitmap Heap Scan on exchange_rates_by_day to_ex (cost=693.21..13,012.79 rows=18,682 width=18) (actual time=0.700..2.993 rows=17,394 loops=1)

  • Recheck Cond: (currency_type_no = 1)
  • Heap Blocks: exact=1376
90. 0.589 0.589 ↑ 1.1 17,394 1

Bitmap Index Scan on exchange_rates_by_day_pkey (cost=0.00..688.54 rows=18,682 width=0) (actual time=0.589..0.589 rows=17,394 loops=1)

  • Index Cond: (currency_type_no = 1)
91.          

SubPlan (forSubquery Scan)

92. 0.017 510.877 ↑ 95.0 1 1

HashAggregate (cost=52,324.71..52,325.66 rows=95 width=4) (actual time=510.876..510.877 rows=1 loops=1)

  • Group Key: ti_titles_1.title_no
93. 0.002 510.860 ↑ 47.5 2 1

Append (cost=0.00..52,324.48 rows=95 width=4) (actual time=26.498..510.860 rows=2 loops=1)

94. 100.527 100.527 ↑ 20.0 1 1

Seq Scan on ti_titles ti_titles_1 (cost=0.00..6,491.02 rows=20 width=4) (actual time=26.497..100.527 rows=1 loops=1)

  • Filter: ((upper((name)::text) ~~ '%UNCLE DREW%'::text) OR (upper((us_title_name)::text) ~~ '%UNCLE DREW%'::text))
  • Rows Removed by Filter: 98300
95. 0.003 410.331 ↑ 75.0 1 1

Unique (cost=45,831.66..45,832.03 rows=75 width=4) (actual time=410.328..410.331 rows=1 loops=1)

96. 0.022 410.328 ↑ 5.8 13 1

Sort (cost=45,831.66..45,831.84 rows=75 width=4) (actual time=410.327..410.328 rows=13 loops=1)

  • Sort Key: ti_releases_1.title_no
  • Sort Method: quicksort Memory: 25kB
97. 410.306 410.306 ↑ 5.8 13 1

Seq Scan on ti_releases ti_releases_1 (cost=0.00..45,829.32 rows=75 width=4) (actual time=361.773..410.306 rows=13 loops=1)

  • Filter: (upper((aka)::text) ~~ '%UNCLE DREW%'::text)
  • Rows Removed by Filter: 746954
Planning time : 40.010 ms
Execution time : 10,062.551 ms