Planner — IMDB — JOB-24B

SELECT MIN(chn.name) AS voiced_char_name,
       MIN(n.name) AS voicing_actress_name,
       MIN(t.title) AS kung_fu_panda
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 cn.name = 'DreamWorks Animation'
  AND it.info = 'release dates'
  AND k.keyword IN ('hero',
                    'martial-arts',
                    'hand-to-hand-combat',
                    'computer-animated-movie')
  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.title LIKE 'Kung Fu Panda%'
  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,174,811 11M Rank		Estimation Error Est Err 11,174,981 11M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 544 544 Rank	Estimation Error Est Err 45 45 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 47,904,523 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 11,379,635 11M Rank		Estimation Error Est Err 10,581,990 11M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 822,710 823K Rank	Estimation Error Est Err 49 49 Rank	Estimation Error Est Err 811,112 811K Rank
Estimation Error Est Err 25,187,381 25M Rank		Estimation Error Est Err 11,067,584 11M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 2,083,914 2.1M Rank	Estimation Error Est Err 55 55 Rank	Estimation Error Est Err 7,768,969 7.8M Rank
Estimation Error Est Err 660 660 Rank		Estimation Error Est Err 793 793 Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 1,285 1.3K Rank	Estimation Error Est Err 45 45 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 706 706 Rank	Estimation Error Est Err 706 706 Rank	Estimation Error Est Err 705 705 Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 705 705 Rank	Estimation Error Est Err 45 45 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 5,437 5.4K Rank	Estimation Error Est Err 5,436 5.4K Rank	Estimation Error Est Err 5,498 5.5K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 5,436 5.4K Rank	Estimation Error Est Err 57 57 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 3,200,908 3.2M Rank		Estimation Error Est Err 335 335 Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 3,201,135 3.2M Rank	Estimation Error Est Err 61 61 Rank	Estimation Error Est Err 3,200,921 3.2M Rank

Actual Query Plans

