Planner — IMDB — JOB-19A

Estimate    Actual  Operator
       1         1  AGGREGATE min, min
       7       184  INNER JOIN HASH ON person_id = person_id85
       7       162  │└INNER JOIN HASH ON id = info_type_id
       1         1  │ │└TABLE SCAN info_type WHERE info = release dates
       7       162  │ INNER JOIN HASH ON id74 = person_role_id
       7       162  │ │└INNER JOIN HASH ON movie_id67 = movie_id34
      19        65  │ │ │└INNER JOIN HASH ON id51 = movie_id34
      27       305  │ │ │ │└INNER JOIN HASH ON id41 = company_id
      74       322  │ │ │ │ │└INNER JOIN HASH ON movie_id34 = movie_id
     271       630  │ │ │ │ │ │└INNER JOIN HASH ON id6 = role_id
       1         1  │ │ │ │ │ │ │└TABLE SCAN role_type WHERE role = actress
    2576       630  │ │ │ │ │ │ INNER JOIN HASH ON id11 = person_id
   12209      6768  │ │ │ │ │ │ │└TABLE SCAN name WHERE gender = f AND name LIKE '%Ang%'
  707897       630  │ │ │ │ │ │ TABLE SCAN cast_info WHERE note IN(voice,voice uncredited,(voice : English version),(voice : Japanese version))
  634446       304  │ │ │ │ │ TABLE SCAN movie_companies WHERE note37 LIKE '%(USA)%' OR note37 LIKE '%(worldwide)%'
   90648       132  │ │ │ │ TABLE SCAN company_name WHERE country_code = us
  634547        33  │ │ │ TABLE SCAN title WHERE production_year BETWEEN 2005 AND 2009
  376688        75  │ │ TABLE SCAN movie_info WHERE info69 LIKE '%200%'
 3140339   3140339  │ TABLE SCAN char_name
  901343    901343  TABLE SCAN aka_name

