explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Il2L : original query on 12b

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 296,944.683 ↑ 303.0 33 1

Limit (cost=806,840.69..806,865.69 rows=10,000 width=688) (actual time=296,944.679..296,944.683 rows=33 loops=1)

2. 0.146 296,944.678 ↑ 7,453.8 33 1

Sort (cost=806,840.69..807,455.62 rows=245,974 width=688) (actual time=296,944.677..296,944.678 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.043 296,944.532 ↑ 7,453.8 33 1

Subquery Scan on s (cost=783,734.24..789,268.66 rows=245,974 width=688) (actual time=296,942.462..296,944.532 rows=33 loops=1)

4. 2.990 296,442.725 ↑ 7,453.8 33 1

HashAggregate (cost=731,408.34..733,868.08 rows=245,974 width=652) (actual time=296,440.671..296,442.725 rows=33 loops=1)

  • Group Key: rs_releases_summary.title_no, ti_titles.title_no
5. 0.642 296,439.735 ↑ 342.1 719 1

Hash Left Join (cost=684,377.13..712,960.29 rows=245,974 width=654) (actual time=296,382.119..296,439.735 rows=719 loops=1)

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

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

  • Hash Cond: (title_name_for_locale.title_no = ti_titles.title_no)
7. 51.750 51.750 ↑ 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.045..51.750 rows=86,088 loops=1)

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

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

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

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

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

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

  • Hash Cond: (rs_releases_summary.title_no = categories.title_no)
11. 117.303 4,200.622 ↓ 4.2 476,109 1

Hash Left Join (cost=161,160.48..249,338.76 rows=114,571 width=446) (actual time=2,245.003..4,200.622 rows=476,109 loops=1)

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

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

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

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

14. 362.544 1,837.663 ↓ 10.0 476,111 1

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

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

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

16. 121.247 1,409.003 ↓ 10.0 476,111 1

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

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

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

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

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

  • Hash Cond: ((ti_releases.country_id)::text = (week_definitions_by_country.country_id)::text)
19. 905.763 958.869 ↓ 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=57.226..958.869 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. 53.106 53.106 ↓ 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=53.106..53.106 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.186 74.273 ↓ 8.3 141 1

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

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

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

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

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

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

Seq Scan on ti_titles (cost=0.00..5,508.01 rows=96,007 width=43) (actual time=0.019..39.362 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 36.775 ↑ 1.2 10,462 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 624kB
27. 0.675 35.316 ↑ 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=33.055..35.316 rows=10,462 loops=1)

28. 13.089 34.641 ↑ 1.2 10,462 1

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

  • Group Key: toc.title_no
29. 7.252 21.552 ↑ 1.0 15,681 1

Sort (cost=3,315.85..3,355.15 rows=15,719 width=150) (actual time=20.736..21.552 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.639 14.300 ↑ 1.0 15,681 1

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

  • Hash Cond: ((toc.country_id)::text = (c.country_id)::text)
31. 11.561 11.561 ↑ 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.014..11.561 rows=15,681 loops=1)

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

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

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

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

34. 12.974 780.352 ↓ 1.3 86,370 1

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

  • Buckets: 131072 Batches: 1 Memory Usage: 4717kB
35. 5.509 767.378 ↓ 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=749.300..767.378 rows=86,370 loops=1)

36. 38.061 761.869 ↓ 1.3 86,370 1

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

  • Group Key: toc_1.title_no
37. 698.801 723.808 ↓ 1.0 87,037 1

Sort (cost=9,549.50..9,767.00 rows=86,999 width=150) (actual time=719.192..723.808 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.345 25.007 ↓ 1.0 87,037 1

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

  • Hash Cond: ((toc_1.country_id)::text = (c_1.country_id)::text)
39. 10.578 10.578 ↓ 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.008..10.578 rows=87,037 loops=1)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
41. 0.054 0.054 ↑ 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.054 rows=178 loops=1)

42. 15.253 243.780 ↑ 1.0 98,301 1

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

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

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

44. 55.323 222.273 ↑ 1.0 98,301 1

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

  • Group Key: t.title_no
45. 15.799 166.950 ↓ 1.1 104,855 1

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

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

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

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

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

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

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

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

Hash Join (cost=6,736.77..8,980.70 rows=108,528 width=8) (actual time=37.298..77.397 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. 8.953 8.953 ↑ 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.008..8.953 rows=129,181 loops=1)

51. 12.926 36.869 ↑ 1.0 98,301 1

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

  • Buckets: 131072 Batches: 1 Memory Usage: 4837kB
52. 23.943 23.943 ↑ 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..23.943 rows=98,301 loops=1)

53. 0.012 0.029 ↑ 1.0 40 1

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

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

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

55. 12.730 39.864 ↑ 1.0 98,301 1

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

  • Buckets: 131072 Batches: 1 Memory Usage: 4837kB
56. 27.134 27.134 ↑ 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.012..27.134 rows=98,301 loops=1)

57. 0.008 0.017 ↑ 1.0 40 1

Hash (cost=1.40..1.40 rows=40 width=15) (actual time=0.017..0.017 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.005..0.009 rows=40 loops=1)

59. 0.032 1,096.399 ↑ 397.4 33 1

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

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

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

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