Query Plan per Engine ?
	Query Plan
	Estimate Actual Operator 1 1 AGGREGATE min, min, min 1 45 INNER JOIN HASH ON id60 = person_id97 1 9 │└INNER JOIN HASH ON id = info_type_id 1 1 │ │└TABLE SCAN info_type WHERE info = release dates 1 9 │ INNER JOIN HASH ON id6 = keyword_id 4 3 │ │└TABLE SCAN keyword WHERE keyword IN(computer - animated - movie,hand - to - hand - combat,hero,martial - arts) 2 162 │ INNER JOIN HASH ON id35 = movie_id91 1 5 │ │└INNER JOIN HASH ON id80 = person_role_id 1 5 │ │ │└INNER JOIN HASH ON id35 = movie_id73 1 3 │ │ │ │└INNER JOIN HASH ON id12 = role_id 1 1 │ │ │ │ │└TABLE SCAN role_type WHERE role = actress 1 3 │ │ │ │ INNER JOIN HASH ON id60 = person_id 1 54 │ │ │ │ │└INNER JOIN HASH ON id35 = movie_id52 1 4 │ │ │ │ │ │└INNER JOIN HASH ON id35 = movie_id 11 99 │ │ │ │ │ │ │└INNER JOIN HASH ON id17 = company_id 1 1 │ │ │ │ │ │ │ │└TABLE SCAN company_name WHERE name = DreamWorks Animation AND country_code = us 2609129 2609129 │ │ │ │ │ │ │ TABLE SCAN movie_companies 979 4 │ │ │ │ │ │ TABLE SCAN title WHERE production_year >= 2011 AND title) Kung Fu Panda 408889 54 │ │ │ │ │ TABLE SCAN cast_info WHERE note54 IN(voice,voice uncredited,(voice : English version),(voice : Japanese version)) 61047 1 │ │ │ │ TABLE SCAN name WHERE gender = f AND name61 LIKE '%An%' 318736 5 │ │ │ TABLE SCAN movie_info WHERE info75 LIKE '%201%' 3140339 3140339 │ │ TABLE SCAN char_name 4523930 4523930 │ TABLE SCAN movie_keyword 901343 901343 TABLE SCAN aka_name
	Estimate Actual Operator - ∞ PROJECT a1 AS voiced_char_name, a2 AS voicing_actress_name, a3 AS kung_fu_panda - ∞ 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_2835.movie_id,PROJECTION_2835.movie_id,PROJECTION_2835.movie_id,PROJECTION_2835.movie_id,PROJECTION_2835.id,PROJECTION_2835.id) = tuple(PROJECTION_2814.movie_id,PROJECTION_2814.movie_id,PROJECTION_2814.movie_id,PROJECTION_2814.movie_id,PROJECTION_2814.movie_id,PROJECTION_2814.movie_id) - ∞ │└PROJECT movie_id_right, movie_id AS movie_id_right_2 - ∞ │ PROJECT movie_id, movie_id - ∞ │ INNER JOIN HASH ON PROJECTION_2820.keyword_id = PROJECTION_2817.id - ∞ │ │└PROJECT id - ∞ │ │ FILTER (in(keyword,__set_String_13023089698670707103_6979441737884043336) AND 1) AS a66 - 134170 │ │ TABLE SCAN keyword WHERE TRUE - ∞ │ PROJECT keyword_id, movie_id, movie_id - ∞ │ PROJECT movie_id, movie_id, keyword_id - ∞ │ INNER JOIN HASH ON PROJECTION_2826.movie_id = PROJECTION_2823.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 - ∞ │ PROJECT movie_id - ∞ │ INNER JOIN HASH ON PROJECTION_2832.info_type_id = PROJECTION_2829.id - 1 │ │└PROJECT id - 1 │ │ FILTER (1 AND info = 'release dates'_String) AS a62 - 1 │ │ TABLE SCAN info_type WHERE info = 'release dates' - ∞ │ PROJECT info_type_id, movie_id - ∞ │ FILTER (1 AND OR ( LIKE (info,'Japan:%201%'_String), LIKE (info,'USA:%201%'_String))) AS a54 - 301247 │ TABLE SCAN movie_info WHERE info LIKE 'Japan:%201%' OR info LIKE 'USA:%201%' - ∞ 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_2841.role_id = PROJECTION_2838.id - 1 │└PROJECT id AS id_right - 1 │ FILTER (1 AND role = 'actress'_String) AS a47 - 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_2847.person_id,PROJECTION_2847.person_id) = tuple(PROJECTION_2844.id,PROJECTION_2844.id) - ∞ │└PROJECT id AS id_right, name AS name_right - ∞ │ FILTER (1 AND LIKE (name,'%An%'_String) AND gender = 'f'_String) AS a39 - 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 AS id_left - ∞ PROJECT person_id, person_id, movie_id, role_id, name, movie_id, title, id - ∞ INNER JOIN HASH ON tuple(PROJECTION_2853.movie_id,PROJECTION_2853.movie_id) = tuple(PROJECTION_2850.id,PROJECTION_2850.id) - 8 │└PROJECT id, title - 8 │ FILTER (1 AND production_year > 2010_UInt16 AND startsWith(title,'Kung Fu Panda'_String)) AS a31 - 8 │ TABLE SCAN title WHERE (production_year > 2010) AND startsWith(title,'Kung Fu Panda') - ∞ PROJECT movie_id, movie_id, person_id, person_id, role_id, name - ∞ PROJECT person_id, person_id, movie_id, role_id, name, movie_id - ∞ INNER JOIN HASH ON PROJECTION_2859.company_id = PROJECTION_2856.id - 0 │└PROJECT id - 0 │ FILTER (1 AND country_code = 'us'_String AND name = 'DreamWorks Animation'_String) AS a23 - 0 │ TABLE SCAN company_name WHERE (country_code = 'us') AND (name = 'DreamWorks Animation') - ∞ PROJECT company_id, person_id, person_id, movie_id, role_id, name, movie_id - ∞ PROJECT person_id, person_id, movie_id, role_id, name, movie_id, company_id - ∞ INNER JOIN HASH ON PROJECTION_2865.movie_id = PROJECTION_2862.movie_id - 2609129 │└PROJECT movie_id AS movie_id_right, company_id - 2609129 │ PROJECT movie_id, company_id - 2609129 │ TABLE SCAN movie_companies - ∞ PROJECT movie_id AS movie_id_left, person_id, person_id, role_id, name - ∞ PROJECT person_id, person_id, movie_id, role_id, name - ∞ INNER JOIN HASH ON PROJECTION_2877.id = PROJECTION_2868.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_2874.person_id = PROJECTION_2871.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) 0 45 PROJECT name, name, title 0 45 INNER JOIN HASH ON id = person_role_id 0 45 │└INNER JOIN HASH ON id = person_id 0 110 │ │└INNER JOIN HASH ON person_id = person_id 0 62 │ │ │└INNER JOIN HASH ON id = role_id 0 244 │ │ │ │└INNER JOIN HASH ON movie_id = id 0 9 │ │ │ │ │└INNER JOIN HASH ON id = keyword_id 0 162 │ │ │ │ │ │└INNER JOIN HASH ON movie_id = id 0 5 │ │ │ │ │ │ │└INNER JOIN HASH ON info_type_id = id 2 1 │ │ │ │ │ │ │ │└FILTER id <= 110 2 1 │ │ │ │ │ │ │ │ TABLE SCAN info_type WHERE info = 'release dates' 5 5 │ │ │ │ │ │ │ INNER JOIN HASH ON movie_id = id 4 4 │ │ │ │ │ │ │ │└INNER JOIN HASH ON id = movie_id 22 99 │ │ │ │ │ │ │ │ │└INNER JOIN HASH ON company_id = id 2 1 │ │ │ │ │ │ │ │ │ │└TABLE SCAN company_name WHERE country_code = 'us' AND name = 'DreamWorks Animation' 2609129 99 │ │ │ │ │ │ │ │ │ TABLE SCAN movie_companies 505662 4 │ │ │ │ │ │ │ │ FILTER id BETWEEN 2 AND 2525745 505662 4 │ │ │ │ │ │ │ │ TABLE SCAN title WHERE production_year > 2010 AND title >= 'Kung Fu Panda' AND title < 'Kung Fu Pandb' 2967144 8 │ │ │ │ │ │ │ FILTER movie_id BETWEEN 2 AND 2525745 2967144 8 │ │ │ │ │ │ │ TABLE SCAN movie_info WHERE (info IS NOT NULL) AND ((info LIKE 'Japan:%201%') OR (info LIKE 'USA:%201%')) 4523930 74 │ │ │ │ │ │ TABLE SCAN movie_keyword WHERE movie_id <= 2525745 26834 2 │ │ │ │ │ FILTER (keyword = 'hero') OR (keyword = 'martial-arts') OR (keyword = 'hand-to-hand-combat') OR (keyword = 'computer-animated-movie') 134170 118 │ │ │ │ │ TABLE SCAN keyword WHERE keyword IN('hero','martial-arts','hand-to-hand-combat','computer-animated-movie') 7248868 106 │ │ │ │ FILTER (person_id >= 4) AND (movie_id BETWEEN 2 AND 2525745) 7248868 106 │ │ │ │ FILTER (note = '(voice)') OR (note = '(voice: Japanese version)') OR (note = '(voice) (uncredited)') OR (note = '(voice: English version)') 36244344 326 │ │ │ │ TABLE SCAN cast_info WHERE note IN('(voice)','(voice: Japanese version)','(voice) (uncredited)','(voice: English version)') 1 1 │ │ │ FILTER id <= 11 1 1 │ │ │ TABLE SCAN role_type WHERE role = 'actress' 901343 26 │ │ TABLE SCAN aka_name WHERE person_id <= 4061926 2083746 1 │ FILTER id BETWEEN 4 AND 4061926 2083746 1 │ TABLE SCAN "name" WHERE gender = 'f' AND contains(name,'An') 3140339 1 TABLE SCAN char_name
	Estimate Actual Operator 1 1 PROJECT voiced_char_name, voicing_actress_name, kung_fu_panda 1 1 AGGREGATE MIN(name), MIN(name), MIN(title) 7972 10 DISTRIBUTE GATHER 7972 10 AGGREGATE MIN(name), MIN(name), MIN(title) 7972 45 INNER JOIN HASH ON movie_id = id AND movie_id = id AND movie_id = id AND movie_id = id 7972 75 │└DISTRIBUTE GATHER 7972 75 │ 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 75 │ INNER JOIN HASH ON person_id = id AND person_id = id 29231 310 │ │└DISTRIBUTE GATHER 29231 310 │ │ INNER JOIN HASH ON id = keyword_id 26834 3 │ │ │└DISTRIBUTE GATHER 26834 3 │ │ │ FILTER keyword IN('hero','martial-arts','hand-to-hand-combat','computer-animated-movie') 134170 134170 │ │ │ DISTRIBUTE ROUND ROBIN 134170 134170 │ │ │ TABLE SCAN keyword WHERE keyword IN('hero','martial-arts','hand-to-hand-combat','computer-animated-movie') 146157 27790 │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id AND movie_id = movie_id 81608 405 │ │ │└DISTRIBUTE GATHER 81608 405 │ │ │ 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 405 │ │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id 332330 602 │ │ │ │└DISTRIBUTE HASH ON movie_id, movie_id 332330 602 │ │ │ │ INNER JOIN HASH ON id = company_id 47000 1 │ │ │ │ │└DISTRIBUTE GATHER 47000 1 │ │ │ │ │ FILTER (country_code = 'us') AND (name = 'DreamWorks Animation') 234997 234997 │ │ │ │ │ TABLE SCAN company_name WHERE (country_code = 'us') AND (name = 'DreamWorks Animation') 1661629 634599 │ │ │ │ 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 1994224 │ │ │ │ DISTRIBUTE HASH ON movie_id 2609129 1994224 │ │ │ │ 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 >= 1718645) AND (movie_id <= 2408596)) AND ((movie_id >= 1718645) AND (movie_id <= 2408596))) AND struct(movie_id,movie_id) IN( < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < ... 4523930 4401050 │ │ TABLE SCAN movie_keyword WHERE (((((movie_id >= 882457) AND (movie_id <= 2454060)) AND ((movie_id >= 882457) AND (movie_id <= 2454060))) AND ((movie_id >= 882457) AND (movie_id <= 2454060))) AND struct(movie_id,movie_id,movie_id) IN( < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < ex... 833499 50011 │ FILTER (gender = 'f') AND name LIKE '%An%' 4167491 983636 │ TABLE SCAN name WHERE ((gender = 'f') AND name LIKE '%An%') AND ((((id >= 1763943) AND (id <= 2687024)) AND ((id >= 1763943) AND (id <= 2687024))) AND struct(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 > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr ... 505663 8 FILTER (production_year > 2010) AND title LIKE 'Kung Fu Panda%' 2528312 2528312 TABLE SCAN title WHERE ((production_year > 2010) AND title LIKE 'Kung Fu Panda%') AND ((((((id >= 2028522) AND (id <= 2285023)) AND ((id >= 2028522) AND (id <= 2285023))) AND ((id >= 2028522) AND (id <= 2285023))) AND ((id >= 2028522) AND (id <= 2285023))) AND TRUE)
	Estimate Actual Operator 1 1 AGGREGATE MIN(chn.name), MIN(n.name), MIN(t.title) 1 4 DISTRIBUTE GATHER 1 4 AGGREGATE MIN(chn.name), MIN(n.name), MIN(t.title) 279 45 INNER JOIN HASH ON ci.movie_id = mi.movie_id 279 15 │└DISTRIBUTE GATHER 176 15 │ INNER JOIN HASH ON ci.person_id = an.person_id 176 3 │ │└DISTRIBUTE GATHER 176 3 │ │ INNER JOIN HASH ON ci.person_id = n.id 176 15 │ │ │└DISTRIBUTE GATHER 76 15 │ │ │ INNER JOIN HASH ON ci.person_role_id = chn.id 76 15 │ │ │ │└DISTRIBUTE GATHER 12 15 │ │ │ │ INNER JOIN HASH ON ci.role_id = rt.id 12 1 │ │ │ │ │└DISTRIBUTE GATHER 2530000 1 │ │ │ │ │ TABLE SCAN role_type WHERE rt.role = 'actress' 176 54 │ │ │ │ INNER JOIN HASH ON mc.movie_id = ci.movie_id 176 801259 │ │ │ │ │└DISTRIBUTE GATHER 12 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) 150 4 │ │ │ │ INNER JOIN HASH ON mc.movie_id = t.id 150 99 │ │ │ │ │└DISTRIBUTE GATHER 150 99 │ │ │ │ │ INNER JOIN HASH ON mc.company_id = cn.id 150 1 │ │ │ │ │ │└DISTRIBUTE GATHER 901000 1 │ │ │ │ │ │ TABLE SCAN company_name WHERE (cn.country_code IS NOT NULL) AND (cn.country_code = 'us') AND (cn.name = 'DreamWorks Animation') 4170000 2129898 │ │ │ │ │ TABLE SCAN movie_companies 3140000 6 │ │ │ │ TABLE SCAN title WHERE (t.production_year IS NOT NULL) AND (t.production_year > 2010L) AND startswith(t.title,'Kung Fu Panda') 134000 3021557 │ │ │ TABLE SCAN char_name 113 19346 │ │ TABLE SCAN name WHERE (n.gender IS NOT NULL) AND (n.gender = 'f') AND contains(n.name,'An') 2610000 594144 │ TABLE SCAN aka_name 176 1756 INNER JOIN HASH ON mi.info_type_id = it.id 176 1 │└DISTRIBUTE GATHER 235000 1 │ TABLE SCAN info_type WHERE it.info = 'release dates' 176 1756 INNER JOIN HASH ON mk.movie_id = mi.movie_id 176 9696 │└DISTRIBUTE GATHER 76 9696 │ INNER JOIN HASH ON mk.keyword_id = k.id 76 3 │ │└DISTRIBUTE GATHER 36200000 3 │ │ TABLE SCAN keyword WHERE k.keyword IN('hero','martial-arts','hand-to-hand-combat','computer-animated-movie') 4520000 4519836 │ TABLE SCAN movie_keyword 14800000 293583 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 57 FILTER keyword as keyword = 'computer-animated-movie' OR keyword as keyword = 'hand-to-hand-combat' OR keyword as keyword = 'hero' OR keyword as keyword = 'martial-arts' 18 900 INNER JOIN LOOP ON Bmk1010 = Bmk1010 1 900 │└TABLE SEEK keyword AS k 18 900 INNER JOIN LOOP ON mk.keyword_id = k.id 1 900 │└TABLE SEEK keyword AS k 18 900 INNER JOIN LOOP ON Bmk1016 = Bmk1016 1 900 │└TABLE SEEK movie_keyword AS mk 18 900 INNER JOIN LOOP ON t.id = mk.movie_id 18 900 │└TABLE SEEK movie_keyword AS mk 1 31 INNER JOIN LOOP ON Bmk1002 = Bmk1002 1 31 │└TABLE SEEK char_name AS chn 1 31 PROJECT BmkToPage Bmk1002 AS Expr1103 1 31 INNER JOIN LOOP ON ci.person_role_id = chn.id 1 31 │└TABLE SEEK char_name AS chn 1 31 INNER JOIN LOOP ON n.id = an.person_id 4 31 │└TABLE SEEK aka_name AS an 1 9 FILTER name as name LIKE '%An%' AND gender as gender = 'f' 1 32 INNER JOIN LOOP ON Bmk1018 = Bmk1018 1 32 │└TABLE SEEK name AS n 1 32 PROJECT BmkToPage Bmk1018 AS Expr1102 1 32 INNER JOIN LOOP ON ci.person_id = n.id 1 32 │└TABLE SEEK name AS n 1 32 FILTER role as role = 'actress' 1 125 INNER JOIN LOOP ON Bmk1020 = Bmk1020 1 125 │└TABLE SEEK role_type AS rt 1 125 INNER JOIN LOOP ON ci.role_id = rt.id 1 125 │└TABLE SEEK role_type AS rt 1 125 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)' 30 540 INNER JOIN LOOP ON Bmk1004 = Bmk1004 1 540 │└TABLE SEEK cast_info AS ci 30 540 PROJECT BmkToPage Bmk1004 AS Expr1100 30 540 INNER JOIN LOOP ON t.id = ci.movie_id 30 540 │└TABLE SEEK cast_info AS ci 1 5 FILTER info as info = 'release dates' 1 5 INNER JOIN LOOP ON Bmk1008 = Bmk1008 1 5 │└TABLE SEEK info_type AS it 1 5 INNER JOIN LOOP ON mi.info_type_id = it.id 1 5 │└TABLE SEEK info_type AS it 1 5 INNER JOIN LOOP ON t.id = mi.movie_id 1 5 │└TABLE SEEK movie_info AS mi WHERE info as info LIKE 'Japan:%201%' OR info as info LIKE 'USA:%201%' 1 4 FILTER title as title LIKE 'Kung Fu Panda%' 1 37 INNER JOIN LOOP ON Bmk1022 = Bmk1022 0 37 │└TABLE SEEK title AS t WHERE production_year as production_year > 2010 44 99 PROJECT BmkToPage Bmk1022 AS Expr1098 44 99 INNER JOIN LOOP ON mc.movie_id = t.id 1 99 │└TABLE SEEK title AS t 44 99 INNER JOIN LOOP ON Bmk1012 = Bmk1012 1 99 │└TABLE SEEK movie_companies AS mc 44 99 PROJECT BmkToPage Bmk1012 AS Expr1095 44 99 INNER JOIN LOOP ON cn.id = mc.company_id 44 99 │└TABLE SEEK movie_companies AS mc 1 1 TABLE SCAN company_name AS cn WHERE country_code as country_code = 'us' AND name as name = 'DreamWorks Animation'
	Estimate Actual Operator 1 ∞ PROJECT min AS voiced_char_name, min_71 AS voicing_actress_name, min_72 AS kung_fu_panda 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 - 45 INNER JOIN HASH ON movie_id = id_63 143132 8 │└DISTRIBUTE HASH ON id_63 143132 8 │ PROJECT id AS id_63, title 143132 8 │ FILTER (production_year > 2010) AND (title >= 'Kung Fu Panda') AND (title < 'Kung Fu Pandb') AND (title LIKE 'Kung Fu Panda%') 143132 8 │ TABLE SCAN title - 45 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 - 45 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 - 45 INNER JOIN HASH ON keyword_id = id_26 134170 3 │└DISTRIBUTE GATHER 134170 3 │ PROJECT id AS id_26 134170 3 │ FILTER keyword IN('computer-animated-movie','hand-to-hand-combat','hero','martial-arts') 134170 3 │ TABLE SCAN keyword - 45 INNER JOIN HASH ON movie_id = movie_id_44 4523930 7 │└DISTRIBUTE HASH ON movie_id_44 4523930 7 │ PROJECT movie_id AS movie_id_44, keyword_id 4523930 7 │ TABLE SCAN movie_keyword - 25 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 - 25 INNER JOIN HASH ON movie_id = movie_id_37 13352148 6 │└DISTRIBUTE HASH ON movie_id_37 13352148 6 │ PROJECT movie_id AS movie_id_37, info_type_id 13352148 6 │ FILTER (((info >= 'Japan:') AND (info < 'Japan;')) OR ((info >= 'USA:') AND (info < 'USA;'))) AND ((info LIKE 'Japan:%201%') OR (info LIKE 'USA:%201%')) 13352148 6 │ TABLE SCAN movie_info - 15 INNER JOIN HASH ON company_id = id_14 234997 1 │└DISTRIBUTE GATHER 234997 1 │ PROJECT id AS id_14 234997 1 │ FILTER (country_code = 'us') AND (name = 'DreamWorks Animation') 234997 1 │ TABLE SCAN company_name - 15 INNER JOIN HASH ON movie_id = movie_id_31 2609129 3 │└DISTRIBUTE HASH ON movie_id_31 2609129 3 │ PROJECT movie_id AS movie_id_31, company_id 2609129 3 │ TABLE SCAN movie_companies - 15 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 - 15 INNER JOIN HASH ON person_id_10 = person_id 901343 10525 │└DISTRIBUTE GATHER 901343 10525 │ TABLE SCAN aka_name 32619910 3 PROJECT person_id AS person_id_10, movie_id, person_role_id, role_id 32619910 3 FILTER note IN('(voice)','(voice) (uncredited)','(voice: English version)','(voice: Japanese version)') 32619910 3 TABLE SCAN cast_info
	Estimate Actual Operator 1 1 AGGREGATE MIN(name), MIN(name), MIN(title) 1 45 INNER JOIN LOOP ON id = info_type_id 1 45 │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id) 1 25 │ │└INNER JOIN LOOP ON person_id = person_id AND person_id = id AND (person_id = id) 1 5 │ │ │└INNER JOIN LOOP ON id = role_id 1 5 │ │ │ │└INNER JOIN LOOP ON id = person_role_id 1 5 │ │ │ │ │└INNER JOIN LOOP ON id = person_id 1 108 │ │ │ │ │ │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id) 1 6 │ │ │ │ │ │ │└INNER JOIN LOOP ON id = keyword_id 2 83 │ │ │ │ │ │ │ │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id) 1 4 │ │ │ │ │ │ │ │ │└INNER JOIN LOOP ON id = movie_id 11 99 │ │ │ │ │ │ │ │ │ │└INNER JOIN LOOP ON company_id = id 1 1 │ │ │ │ │ │ │ │ │ │ │└TABLE SEEK company_name AS cn WHERE cn.country_code = 'us' 133 99 │ │ │ │ │ │ │ │ │ │ TABLE SEEK movie_companies AS mc 99 99 │ │ │ │ │ │ │ │ │ TABLE SEEK title AS t WHERE (t.production_year > 2010) AND (t.title LIKE 'Kung Fu Panda%') 180 83 │ │ │ │ │ │ │ │ TABLE SEEK movie_keyword AS mk 83 83 │ │ │ │ │ │ │ TABLE SEEK keyword AS k WHERE k.keyword IN('hero','martial-arts','hand-to-hand-combat','computer-animated-movie') 6 108 │ │ │ │ │ │ TABLE SEEK cast_info AS ci WHERE ci.note IN('(voice)','(voice: Japanese version)','(voice) (uncredited)','(voice: English version)') 108 108 │ │ │ │ │ TABLE SEEK name AS n WHERE (n.name LIKE '%An%') AND (n.gender = 'f') 5 5 │ │ │ │ TABLE SEEK char_name AS chn 5 5 │ │ │ TABLE SEEK role_type AS rt WHERE rt.role = 'actress' 10 25 │ │ TABLE SEEK aka_name AS an 25 45 │ TABLE SEEK movie_info AS mi WHERE (mi.info LIKE 'Japan:%201%') OR (mi.info LIKE 'USA:%201%') 45 45 TABLE SEEK info_type AS it WHERE it.info = 'release dates'