Estimate    Actual  Operator
       -         ∞  PROJECT a1 AS voicing_actress, a2 AS voiced_movie
       -         ∞  AGGREGATE MIN(name) AS a1, MIN(title) AS a2
       -         ∞  PROJECT name, title
       -         ∞  PROJECT name, title
       -         ∞  INNER JOIN HASH ON tuple(PROJECTION_1600.movie_id,PROJECTION_1600.movie_id,PROJECTION_1600.id) = tuple(PROJECTION_1591.movie_id,PROJECTION_1591.movie_id,PROJECTION_1591.movie_id)
       -         ∞  │└PROJECT movie_id AS movie_id_right
       -         ∞  │ PROJECT movie_id
       -         ∞  │ INNER JOIN HASH ON PROJECTION_1597.info_type_id = PROJECTION_1594.id
       -         1  │ │└PROJECT id
       -         1  │ │ FILTER (1 AND info = 'release dates'_String) AS a63
       -         1  │ │ TABLE SCAN info_type WHERE info = 'release dates'
       -         ∞  │ PROJECT info_type_id, movie_id
       -         ∞  │ FILTER (1 AND  OR ( LIKE (info,'Japan:%200%'_String), LIKE (info,'USA:%200%'_String))) AS a55
       -    451104  │ TABLE SCAN movie_info WHERE info LIKE 'Japan:%200%' OR info LIKE 'USA:%200%'
       -         ∞  PROJECT movie_id_left, movie_id_right AS movie_id_left_2, id, name, title
       -         ∞  PROJECT movie_id_left, movie_id_right, name, title, id
       -         ∞  INNER JOIN HASH ON PROJECTION_1606.company_id = PROJECTION_1603.id
       -         0  │└PROJECT id AS id_right
       -         0  │ FILTER (1 AND country_code = 'us'_String) AS a50
       -         0  │ TABLE SCAN company_name WHERE country_code = 'us'
       -         ∞  PROJECT company_id, movie_id_left, movie_id_right, name, title, id_left
       -         ∞  PROJECT movie_id_left, movie_id_right, company_id, name, title, id
       -         ∞  INNER JOIN HASH ON PROJECTION_1612.person_role_id = PROJECTION_1609.id
       -   3140339  │└PROJECT id AS id_right
       -   3140339  │ PROJECT id
       -   3140339  │ TABLE SCAN char_name
       -         ∞  PROJECT person_role_id, movie_id_left, movie_id_right, company_id, name, title, id_left
       -         ∞  PROJECT person_role_id, movie_id_left, movie_id_right, company_id, name, title, id
       -         ∞  INNER JOIN HASH ON tuple(PROJECTION_1618.person_id,PROJECTION_1618.id) = tuple(PROJECTION_1615.person_id,PROJECTION_1615.person_id)
       -    901343  │└PROJECT person_id AS person_id_right
       -    901343  │ PROJECT person_id
       -    901343  │ TABLE SCAN aka_name
       -         ∞  PROJECT person_id AS person_id_left, id, person_role_id, movie_id_left, movie_id_right, company_id, name, title, id
       -         ∞  PROJECT person_id, person_role_id, movie_id_left, movie_id_right, company_id, name, id, title, id
       -         ∞  INNER JOIN HASH ON tuple(PROJECTION_1624.movie_id,PROJECTION_1624.movie_id) = tuple(PROJECTION_1621.id,PROJECTION_1621.id)
       -    574556  │└PROJECT id AS id_right, title
       -    574556  │ FILTER (1 AND production_year >= 2005_UInt16 AND production_year <= 2009_UInt16) AS a42
       -    574556  │ TABLE SCAN title WHERE (production_year >= 2005) AND (production_year <= 2009)
       -         ∞  PROJECT movie_id_left, movie_id_right, person_id, person_role_id, company_id, name, id AS id_left
       -         ∞  PROJECT person_id, person_role_id, movie_id_left, movie_id_right, company_id, name, id
       -         ∞  INNER JOIN HASH ON PROJECTION_1630.person_id = PROJECTION_1627.id
       -         ∞  │└PROJECT id, name
       -         ∞  │ FILTER (1 AND  LIKE (name,'%Ang%'_String) AND gender = 'f'_String) AS a34
       -      6768  │ TABLE SCAN name WHERE (gender = 'f') AND name LIKE '%Ang%'
       -         ∞  PROJECT person_id, person_role_id, movie_id_left, movie_id_right, company_id
       -         ∞  PROJECT person_id, person_role_id, movie_id_left, movie_id_right, company_id
       -         ∞  INNER JOIN HASH ON PROJECTION_1636.role_id = PROJECTION_1633.id
       -         1  │└PROJECT id
       -         1  │ FILTER (1 AND role = 'actress'_String) AS a30
       -         1  │ TABLE SCAN role_type WHERE role = 'actress'
       -         ∞  PROJECT role_id, person_id, person_role_id, movie_id_left, movie_id_right, company_id
       -         ∞  PROJECT person_id, person_role_id, movie_id_left, role_id, movie_id_right, company_id
       -         ∞  INNER JOIN HASH ON PROJECTION_1642.movie_id = PROJECTION_1639.movie_id
       -         ∞  │└PROJECT movie_id AS movie_id_right, company_id
       -         ∞  │ FILTER (1 AND  OR ( LIKE (note,'%(USA)%'_String), LIKE (note,'%(worldwide)%'_String))) AS a22
       -    590994  │ TABLE SCAN movie_companies WHERE note LIKE '%(USA)%' OR note LIKE '%(worldwide)%'
       -         ∞  PROJECT movie_id AS movie_id_left, person_id, person_role_id, role_id
       -         ∞  FILTER (in(note,__set_String_6680244196204786103_17565861716447275384) AND 1) AS a18
       -  36244344  TABLE SCAN cast_info WHERE TRUE