Seq Scan on ti_keywords (cost=0.00..67,410.25 rows=16,584 width=4) (actual time=16.098..1,096.214 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. 27.408 290,681.627 ↑ 1.0 97,538 1

Hash (cost=307,760.45..307,760.45 rows=98,301 width=152) (actual time=290,681.627..290,681.627 rows=97,538 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 8269kB
63. 11.262 290,654.219 ↑ 1.0 97,538 1

Subquery Scan on ww_cumes (cost=218,345.40..307,760.45 rows=98,301 width=152) (actual time=289,091.325..290,654.219 rows=97,538 loops=1)

64. 1,509.695 290,642.957 ↑ 1.0 97,538 1

GroupAggregate (cost=218,345.40..306,777.44 rows=98,301 width=152) (actual time=289,091.321..290,642.957 rows=97,538 loops=1)

  • Group Key: t_2.title_no
65. 208.173 289,133.262 ↓ 3.0 468,382 1

Sort (cost=218,345.40..218,733.14 rows=155,096 width=67) (actual time=289,090.893..289,133.262 rows=468,382 loops=1)

  • Sort Key: t_2.title_no
  • Sort Method: quicksort Memory: 73268kB
66. 110.467 288,925.089 ↓ 3.0 468,382 1

Merge Left Join (cost=202,559.87..204,973.95 rows=155,096 width=67) (actual time=288,763.255..288,925.089 rows=468,382 loops=1)

  • Merge Cond: (s_1.earliest_release_date_of_title = to_ex.day)
67. 335.917 288,806.004 ↓ 3.0 468,382 1

Sort (cost=188,221.65..188,606.51 rows=153,942 width=61) (actual time=288,755.560..288,806.004 rows=468,382 loops=1)

  • Sort Key: s_1.earliest_release_date_of_title
  • Sort Method: quicksort Memory: 73358kB
68. 271.239 288,470.087 ↓ 3.0 468,382 1

Hash Left Join (cost=171,450.98..174,957.99 rows=153,942 width=61) (actual time=1,047.315..288,470.087 rows=468,382 loops=1)

  • Hash Cond: ((s_1.country_id)::text = (subscription_countries.country_id)::text)
69. 286,494.431 288,198.753 ↓ 3.0 468,382 1

Hash Left Join (cost=171,412.86..174,492.08 rows=153,942 width=58) (actual time=1,047.191..288,198.753 rows=468,382 loops=1)

  • Hash Cond: (COALESCE(t_2.currency_type_no, 1) = from_ex.currency_type_no)
  • Join Filter: (s_1.earliest_release_date_of_title = from_ex.day)
  • Rows Removed by Join Filter: 4558442095
70. 256.893 1,346.033 ↓ 3.0 468,382 1

Hash Join (cost=127,712.38..130,387.50 rows=153,942 width=52) (actual time=680.981..1,346.033 rows=468,382 loops=1)

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

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

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

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

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

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

  • Hash Cond: ((s_1.country_id)::text = (c_4.country_id)::text)
74. 362.085 362.085 ↓ 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.007..362.085 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.017 0.064 ↓ 1.6 107 1

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

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

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

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

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

  • Sort Key: ex.day
  • Sort Method: quicksort Memory: 1584kB
78. 5.060 6.006 ↑ 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.067..6.006 rows=17,394 loops=1)

  • Recheck Cond: (currency_type_no = 1)
  • Heap Blocks: exact=1376
79. 0.946 0.946 ↑ 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.946..0.946 rows=17,394 loops=1)

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

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

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

Seq Scan on ti_titles t_2 (cost=0.00..5,508.01 rows=98,301 width=12) (actual time=0.007..27.591 rows=98,301 loops=1)

82. 184.171 358.289 ↑ 1.0 1,426,110 1

Hash (cost=25,874.10..25,874.10 rows=1,426,110 width=22) (actual time=358.289..358.289 rows=1,426,110 loops=1)

  • Buckets: 2097152 Batches: 1 Memory Usage: 98378kB
83. 174.118 174.118 ↑ 1.0 1,426,110 1

Seq Scan on exchange_rates_by_day from_ex (cost=0.00..25,874.10 rows=1,426,110 width=22) (actual time=0.008..174.118 rows=1,426,110 loops=1)

84. 0.018 0.095 ↓ 12.2 110 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
85. 0.043 0.077 ↓ 12.2 110 1

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

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

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

  • Index Cond: (subscription_no = 11279)
87. 4.161 8.618 ↑ 1.1 17,394 1

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

  • Sort Key: to_ex.day
  • Sort Method: quicksort Memory: 1584kB
88. 3.640 4.457 ↑ 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.945..4.457 rows=17,394 loops=1)

  • Recheck Cond: (currency_type_no = 1)
  • Heap Blocks: exact=1376
89. 0.817 0.817 ↑ 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.817..0.817 rows=17,394 loops=1)

  • Index Cond: (currency_type_no = 1)
90.          

SubPlan (forSubquery Scan)

91. 0.013 501.764 ↑ 95.0 1 1

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

  • Group Key: ti_titles_1.title_no
92. 0.002 501.751 ↑ 47.5 2 1

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

93. 99.995 99.995 ↑ 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.332..99.995 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
94. 0.004 401.754 ↑ 75.0 1 1

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

95. 0.017 401.750 ↑ 5.8 13 1

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

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

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

  • Filter: (upper((aka)::text) ~~ '%UNCLE DREW%'::text)
  • Rows Removed by Filter: 746954