Planner — IMDB — JOB-24A

SELECT MIN(chn.name) AS voiced_char_name,
       MIN(n.name) AS voicing_actress_name,
       MIN(t.title) AS voiced_action_movie_jap_eng
FROM job.aka_name AS an,
     job.char_name AS chn,
     job.cast_info AS ci,
     job.company_name AS cn,
     job.info_type AS it,
     job.keyword AS k,
     job.movie_companies AS mc,
     job.movie_info AS mi,
     job.movie_keyword AS mk,
     job.name AS n,
     job.role_type AS rt,
     job.title AS t
WHERE ci.note IN ('(voice)',
                  '(voice: Japanese version)',
                  '(voice) (uncredited)',
                  '(voice: English version)')
  AND cn.country_code ='[us]'
  AND it.info = 'release dates'
  AND k.keyword IN ('hero',
                    'martial-arts',
                    'hand-to-hand-combat')
  AND mi.info IS NOT NULL
  AND (mi.info LIKE 'Japan:%201%'
       OR mi.info LIKE 'USA:%201%')
  AND n.gender ='f'
  AND n.name LIKE '%An%'
  AND rt.role ='actress'
  AND t.production_year > 2010
  AND t.id = mi.movie_id
  AND t.id = mc.movie_id
  AND t.id = ci.movie_id
  AND t.id = mk.movie_id
  AND mc.movie_id = ci.movie_id
  AND mc.movie_id = mi.movie_id
  AND mc.movie_id = mk.movie_id
  AND mi.movie_id = ci.movie_id
  AND mi.movie_id = mk.movie_id
  AND ci.movie_id = mk.movie_id
  AND cn.id = mc.company_id
  AND it.id = mi.info_type_id
  AND n.id = ci.person_id
  AND rt.id = ci.role_id
  AND n.id = an.person_id
  AND ci.person_id = an.person_id
  AND chn.id = ci.person_role_id
  AND k.id = mk.keyword_id;

Engine Compare

Accuracy chart, rows processed ?
Scan Scan	Seek Seek	Join Probe Join	Sort Sort	Hash Build Hash	Aggregate Agg	Distribute Dist
Estimation Error Est Err 11,191,384 11M Rank		Estimation Error Est Err 11,236,953 11M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 57,273 57K Rank	Estimation Error Est Err 275 275 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 48,296,181 48M Rank		Estimation Error Est Err 0 Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 0 Rank	Estimation Error Est Err 0 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 12,585,452 13M Rank		Estimation Error Est Err 10,201,497 10M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 1,810,208 1.8M Rank	Estimation Error Est Err 301,523 302K Rank	Estimation Error Est Err 2,402,001 2.4M Rank
Estimation Error Est Err 24,570,544 25M Rank		Estimation Error Est Err 14,752,087 15M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 5,877,945 5.9M Rank	Estimation Error Est Err 285 285 Rank	Estimation Error Est Err 9,071,801 9.1M Rank
Estimation Error Est Err 3,452,285 3.5M Rank		Estimation Error Est Err 4,562,415 4.6M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 5,134,055 5.1M Rank	Estimation Error Est Err 275 275 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 54,292 54K Rank	Estimation Error Est Err 54,291 54K Rank	Estimation Error Est Err 68,050 68K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 57,068 57K Rank	Estimation Error Est Err 275 275 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 8,147,493 8.1M Rank	Estimation Error Est Err 8,147,478 8.1M Rank	Estimation Error Est Err 15,606,727 16M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 8,730,495 8.7M Rank	Estimation Error Est Err 820 820 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 3,690,491 3.7M Rank		Estimation Error Est Err 4,973 5K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 3,692,298 3.7M Rank	Estimation Error Est Err 291 291 Rank	Estimation Error Est Err 3,690,484 3.7M Rank

Actual Query Plans