Estimate    Actual  Operator
       -         1  AGGREGATE MIN(#0), MIN(#1)
       0       184  PROJECT name, title
       0       184  INNER JOIN HASH ON id = person_role_id
       0       189  │└INNER JOIN HASH ON id = person_id
       0     71864  │ │└INNER JOIN HASH ON person_id = person_id
       3     40272  │ │ │└INNER JOIN HASH ON role_id = id
       1         1  │ │ │ │└FILTER id <= 11
       1         1  │ │ │ │ TABLE SCAN role_type WHERE role = 'actress'
      45     40272  │ │ │ INNER JOIN HASH ON movie_id = id
      15    116277  │ │ │ │└INNER JOIN HASH ON info_type_id = id
       2         1  │ │ │ │ │└FILTER id <= 110
       2         1  │ │ │ │ │ TABLE SCAN info_type WHERE info = 'release dates'
     887    116277  │ │ │ │ INNER JOIN HASH ON movie_id = movie_id
     743     86979  │ │ │ │ │└INNER JOIN HASH ON id = movie_id
    3650    542096  │ │ │ │ │ │└INNER JOIN HASH ON company_id = id
    1644     84843  │ │ │ │ │ │ │└TABLE SCAN company_name WHERE country_code = 'us'
  521825    590994  │ │ │ │ │ │ TABLE SCAN movie_companies WHERE (note IS NOT NULL) AND (contains(note,'(USA)') OR contains(note,'(worldwide)'))
  505662    574450  │ │ │ │ │ FILTER id BETWEEN 2 AND 2525745
  505662    574556  │ │ │ │ │ TABLE SCAN title WHERE production_year >= 2005 AND production_year <= 2009
 2967144     88863  │ │ │ │ FILTER movie_id BETWEEN 2 AND 2525745
 2967144     88863  │ │ │ │ TABLE SCAN movie_info WHERE (info IS NOT NULL) AND ((info LIKE 'Japan:%200%') OR (info LIKE 'USA:%200%'))
 7248868     12449  │ │ │ FILTER (person_id >= 4) AND (movie_id BETWEEN 2 AND 2525745)
 7248868     12449  │ │ │ FILTER (note = '(voice)') OR (note = '(voice: Japanese version)') OR (note = '(voice) (uncredited)') OR (note = '(voice: English version)')
36244344    345775  │ │ │ TABLE SCAN cast_info WHERE note IN('(voice)','(voice: Japanese version)','(voice) (uncredited)','(voice: English version)')
  901343      3450  │ │ TABLE SCAN aka_name WHERE person_id <= 4061926
 2083746        13  │ FILTER id BETWEEN 4 AND 4061926
 2083746        13  │ TABLE SCAN "name" WHERE gender = 'f' AND contains(name,'Ang')
 3140339        89  TABLE SCAN char_name

Estimate    Actual  Operator
       1         1  PROJECT voicing_actress, voiced_movie
       1         1  AGGREGATE MIN(name), MIN(title)
    6989        10  DISTRIBUTE GATHER
    6989        10  AGGREGATE MIN(name), MIN(title)
    6989       184  INNER JOIN HASH ON movie_id = id AND movie_id = id AND movie_id = id
    6989       311  │└DISTRIBUTE GATHER
    6989       311  │ INNER JOIN HASH ON id = role_id
       3         1  │ │└DISTRIBUTE GATHER
       3         1  │ │ FILTER role = 'actress'
      12        12  │ │ DISTRIBUTE ROUND ROBIN
      12        12  │ │ TABLE SCAN role_type WHERE role = 'actress'
   25628       311  │ INNER JOIN HASH ON person_id = id AND person_id = id
   25628    120420  │ │└DISTRIBUTE GATHER
   25628    120420  │ │ INNER JOIN HASH ON id = info_type_id
      23         1  │ │ │└DISTRIBUTE GATHER
      23         1  │ │ │ FILTER info = 'release dates'
     113       113  │ │ │ DISTRIBUTE ROUND ROBIN
     113       113  │ │ │ TABLE SCAN info_type WHERE info = 'release dates'
  122571    120420  │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id
  104366    168007  │ │ │└DISTRIBUTE HASH ON movie_id, movie_id
  104366    168007  │ │ │ INNER JOIN HASH ON id = company_id
   47000     84843  │ │ │ │└DISTRIBUTE GATHER
   47000     84843  │ │ │ │ FILTER country_code = 'us'
  234997    234997  │ │ │ │ TABLE SCAN company_name WHERE country_code = 'us'
  521826    175314  │ │ │ PROJECT person_id, person_id, movie_id, role_id, movie_id, company_id
  521826    175314  │ │ │ INNER JOIN HASH ON movie_id = movie_id
  521826    590994  │ │ │ │└DISTRIBUTE HASH ON movie_id
  521826    590994  │ │ │ │ FILTER note IS NOT NULL AND (note LIKE '%(USA)%' OR note LIKE '%(worldwide)%')
 2609129   2609129  │ │ │ │ TABLE SCAN movie_companies WHERE (note IS NOT NULL AND (note LIKE '%(USA)%' OR note LIKE '%(worldwide)%')) AND (((company_id >= 1) AND (company_id <= 234997)) AND TRUE)
 1608526    497319  │ │ │ DISTRIBUTE HASH ON movie_id
 1608526    497319  │ │ │ INNER JOIN HASH ON person_role_id = id
 1608526    517803  │ │ │ │└DISTRIBUTE HASH ON person_role_id
 1608526    517803  │ │ │ │ INNER JOIN HASH ON person_id = person_id
  901343    901343  │ │ │ │ │└DISTRIBUTE HASH ON person_id
  901343    901343  │ │ │ │ │ TABLE SCAN aka_name
 7248869    280995  │ │ │ │ DISTRIBUTE HASH ON person_id
 7248869    280995  │ │ │ │ FILTER note IN('(voice)','(voice: Japanese version)','(voice) (uncredited)','(voice: English version)')
36244344   7656546  │ │ │ │ TABLE SCAN cast_info WHERE ((note IN('(voice)','(voice: Japanese version)','(voice) (uncredited)','(voice: English version)') AND CASE MOD(HASH_REPARTITION person_id,10) WHEN 0 THEN (((person_id >= 5) AND (person_id <= 4167489)) AND TRUE) WHEN 1 THEN (((person_id >= 15) AND (person_id <= 4167473)) AND TRUE) WHEN 2 THEN (((person_id >= 69) AND (person_id <= 4167478)) AND TRUE) WHEN 3 THEN (((person_id >= 161) AND (person_id <= 4167352)) AND TRUE) WHEN 4 THEN...
 3140339   3140339  │ │ │ DISTRIBUTE HASH ON id
 3140339   3140339  │ │ │ TABLE SCAN char_name WHERE CASE MOD(HASH_REPARTITION id,10) WHEN 0 THEN (((id >= 119) AND (id <= 3139884)) AND TRUE) WHEN 1 THEN (((id >= 63) AND (id <= 3139863)) AND TRUE) WHEN 2 THEN (((id >= 53) AND (id <= 3139889)) AND TRUE) WHEN 3 THEN (((id >= 1) AND (id <= 3139888)) AND TRUE) WHEN 4 THEN (((id >= 21) AND (id <= 3139890)) AND TRUE) WHEN 5 THEN (((id >= 57) AND (id <= 3139914)) AND TRUE) WHEN 6 THEN (((id >= 142) AND (id <= 3139883)) AND TRUE) WHEN 7 THEN ...
 2967144    451039  │ │ DISTRIBUTE HASH ON movie_id, movie_id
 2967144    451039  │ │ FILTER info IS NOT NULL AND (info LIKE 'Japan:%200%' OR info LIKE 'USA:%200%')
14835720   3212639  │ │ TABLE SCAN movie_info WHERE ((info IS NOT NULL AND (info LIKE 'Japan:%200%' OR info LIKE 'USA:%200%')) AND CASE MOD(HASH_REPARTITION(movie_id,movie_id),10) WHEN 1 THEN ((((movie_id >= 908) AND (movie_id <= 2525344)) AND ((movie_id >= 908) AND (movie_id <= 2525344))) AND TRUE) WHEN 3 THEN ((((movie_id >= 909) AND (movie_id <= 2524106)) AND ((movie_id >= 909) AND (movie_id <= 2524106))) AND TRUE) WHEN 5 THEN ((((movie_id >= 910) AND (movie_id <= 2521127)) AND ((movie...
  833499      6768  │ FILTER (gender = 'f') AND name LIKE '%Ang%'
 4167491    983636  │ TABLE SCAN name WHERE ((gender = 'f') AND name LIKE '%Ang%') AND ((((id >= 293010) AND (id <= 2700464)) AND ((id >= 293010) AND (id <= 2700464))) AND TRUE)
   90297    510624  FILTER (production_year >= 2005) AND (production_year <= 2009)
 2528312   2282552  TABLE SCAN title WHERE ((production_year >= 2005) AND (production_year <= 2009)) AND (((((id >= 468901) AND (id <= 2497704)) AND ((id >= 468901) AND (id <= 2497704))) AND ((id >= 468901) AND (id <= 2497704))) AND struct(id,id,id) IN( < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , <...

Estimate    Actual  Operator
     142    901343  SEQUENCE
       1         1  ├─AGGREGATE MIN(n.name), MIN(t.title)
       1         4  │ DISTRIBUTE GATHER
       1         4  │ AGGREGATE MIN(n.name), MIN(t.title)
    3970       184  │ INNER JOIN HASH ON mi.info_type_id = it.id
    3970         1  │ │└DISTRIBUTE GATHER
 4170000         1  │ │ TABLE SCAN info_type WHERE it.info = 'release dates'
    2500       184  │ INNER JOIN HASH ON ci.movie_id = mi.movie_id
    2500        77  │ │└DISTRIBUTE GATHER
     397        77  │ │ INNER JOIN HASH ON ci.person_id = an.person_id
     397    901343  │ │ │└DISTRIBUTE GATHER
 3140000    901343  │ │ │ TABLE SCAN aka_name
     384        65  │ │ INNER JOIN HASH ON mc.company_id = cn.id
     384     84843  │ │ │└DISTRIBUTE GATHER
 2530000     84843  │ │ │ TABLE SCAN company_name WHERE (cn.country_code IS NOT NULL) AND (cn.country_code = 'us')
     150        71  │ │ INNER JOIN HASH ON ci.movie_id = mc.movie_id
     150    590994  │ │ │└DISTRIBUTE HASH ON mc.movie_id, mc.movie_id
 2610000    590994  │ │ │ TABLE SCAN movie_companies WHERE (mc.note IS NOT NULL) AND (contains(mc.note,'(USA)') OR contains(mc.note,'(worldwide)'))
     142       119  │ │ INNER JOIN HASH ON ci.movie_id = t.id
     142    574556  │ │ │└DISTRIBUTE GATHER
  235000    574556  │ │ │ TABLE SCAN title WHERE (t.production_year IS NOT NULL) AND (t.production_year >= 2005L) AND (t.production_year <= 2009L)
     142       630  │ │ INNER JOIN HASH ON ci.person_id = n.id
     142    255651  │ │ │└DISTRIBUTE GATHER
     142    255651  │ │ │ INNER JOIN HASH ON ci.person_role_id = chn.id
     142    255651  │ │ │ │└DISTRIBUTE GATHER
  202000    255651  │ │ │ │ INNER JOIN HASH ON ci.role_id = rt.id
  202000         1  │ │ │ │ │└DISTRIBUTE GATHER
       -         1  │ │ │ │ │ TABLE SCAN role_type WHERE rt.role = 'actress'
  901000    255651  │ │ │ │ TABLE SCAN cast_info WHERE (ci.note IN('(voice)','(voice: Japanese version)','(voice) (uncredited)','(voice: English version)')) AND (ci.person_role_id IS NOT NULL)
     113   3132421  │ │ │ TABLE SCAN char_name
14800000      6557  │ │ TABLE SCAN name WHERE (n.gender IS NOT NULL) AND (n.gender = 'f') AND contains(n.name,'Ang')
 1740000     24737  │ FILTER 
      12    379910  │ TABLE SCAN movie_info WHERE mi.info LIKE 'Japan:%200%' OR mi.info LIKE 'USA:%200%'
     142    901343  └─FILTER 
    2500    901343    DISTRIBUTE HASH
    2500    901343    AGGREGATE bloom_filter_agg(bloom_expr(ci.movie_id,ci.movie_id),255651L,2097152L)
36200000    901343    DISTRIBUTE HASH
36200000    901343    DISTRIBUTE HASH
36200000    901343    TABLE SCAN aka_name

Estimate    Actual  Operator
       1         1  AGGREGATE MIN(name as name) AS Expr1020, MIN(title as title) AS Expr1021
     107       204  INNER JOIN LOOP ON ci.person_role_id = chn.id
       1       204  │└TABLE SEEK char_name AS chn
     113       213  INNER JOIN LOOP ON n.id = an.person_id
       4       213  │└TABLE SEEK aka_name AS an
      49       208  FILTER name as name LIKE '%Ang%' AND gender as gender = 'f'
      53     40307  INNER JOIN LOOP ON Bmk1014 = Bmk1014
       1     40307  │└TABLE SEEK name AS n
      53     40307  SORT Expr1083
      53     40307  PROJECT BmkToPage Bmk1014 AS Expr1083
      53     40307  INNER JOIN LOOP ON ci.person_id = n.id
       1     40307  │└TABLE SEEK name AS n
      53     40307  SORT person_id
      53     40307  FILTER role as role = 'actress'
     583    130159  INNER JOIN LOOP ON Bmk1016 = Bmk1016
       1    130159  │└TABLE SEEK role_type AS rt
     583    130159  INNER JOIN LOOP ON ci.role_id = rt.id
       1    130159  │└TABLE SEEK role_type AS rt
     583    130159  FILTER note as note = '(voice)' OR note as note = '(voice) (uncredited)' OR note as note = '(voice: English version)' OR note as note = '(voice: Japanese version)'
   24380   5433461  INNER JOIN LOOP ON Bmk1004 = Bmk1004
       1   5433461  │└TABLE SEEK cast_info AS ci
   24380   5433461  PROJECT BmkToPage Bmk1004 AS Expr1109
   24380   5433461  INNER JOIN LOOP ON t.id = ci.movie_id
      30   5433461  │└TABLE SEEK cast_info AS ci
     806    116277  INNER JOIN LOOP ON Bmk1018 = Bmk1018
       0    116277  │└TABLE SEEK title AS t WHERE production_year as production_year >= 2005 AND production_year as production_year <= 2009
    3592    188295  PROJECT BmkToPage Bmk1018 AS Expr1106
    3592    188295  INNER JOIN LOOP ON mi.movie_id = t.id
       1    188295  │└TABLE SEEK title AS t
    3592    188295  INNER JOIN HASH ON cn.id = mc.company_id
    9989    200967  │└INNER JOIN HASH ON mc.movie_id = mi.movie_id
    6270    451039  │ │└INNER JOIN HASH ON mi.info_type_id = it.id
       1         1  │ │ │└FILTER info as info = 'release dates'
     113       113  │ │ │ TABLE SCAN info_type AS it
  438927    451039  │ │ TABLE SEEK movie_info AS mi WHERE (PROBE(Bitmap1102,info_type_id as info_type_id,N'IN ROW')) AND (info as info LIKE 'Japan:%200%' OR info as info LIKE 'USA:%200%')
  419570    243575  │ TABLE SCAN movie_companies AS mc WHERE (PROBE(Bitmap1103,movie_id as movie_id,N'IN ROW')) AND ((note as note LIKE '%(USA)%' OR note as note LIKE '%(worldwide)%') AND note as note IS NOT NULL)
   84576     12748  TABLE SCAN company_name AS cn WHERE (PROBE(Bitmap1104,id as id,N'IN ROW')) AND (country_code as country_code = 'us')

Estimate    Actual  Operator
       1         ∞  PROJECT min AS voicing_actress, min_61 AS voiced_movie
       1         1  AGGREGATE MIN(min_62) AS min, MIN(min_63) AS min_61
       -        16  DISTRIBUTE GATHER
       -        16  AGGREGATE MIN(name_40) AS min_62, MIN(title) AS min_63
       -       184  INNER JOIN HASH ON movie_id = id_54
   70683    574556  │└DISTRIBUTE HASH ON id_54
   70683    574556  │ PROJECT id AS id_54, title
   70683    574556  │ FILTER production_year BETWEEN 2005 AND 2009
   70683    574556  │ TABLE SCAN title
       -       311  INNER JOIN HASH ON role_id = id_50
      12         1  │└DISTRIBUTE GATHER
      12         1  │ PROJECT id AS id_50
      12         1  │ FILTER role = 'actress'
      12         1  │ TABLE SCAN role_type
       -       311  INNER JOIN HASH ON person_id_10 = id_39
 4167491      6768  │└DISTRIBUTE HASH ON id_39
 4167491      6768  │ PROJECT id AS id_39, name AS name_40
 4167491      6768  │ FILTER (gender = 'f') AND (name LIKE '%Ang%')
 4167491      6768  │ TABLE SCAN name
       -       311  INNER JOIN HASH ON info_type_id = id_22
     113         1  │└DISTRIBUTE GATHER
     113         1  │ PROJECT id AS id_22
     113         1  │ FILTER info = 'release dates'
     113         1  │ TABLE SCAN info_type
       -       311  INNER JOIN HASH ON movie_id = movie_id_33
13352148    451039  │└DISTRIBUTE HASH ON movie_id_33
13352148    451039  │ PROJECT movie_id AS movie_id_33, info_type_id
13352148    451039  │ FILTER (((info >= 'Japan:') AND (info < 'Japan;')) OR ((info >= 'USA:') AND (info < 'USA;'))) AND ((info LIKE 'Japan:%200%') OR (info LIKE 'USA:%200%'))
13352148    451039  │ TABLE SCAN movie_info
       -       341  INNER JOIN HASH ON company_id = id_14
  234997     84843  │└DISTRIBUTE GATHER
  234997     84843  │ PROJECT id AS id_14
  234997     84843  │ FILTER country_code = 'us'
  234997     84843  │ TABLE SCAN company_name
       -       341  INNER JOIN HASH ON movie_id = movie_id_27
 1203426    542096  │└DISTRIBUTE HASH ON movie_id_27
 1203426    542096  │ PROJECT movie_id AS movie_id_27, company_id
 1203426    542096  │ FILTER  NOT (note IS NULL) AND ((note LIKE '%(USA)%') OR (note LIKE '%(worldwide)%'))
 1203426    542096  │ TABLE SCAN movie_companies
       -       387  INNER JOIN HASH ON person_role_id = id_0
 3140339   3140339  │└DISTRIBUTE HASH ON id_0
 3140339   3140339  │ PROJECT id AS id_0
 3140339   3140339  │ TABLE SCAN char_name
       -       425  INNER JOIN HASH ON person_id_10 = person_id
  901343      1558  │└DISTRIBUTE GATHER
  901343      1558  │ TABLE SCAN aka_name
32619910       228  PROJECT person_id AS person_id_10, movie_id, person_role_id, role_id
32619910       228  FILTER note IN('(voice)','(voice) (uncredited)','(voice: English version)','(voice: Japanese version)')
32619910       228  TABLE SCAN cast_info

Estimate    Actual  Operator
       1         1  AGGREGATE MIN(name), MIN(title)
       1       184  INNER JOIN LOOP ON id = person_role_id
       1       189  │└INNER JOIN LOOP ON person_id = person_id AND person_id = id AND (person_id = id)
       4       170  │ │└INNER JOIN LOOP ON id = person_id
       7     10068  │ │ │└INNER JOIN HASH ON role_id = id
       1         1  │ │ │ │└TABLE SCAN role_type AS rt WHERE rt.role = 'actress'
     356    130077  │ │ │ INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id)
      94     29069  │ │ │ │└INNER JOIN HASH ON info_type_id = id
       4         4  │ │ │ │ │└TABLE SEEK info_type AS it
   42512    116287  │ │ │ │ INNER JOIN LOOP ON movie_id = id
   31820     86979  │ │ │ │ │└INNER JOIN LOOP ON id = movie_id
   35881    135524  │ │ │ │ │ │└INNER JOIN HASH ON company_id = id
   50474     84843  │ │ │ │ │ │ │└TABLE SEEK company_name AS cn
  393072    590994  │ │ │ │ │ │ TABLE SCAN movie_companies AS mc WHERE (mc.note IS NOT NULL) AND ((mc.note LIKE '%(USA)%') OR (mc.note LIKE '%(worldwide)%'))
  542096    542096  │ │ │ │ │ TABLE SEEK title AS t WHERE (t.production_year >= 2005) AND (t.production_year <= 2009)
  173958    116551  │ │ │ │ TABLE SEEK movie_info AS mi WHERE (mi.info LIKE 'Japan:%200%') OR (mi.info LIKE 'USA:%200%')
  116277    130230  │ │ │ TABLE SEEK cast_info AS ci WHERE ci.note IN('(voice)','(voice: Japanese version)','(voice) (uncredited)','(voice: English version)')
   40272     40272  │ │ TABLE SEEK name AS n WHERE (n.name LIKE '%Ang%') AND (n.gender = 'f')
     340       188  │ TABLE SEEK aka_name AS an
     189       189  TABLE SEEK char_name AS chn