Query Plan per Engine ?
	Query Plan
	Estimate Actual Operator 1 1 AGGREGATE min, min, min 1 275 INNER JOIN HASH ON id33 = person_id97 1 141 │└INNER JOIN HASH ON id86 = company_id 5 300 │ │└INNER JOIN HASH ON movie_id79 = movie_id61 1 36 │ │ │└INNER JOIN HASH ON id = info_type_id 1 1 │ │ │ │└TABLE SCAN info_type WHERE info = release dates 1 36 │ │ │ INNER JOIN HASH ON id68 = person_role_id 1 36 │ │ │ │└INNER JOIN HASH ON movie_id61 = movie_id 1 29 │ │ │ │ │└INNER JOIN HASH ON id45 = movie_id 1 314 │ │ │ │ │ │└INNER JOIN HASH ON id33 = person_id 6 7726 │ │ │ │ │ │ │└INNER JOIN HASH ON id6 = role_id 1 1 │ │ │ │ │ │ │ │└TABLE SCAN role_type WHERE role = actress 60 30828 │ │ │ │ │ │ │ INNER JOIN HASH ON movie_id25 = movie_id 97 9696 │ │ │ │ │ │ │ │└INNER JOIN HASH ON id11 = keyword_id 3 3 │ │ │ │ │ │ │ │ │└TABLE SCAN keyword WHERE keyword IN(hand - to - hand - combat,hero,martial - arts) 4523930 4523930 │ │ │ │ │ │ │ │ TABLE SCAN movie_keyword 707897 16500 │ │ │ │ │ │ │ TABLE SCAN cast_info WHERE note IN(voice,voice uncredited,(voice : English version),(voice : Japanese version)) 61047 93 │ │ │ │ │ │ TABLE SCAN name WHERE gender = f AND name LIKE '%An%' 365420 12 │ │ │ │ │ TABLE SCAN title WHERE production_year >= 2011 318736 16 │ │ │ │ TABLE SCAN movie_info WHERE info63 LIKE '%201%' 3140339 3140339 │ │ │ TABLE SCAN char_name 2609129 2609129 │ │ TABLE SCAN movie_companies 90648 17 │ TABLE SCAN company_name WHERE country_code = us 901343 901343 TABLE SCAN aka_name
	Estimate Actual Operator - ∞ PROJECT a1 AS voiced_char_name, a2 AS voicing_actress_name, a3 AS voiced_action_movie_jap_eng - ∞ AGGREGATE MIN(name_left) AS a1, MIN(name_right) AS a2, MIN(title) AS a3 - ∞ PROJECT name_left, name_right, title - ∞ PROJECT name_left, name_right, title - ∞ INNER JOIN HASH ON tuple(PROJECTION_2764.movie_id,PROJECTION_2764.movie_id,PROJECTION_2764.movie_id,PROJECTION_2764.movie_id,PROJECTION_2764.id,PROJECTION_2764.id) = tuple(PROJECTION_2743.movie_id,PROJECTION_2743.movie_id,PROJECTION_2743.movie_id,PROJECTION_2743.movie_id,PROJECTION_2743.movie_id,PROJECTION_2743.movie_id) - ∞ │└PROJECT movie_id_right, movie_id AS movie_id_right_2 - ∞ │ PROJECT movie_id, movie_id - ∞ │ INNER JOIN HASH ON PROJECTION_2749.info_type_id = PROJECTION_2746.id - 1 │ │└PROJECT id - 1 │ │ FILTER (1 AND info = 'release dates'_String) AS a58 - 1 │ │ TABLE SCAN info_type WHERE info = 'release dates' - ∞ │ PROJECT info_type_id, movie_id, movie_id - ∞ │ PROJECT movie_id, movie_id, info_type_id - ∞ │ INNER JOIN HASH ON PROJECTION_2755.company_id = PROJECTION_2752.id - 0 │ │└PROJECT id - 0 │ │ FILTER (1 AND country_code = 'us'_String) AS a54 - 0 │ │ TABLE SCAN company_name WHERE country_code = 'us' - ∞ │ PROJECT company_id, movie_id, movie_id, info_type_id - ∞ │ PROJECT movie_id, company_id, movie_id, info_type_id - ∞ │ INNER JOIN HASH ON PROJECTION_2761.movie_id = PROJECTION_2758.movie_id - ∞ │ │└PROJECT movie_id AS movie_id_right, info_type_id - ∞ │ │ FILTER (1 AND OR ( LIKE (info,'Japan:%201%'_String), LIKE (info,'USA:%201%'_String))) AS a46 - 301247 │ │ TABLE SCAN movie_info WHERE info LIKE 'Japan:%201%' OR info LIKE 'USA:%201%' - 2609129 │ PROJECT movie_id AS movie_id_left, company_id - 2609129 │ PROJECT movie_id, company_id - 2609129 │ TABLE SCAN movie_companies - ∞ PROJECT movie_id_left, movie_id AS movie_id_left_2, id, name, name, title - ∞ PROJECT movie_id, name, movie_id, name, title, id - ∞ INNER JOIN HASH ON PROJECTION_2770.role_id = PROJECTION_2767.id - 1 │└PROJECT id AS id_right - 1 │ FILTER (1 AND role = 'actress'_String) AS a39 - 1 │ TABLE SCAN role_type WHERE role = 'actress' - ∞ PROJECT role_id, movie_id, name, movie_id, name, title, id_left - ∞ PROJECT movie_id, role_id, name, movie_id, name, title, id - ∞ INNER JOIN HASH ON tuple(PROJECTION_2776.person_id,PROJECTION_2776.person_id) = tuple(PROJECTION_2773.id,PROJECTION_2773.id) - ∞ │└PROJECT id AS id_right, name AS name_right - ∞ │ FILTER (1 AND LIKE (name,'%An%'_String) AND gender = 'f'_String) AS a31 - 50011 │ TABLE SCAN name WHERE (gender = 'f') AND name LIKE '%An%' - ∞ PROJECT person_id, person_id, movie_id, role_id, name AS name_left, movie_id, title, id_left - ∞ PROJECT person_id, person_id, movie_id, role_id, name, movie_id, title, id - ∞ INNER JOIN HASH ON PROJECTION_2782.keyword_id = PROJECTION_2779.id - ∞ │└PROJECT id AS id_right - ∞ │ FILTER (in(keyword,__set_String_10697907583591814613_17183100778216413416) AND 1) AS a27 - 134170 │ TABLE SCAN keyword WHERE TRUE - ∞ PROJECT keyword_id, person_id, person_id, movie_id, role_id, name, movie_id, title, id AS id_left - ∞ PROJECT person_id, person_id, movie_id, role_id, name, movie_id, keyword_id, title, id - ∞ INNER JOIN HASH ON tuple(PROJECTION_2788.movie_id,PROJECTION_2788.id) = tuple(PROJECTION_2785.movie_id,PROJECTION_2785.movie_id) - 4523930 │└PROJECT movie_id AS movie_id_right, keyword_id - 4523930 │ PROJECT movie_id, keyword_id - 4523930 │ TABLE SCAN movie_keyword - ∞ PROJECT movie_id AS movie_id_left, id, person_id, person_id, role_id, name, title - ∞ PROJECT person_id, person_id, movie_id, role_id, name, title, id - ∞ INNER JOIN HASH ON PROJECTION_2794.movie_id = PROJECTION_2791.id - 391666 │└PROJECT id, title - 391666 │ FILTER (1 AND production_year > 2010_UInt16) AS a23 - 391666 │ TABLE SCAN title WHERE production_year > 2010 - ∞ PROJECT movie_id, person_id, person_id, role_id, name - ∞ PROJECT person_id, person_id, movie_id, role_id, name - ∞ INNER JOIN HASH ON PROJECTION_2806.id = PROJECTION_2797.person_role_id - ∞ │└PROJECT person_role_id, person_id, person_id, movie_id, role_id - ∞ │ PROJECT person_id, person_id, person_role_id, movie_id, role_id - ∞ │ INNER JOIN HASH ON PROJECTION_2803.person_id = PROJECTION_2800.person_id - ∞ │ │└PROJECT person_id AS person_id_right, person_role_id, movie_id, role_id - ∞ │ │ FILTER (in(note,__set_String_6680244196204786103_17565861716447275384) AND 1) AS a19 - 36244344 │ │ TABLE SCAN cast_info WHERE TRUE - 901343 │ PROJECT person_id AS person_id_left - 901343 │ PROJECT person_id - 901343 │ TABLE SCAN aka_name - 3140339 PROJECT id, name - 3140339 PROJECT name, id - 3140339 TABLE SCAN char_name
	Estimate Actual Operator - 1 AGGREGATE MIN(#0), MIN(#1), MIN(#2) 1 275 PROJECT name, name, title 1 275 INNER JOIN HASH ON id = person_role_id 1 277 │└INNER JOIN HASH ON id = person_id 1 6532 │ │└INNER JOIN HASH ON person_id = person_id 7 2778 │ │ │└INNER JOIN HASH ON role_id = id 1 1 │ │ │ │└FILTER id <= 11 1 1 │ │ │ │ TABLE SCAN role_type WHERE role = 'actress' 86 2778 │ │ │ INNER JOIN HASH ON movie_id = id 29 3406 │ │ │ │└INNER JOIN HASH ON id = keyword_id 143 1261206 │ │ │ │ │└INNER JOIN HASH ON movie_id = id 78 142261 │ │ │ │ │ │└INNER JOIN HASH ON info_type_id = id 2 1 │ │ │ │ │ │ │└FILTER id <= 110 2 1 │ │ │ │ │ │ │ TABLE SCAN info_type WHERE info = 'release dates' 4439 142261 │ │ │ │ │ │ INNER JOIN HASH ON movie_id = id 3716 128115 │ │ │ │ │ │ │└INNER JOIN HASH ON id = movie_id 18253 1153798 │ │ │ │ │ │ │ │└INNER JOIN HASH ON company_id = id 1644 84843 │ │ │ │ │ │ │ │ │└TABLE SCAN company_name WHERE country_code = 'us' 2609129 2609129 │ │ │ │ │ │ │ │ TABLE SCAN movie_companies 505662 391512 │ │ │ │ │ │ │ FILTER id BETWEEN 2 AND 2525745 505662 391666 │ │ │ │ │ │ │ TABLE SCAN title WHERE production_year > 2010 2967144 69258 │ │ │ │ │ │ FILTER movie_id BETWEEN 2 AND 2525745 2967144 69258 │ │ │ │ │ │ TABLE SCAN movie_info WHERE (info IS NOT NULL) AND ((info LIKE 'Japan:%201%') OR (info LIKE 'USA:%201%')) 4523930 160570 │ │ │ │ │ TABLE SCAN movie_keyword WHERE movie_id <= 2525745 26834 3 │ │ │ │ FILTER (keyword = 'hero') OR (keyword = 'martial-arts') OR (keyword = 'hand-to-hand-combat') 134170 134135 │ │ │ │ TABLE SCAN keyword WHERE keyword IN('hero','martial-arts','hand-to-hand-combat') 7248868 281 │ │ │ FILTER (person_id >= 4) AND (movie_id BETWEEN 2 AND 2525745) 7248868 281 │ │ │ FILTER (note = '(voice)') OR (note = '(voice: Japanese version)') OR (note = '(voice) (uncredited)') OR (note = '(voice: English version)') 36244344 2318 │ │ │ TABLE SCAN cast_info WHERE note IN('(voice)','(voice: Japanese version)','(voice) (uncredited)','(voice: English version)') 901343 348 │ │ TABLE SCAN aka_name WHERE person_id <= 4061926 2083746 5 │ FILTER id BETWEEN 4 AND 4061926 2083746 5 │ TABLE SCAN "name" WHERE gender = 'f' AND contains(name,'An') 3140339 11 TABLE SCAN char_name
	Estimate Actual Operator 1 1 PROJECT voiced_char_name, voicing_actress_name, voiced_action_movie_jap_eng 1 1 AGGREGATE MIN(name), MIN(name), MIN(title) 7972 10 DISTRIBUTE GATHER 7972 10 AGGREGATE MIN(name), MIN(name), MIN(title) 7972 275 INNER JOIN HASH ON movie_id = id AND movie_id = id AND movie_id = id AND movie_id = id 7972 707 │└DISTRIBUTE GATHER 7972 707 │ 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' 29231 707 │ INNER JOIN HASH ON person_id = id AND person_id = id 29231 15868 │ │└DISTRIBUTE GATHER 29231 15868 │ │ INNER JOIN HASH ON id = keyword_id 26834 3 │ │ │└DISTRIBUTE GATHER 26834 3 │ │ │ FILTER ((keyword = 'hero') OR (keyword = 'martial-arts')) OR (keyword = 'hand-to-hand-combat') 134170 134170 │ │ │ DISTRIBUTE ROUND ROBIN 134170 134170 │ │ │ TABLE SCAN keyword WHERE ((keyword = 'hero') OR (keyword = 'martial-arts')) OR (keyword = 'hand-to-hand-combat') 146157 2417390 │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id AND movie_id = movie_id 81608 97873 │ │ │└DISTRIBUTE GATHER 81608 97873 │ │ │ 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' 390302 97873 │ │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id 332330 490029 │ │ │ │└DISTRIBUTE HASH ON movie_id, movie_id 332330 490029 │ │ │ │ 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' 1661629 930328 │ │ │ │ INNER JOIN HASH ON movie_id = movie_id 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... 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... 2609129 2609129 │ │ │ │ DISTRIBUTE HASH ON movie_id 2609129 2609129 │ │ │ │ TABLE SCAN movie_companies WHERE CASE MOD(HASH_REPARTITION movie_id,10) WHEN 0 THEN (((movie_id >= 920) AND (movie_id <= 2525688)) AND TRUE) WHEN 1 THEN (((movie_id >= 1126) AND (movie_id <= 2525697)) AND TRUE) WHEN 2 THEN (((movie_id >= 921) AND (movie_id <= 2525701)) AND TRUE) WHEN 3 THEN (((movie_id >= 912) AND (movie_id <= 2525700)) AND TRUE) WHEN 4 THEN (((movie_id >= 925) AND (movie_id <= 2525205)) AND TRUE) WHEN 5 THEN (((movie_id >= 908) AND (movie_... 2967144 301243 │ │ │ DISTRIBUTE HASH ON movie_id, movie_id 2967144 301243 │ │ │ FILTER info IS NOT NULL AND (info LIKE 'Japan:%201%' OR info LIKE 'USA:%201%') 14835720 3212639 │ │ │ TABLE SCAN movie_info WHERE ((info IS NOT NULL AND (info LIKE 'Japan:%201%' OR info LIKE 'USA:%201%')) AND CASE MOD(HASH_REPARTITION(movie_id,movie_id),10) WHEN 1 THEN ((((movie_id >= 908) AND (movie_id <= 2525701)) AND ((movie_id >= 908) AND (movie_id <= 2525701))) AND TRUE) WHEN 3 THEN ((((movie_id >= 909) AND (movie_id <= 2525698)) AND ((movie_id >= 909) AND (movie_id <= 2525698))) AND TRUE) WHEN 5 THEN ((((movie_id >= 910) AND (movie_id <= 2525691)) AND ((m... 4523930 4523930 │ │ TABLE SCAN movie_keyword WHERE (((((movie_id >= 6599) AND (movie_id <= 2521362)) AND ((movie_id >= 6599) AND (movie_id <= 2521362))) AND ((movie_id >= 6599) AND (movie_id <= 2521362))) AND TRUE) AND (((keyword_id >= 1535) AND (keyword_id <= 7637)) AND keyword_id IN(1535,7637,7633)) 833499 50011 │ FILTER (gender = 'f') AND name LIKE '%An%' 4167491 983636 │ TABLE SCAN name WHERE ((gender = 'f') AND name LIKE '%An%') AND ((((id >= 1740244) AND (id <= 2697033)) AND ((id >= 1740244) AND (id <= 2697033))) AND TRUE) 162535 163334 FILTER production_year > 2010 2528312 1173690 TABLE SCAN title WHERE (production_year > 2010) AND ((((((id >= 1710108) AND (id <= 2445637)) AND ((id >= 1710108) AND (id <= 2445637))) AND ((id >= 1710108) AND (id <= 2445637))) AND ((id >= 1710108) AND (id <= 2445637))) AND struct(id,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...
	Estimate Actual Operator 3 0 SEQUENCE 1 1 ├─AGGREGATE MIN(chn.name), MIN(n.name), MIN(t.title) 1 1 │ DISTRIBUTE GATHER 1 1 │ AGGREGATE MIN(chn.name), MIN(n.name), MIN(t.title) 3750 275 │ INNER JOIN HASH ON mi.info_type_id = it.id 3750 1 │ │└DISTRIBUTE GATHER 134000 1 │ │ TABLE SCAN info_type WHERE it.info = 'release dates' 3750 275 │ INNER JOIN HASH ON ci.movie_id = mi.movie_id 3750 1154 │ │└DISTRIBUTE HASH ON mi.movie_id, mi.movie_id, mi.movie_id, mi.movie_id 164000 1154 │ │ FILTER 2530000 301247 │ │ TABLE SCAN movie_info WHERE mi.info LIKE 'Japan:%201%' OR mi.info LIKE 'USA:%201%' 595 125 │ INNER JOIN HASH ON ci.person_id = an.person_id 595 901343 │ │└DISTRIBUTE GATHER 36200000 901343 │ │ TABLE SCAN aka_name 375 107 │ INNER JOIN HASH ON mc.company_id = cn.id 375 84843 │ │└DISTRIBUTE GATHER 3140000 84843 │ │ TABLE SCAN company_name WHERE (cn.country_code IS NOT NULL) AND (cn.country_code = 'us') 363 178 │ INNER JOIN HASH ON ci.movie_id = mc.movie_id 363 29 │ │└DISTRIBUTE GATHER 142 29 │ │ INNER JOIN HASH ON ci.person_id = n.id 142 588 │ │ │└DISTRIBUTE GATHER 142 588 │ │ │ INNER JOIN HASH ON ci.person_role_id = chn.id 142 588 │ │ │ │└DISTRIBUTE GATHER 142 588 │ │ │ │ INNER JOIN HASH ON ci.role_id = rt.id 142 1 │ │ │ │ │└DISTRIBUTE GATHER 235000 1 │ │ │ │ │ TABLE SCAN role_type WHERE rt.role = 'actress' 142 2568 │ │ │ │ INNER JOIN HASH ON mk.movie_id = ci.movie_id 142 801259 │ │ │ │ │└DISTRIBUTE GATHER 901000 801259 │ │ │ │ │ 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) 112 495 │ │ │ │ INNER JOIN HASH ON mk.movie_id = t.id 112 9696 │ │ │ │ │└DISTRIBUTE GATHER 106 9696 │ │ │ │ │ INNER JOIN HASH ON mk.keyword_id = k.id 106 3 │ │ │ │ │ │└DISTRIBUTE GATHER - 3 │ │ │ │ │ │ TABLE SCAN keyword WHERE k.keyword IN('hero','martial-arts','hand-to-hand-combat') 113 4519836 │ │ │ │ │ TABLE SCAN movie_keyword 14800000 390312 │ │ │ │ TABLE SCAN title WHERE (t.production_year IS NOT NULL) AND (t.production_year > 2010L) 2610000 3115766 │ │ │ TABLE SCAN char_name 4170000 35600 │ │ TABLE SCAN name WHERE (n.gender IS NOT NULL) AND (n.gender = 'f') AND contains(n.name,'An') 12 2133994 │ TABLE SCAN movie_companies 3 0 └─FILTER 4520000 1 DISTRIBUTE HASH 4520000 1 AGGREGATE bloom_filter_agg(bloom_expr(mk.movie_id,mk.movie_id),9696L,131072L) 4520000 301247 DISTRIBUTE HASH 4520000 301247 DISTRIBUTE HASH 4520000 301247 TABLE SCAN movie_info WHERE mi.info LIKE 'Japan:%201%' OR mi.info LIKE 'USA:%201%'
	Estimate Actual Operator 1 1 AGGREGATE MIN(name as name) AS Expr1024, MIN(name as name) AS Expr1025, MIN(title as title) AS Expr1026 1 820 INNER JOIN LOOP ON Bmk1002 = Bmk1002 1 820 │└TABLE SEEK char_name AS chn 1 820 PROJECT BmkToPage Bmk1002 AS Expr1086 1 820 INNER JOIN LOOP ON ci.person_role_id = chn.id 1 820 │└TABLE SEEK char_name AS chn 17 824 FILTER country_code as country_code = 'us' 48 2954 INNER JOIN LOOP ON Bmk1006 = Bmk1006 1 2954 │└TABLE SEEK company_name AS cn 48 2954 INNER JOIN LOOP ON mc.company_id = cn.id 1 2954 │└TABLE SEEK company_name AS cn 48 2954 INNER JOIN LOOP ON Bmk1012 = Bmk1012 1 2954 │└TABLE SEEK movie_companies AS mc 48 2954 PROJECT BmkToPage Bmk1012 AS Expr1082 48 2954 INNER JOIN LOOP ON t.id = mc.movie_id 9 2954 │└TABLE SEEK movie_companies AS mc 4 325 INNER JOIN LOOP ON n.id = an.person_id 4 325 │└TABLE SEEK aka_name AS an 1 189 FILTER name as name LIKE '%An%' AND gender as gender = 'f' 1 990 INNER JOIN LOOP ON Bmk1018 = Bmk1018 1 990 │└TABLE SEEK name AS n 1 990 PROJECT BmkToPage Bmk1018 AS Expr1081 1 990 INNER JOIN LOOP ON ci.person_id = n.id 1 990 │└TABLE SEEK name AS n 1 990 INNER JOIN LOOP ON Bmk1022 = Bmk1022 1 990 │└TABLE SEEK title AS t WHERE production_year as production_year > 2010 1 2455 PROJECT BmkToPage Bmk1022 AS Expr1080 1 2455 INNER JOIN LOOP ON mk.movie_id = t.id 1 2455 │└TABLE SEEK title AS t 1 2455 FILTER info as info = 'release dates' 25 2455 INNER JOIN LOOP ON Bmk1008 = Bmk1008 1 2455 │└TABLE SEEK info_type AS it 25 2455 INNER JOIN LOOP ON mi.info_type_id = it.id 1 2455 │└TABLE SEEK info_type AS it 25 2455 INNER JOIN LOOP ON mk.movie_id = mi.movie_id 1 2455 │└TABLE SEEK movie_info AS mi WHERE info as info LIKE 'Japan:%201%' OR info as info LIKE 'USA:%201%' 17 8262 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)' 747 66525 INNER JOIN LOOP ON Bmk1004 = Bmk1004 1 66525 │└TABLE SEEK cast_info AS ci 747 66525 PROJECT BmkToPage Bmk1004 AS Expr1078 747 66525 INNER JOIN HASH ON Bmk1004 = Bmk1004 8223 583017 │└INNER JOIN LOOP ON mk.movie_id = ci.movie_id 30 583017 │ │└TABLE SEEK cast_info AS ci 272 9696 │ INNER JOIN LOOP ON Bmk1016 = Bmk1016 1 9696 │ │└TABLE SEEK movie_keyword AS mk 272 9696 │ INNER JOIN LOOP ON k.id = mk.keyword_id 90 9696 │ │└TABLE SEEK movie_keyword AS mk 3 3 │ TABLE SCAN keyword AS k WHERE keyword as keyword = 'hand-to-hand-combat' OR keyword as keyword = 'hero' OR keyword as keyword = 'martial-arts' 3294940 7451973 INNER JOIN LOOP ON rt.id = ci.role_id 3294940 7451973 │└TABLE SEEK cast_info AS ci 1 1 FILTER role as role = 'actress' 12 12 TABLE SCAN role_type AS rt
	Estimate Actual Operator 1 ∞ PROJECT min AS voiced_char_name, min_71 AS voicing_actress_name, min_72 AS voiced_action_movie_jap_eng 1 1 AGGREGATE MIN(min_73) AS min, MIN(min_74) AS min_71, MIN(min_75) AS min_72 - 16 DISTRIBUTE GATHER - 16 AGGREGATE MIN(name_1) AS min_73, MIN(name_49) AS min_74, MIN(title) AS min_75 - 275 INNER JOIN HASH ON movie_id = id_63 159036 391666 │└DISTRIBUTE HASH ON id_63 159036 391666 │ PROJECT id AS id_63, title 159036 391666 │ FILTER production_year > 2010 159036 391666 │ TABLE SCAN title - 707 INNER JOIN HASH ON role_id = id_59 12 1 │└DISTRIBUTE GATHER 12 1 │ PROJECT id AS id_59 12 1 │ FILTER role = 'actress' 12 1 │ TABLE SCAN role_type - 707 INNER JOIN HASH ON person_id_10 = id_48 4167491 50011 │└DISTRIBUTE HASH ON id_48 4167491 50011 │ PROJECT id AS id_48, name AS name_49 4167491 50011 │ FILTER (gender = 'f') AND (name LIKE '%An%') 4167491 50011 │ TABLE SCAN name - 707 INNER JOIN HASH ON keyword_id = id_26 134170 3 │└DISTRIBUTE GATHER 134170 3 │ PROJECT id AS id_26 134170 3 │ FILTER keyword IN('hand-to-hand-combat','hero','martial-arts') 134170 3 │ TABLE SCAN keyword - 707 INNER JOIN HASH ON movie_id = movie_id_44 4523930 9696 │└DISTRIBUTE HASH ON movie_id_44 4523930 9696 │ PROJECT movie_id AS movie_id_44, keyword_id 4523930 9696 │ TABLE SCAN movie_keyword - 421 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 - 421 INNER JOIN HASH ON movie_id = movie_id_37 13352148 1067 │└DISTRIBUTE HASH ON movie_id_37 13352148 1067 │ PROJECT movie_id AS movie_id_37, info_type_id 13352148 1067 │ FILTER (((info >= 'Japan:') AND (info < 'Japan;')) OR ((info >= 'USA:') AND (info < 'USA;'))) AND ((info LIKE 'Japan:%201%') OR (info LIKE 'USA:%201%')) 13352148 1067 │ TABLE SCAN movie_info - 230 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 - 230 INNER JOIN HASH ON movie_id = movie_id_31 2609129 2316 │└DISTRIBUTE HASH ON movie_id_31 2609129 2316 │ PROJECT movie_id AS movie_id_31, company_id 2609129 2316 │ TABLE SCAN movie_companies - 67 INNER JOIN HASH ON person_role_id = id_0 3140339 3140339 │└DISTRIBUTE HASH ON id_0 3140339 3140339 │ PROJECT id AS id_0, name AS name_1 3140339 3140339 │ TABLE SCAN char_name - 68 INNER JOIN HASH ON person_id_10 = person_id 901343 10525 │└DISTRIBUTE GATHER 901343 10525 │ TABLE SCAN aka_name 32619910 23 PROJECT person_id AS person_id_10, movie_id, person_role_id, role_id 32619910 23 FILTER note IN('(voice)','(voice) (uncredited)','(voice: English version)','(voice: Japanese version)') 32619910 23 TABLE SCAN cast_info
	Estimate Actual Operator 1 1 AGGREGATE MIN(name), MIN(name), MIN(title) 1 275 INNER JOIN LOOP ON person_id = person_id AND person_id = id AND (person_id = id) 1 141 │└INNER JOIN LOOP ON id = person_role_id 1 143 │ │└INNER JOIN LOOP ON id = person_id 1 2778 │ │ │└INNER JOIN LOOP ON keyword IN('hero','martial-arts','hand-to-hand-combat') AND role_id = id AND (role_id = id) 1 1 │ │ │ │└TABLE SCAN role_type AS rt WHERE rt.role = 'actress' 1 13758 │ │ │ INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id) 1 3406 │ │ │ │└INNER JOIN LOOP ON id = info_type_id 1 3406 │ │ │ │ │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id) 6 1576 │ │ │ │ │ │└INNER JOIN LOOP ON id = company_id 17 5566 │ │ │ │ │ │ │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id) 16 495 │ │ │ │ │ │ │ │└INNER JOIN LOOP ON id = movie_id 101 9696 │ │ │ │ │ │ │ │ │└INNER JOIN LOOP ON keyword_id = id 3 3 │ │ │ │ │ │ │ │ │ │└TABLE SEEK keyword AS k 915 9696 │ │ │ │ │ │ │ │ │ TABLE SEEK movie_keyword AS mk 9696 9696 │ │ │ │ │ │ │ │ TABLE SEEK title AS t WHERE t.production_year > 2010 2475 5563 │ │ │ │ │ │ │ TABLE SEEK movie_companies AS mc 5566 5566 │ │ │ │ │ │ TABLE SEEK company_name AS cn WHERE cn.country_code = 'us' 1576 3404 │ │ │ │ │ TABLE SEEK movie_info AS mi WHERE (mi.info LIKE 'Japan:%201%') OR (mi.info LIKE 'USA:%201%') 3406 3406 │ │ │ │ TABLE SEEK info_type AS it WHERE it.info = 'release dates' 3406 13760 │ │ │ TABLE SEEK cast_info AS ci WHERE ci.note IN('(voice)','(voice: Japanese version)','(voice) (uncredited)','(voice: English version)') 2778 2778 │ │ TABLE SEEK name AS n WHERE (n.name LIKE '%An%') AND (n.gender = 'f') 143 143 │ TABLE SEEK char_name AS chn 282 274 TABLE SEEK aka_name AS an