Planner — IMDB — JOB-20C

SELECT MIN(n.name) AS cast_member,
       MIN(t.title) AS complete_dynamic_hero_movie
FROM job.complete_cast AS cc,
     job.comp_cast_type AS cct1,
     job.comp_cast_type AS cct2,
     job.char_name AS chn,
     job.cast_info AS ci,
     job.keyword AS k,
     job.kind_type AS kt,
     job.movie_keyword AS mk,
     job.name AS n,
     job.title AS t
WHERE cct1.kind = 'cast'
  AND cct2.kind LIKE '%complete%'
  AND chn.name IS NOT NULL
  AND (chn.name LIKE '%man%'
       OR chn.name LIKE '%Man%')
  AND k.keyword IN ('superhero',
                    'marvel-comics',
                    'based-on-comic',
                    'tv-special',
                    'fight',
                    'violence',
                    'magnet',
                    'web',
                    'claw',
                    'laser')
  AND kt.kind = 'movie'
  AND t.production_year > 2000
  AND kt.id = t.kind_id
  AND t.id = mk.movie_id
  AND t.id = ci.movie_id
  AND t.id = cc.movie_id
  AND mk.movie_id = ci.movie_id
  AND mk.movie_id = cc.movie_id
  AND ci.movie_id = cc.movie_id
  AND chn.id = ci.person_role_id
  AND n.id = ci.person_id
  AND k.id = mk.keyword_id
  AND cct1.id = cc.subject_id
  AND cct2.id = cc.status_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 8,751,509 8.8M Rank		Estimation Error Est Err 8,786,277 8.8M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 214,500 215K Rank	Estimation Error Est Err 5,406 5.4K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 46,766,630 47M 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 26,982,388 27M Rank		Estimation Error Est Err 27,002,604 27M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 225,353 225K Rank	Estimation Error Est Err 5,408 5.4K Rank	Estimation Error Est Err 111,333 111K Rank
Estimation Error Est Err 49,630,618 50M Rank		Estimation Error Est Err 50,680,131 51M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 11,672,881 12M Rank	Estimation Error Est Err 5,416 5.4K Rank	Estimation Error Est Err 13,429,519 13M Rank
Estimation Error Est Err 4,163,136 4.2M Rank		Estimation Error Est Err 4,056,166 4.1M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 1,256,203 1.3M Rank	Estimation Error Est Err 5,406 5.4K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 491,549 492K Rank	Estimation Error Est Err 491,545 492K Rank	Estimation Error Est Err 518,255 518K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 505,387 505K Rank	Estimation Error Est Err 5,406 5.4K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 1,260,064 1.3M Rank	Estimation Error Est Err 1,260,051 1.3M Rank	Estimation Error Est Err 1,901,137 1.9M Rank	Estimation Error Est Err 6,371 6.4K Rank	Estimation Error Est Err 1,654,960 1.7M Rank	Estimation Error Est Err 6,372 6.4K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 4,645,293 4.6M Rank		Estimation Error Est Err 35,916 36K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 4,656,756 4.7M Rank	Estimation Error Est Err 5,422 5.4K Rank	Estimation Error Est Err 4,644,431 4.6M Rank

Actual Query Plans

Query Plan per Engine ?
	Query Plan
	Estimate Actual Operator 1 1 AGGREGATE min, min 14 5406 INNER JOIN HASH ON id70 = person_id 11 5406 │└INNER JOIN HASH ON id60 = person_role_id 186 74157 │ │└INNER JOIN HASH ON id28 = movie_id52 15 1267 │ │ │└INNER JOIN HASH ON id = status_id 2 2 │ │ │ │└TABLE SCAN comp_cast_type WHERE kind LIKE '%complete%' 2 1267 │ │ │ INNER JOIN HASH ON id6 = subject_id 1 1 │ │ │ │└TABLE SCAN comp_cast_type WHERE kind = cast 3 1485 │ │ │ INNER JOIN HASH ON id28 = movie_id44 45 5032 │ │ │ │└INNER JOIN HASH ON id11 = kind_id 1 1 │ │ │ │ │└TABLE SCAN kind_type WHERE kind = movie 178 5528 │ │ │ │ INNER JOIN HASH ON id28 = movie_id 308 24091 │ │ │ │ │└INNER JOIN HASH ON id16 = keyword_id 10 10 │ │ │ │ │ │└TABLE SCAN keyword WHERE keyword BETWEEN based - on - comic AND web AND keyword IN(based - on - comic,claw,fight,laser,magnet,marvel - comics,superhero,tv - special,violence,web) 4523930 4523930 │ │ │ │ │ TABLE SCAN movie_keyword 1402423 4555 │ │ │ │ TABLE SCAN title WHERE production_year >= 2001 135086 1098 │ │ │ TABLE SCAN complete_cast 17485064 51891 │ │ TABLE SCAN cast_info 196271 2530 │ TABLE SCAN char_name WHERE name LIKE '%man%' OR name LIKE '%Man%' 4167491 4167491 TABLE SCAN name
	Estimate Actual Operator - ∞ PROJECT a1 AS cast_member, a2 AS complete_dynamic_hero_movie - ∞ AGGREGATE MIN(name) AS a1, MIN(title) AS a2 - ∞ PROJECT name, title - ∞ PROJECT name, title - ∞ INNER JOIN HASH ON tuple(PROJECTION_2076.movie_id,PROJECTION_2076.movie_id,PROJECTION_2076.id) = tuple(PROJECTION_2061.movie_id,PROJECTION_2061.movie_id,PROJECTION_2061.movie_id) - ∞ │└PROJECT movie_id AS movie_id_right - ∞ │ PROJECT movie_id - ∞ │ INNER JOIN HASH ON PROJECTION_2073.id = PROJECTION_2064.status_id - 85941 │ │└PROJECT status_id, movie_id - 85941 │ │ PROJECT status_id, movie_id - 85941 │ │ INNER JOIN HASH ON PROJECTION_2070.subject_id = PROJECTION_2067.id - 1 │ │ │└PROJECT id - 1 │ │ │ FILTER (1 AND kind = 'cast'_String) AS a41 - 1 │ │ │ TABLE SCAN comp_cast_type WHERE kind = 'cast' - 135086 │ │ PROJECT subject_id, status_id, movie_id - 135086 │ │ PROJECT subject_id, status_id, movie_id - 135086 │ │ TABLE SCAN complete_cast - ∞ │ PROJECT id - ∞ │ FILTER ( LIKE (kind,'%complete%'_String) AND 1) AS a36 - 2 │ TABLE SCAN comp_cast_type WHERE kind LIKE '%complete%' - ∞ PROJECT movie_id_left, movie_id AS movie_id_left_2, id, name, title - ∞ PROJECT movie_id, movie_id, name, title, id - ∞ INNER JOIN HASH ON PROJECTION_2082.kind_id = PROJECTION_2079.id - 1 │└PROJECT id AS id_right - 1 │ FILTER (1 AND kind = 'movie'_String) AS a31 - 1 │ TABLE SCAN kind_type WHERE kind = 'movie' - ∞ PROJECT kind_id, movie_id, movie_id, name, title, id_left - ∞ PROJECT movie_id, movie_id, name, title, id, kind_id - ∞ INNER JOIN HASH ON PROJECTION_2088.keyword_id = PROJECTION_2085.id - ∞ │└PROJECT id AS id_right - ∞ │ FILTER (1 AND in(keyword,__set_String_2587091148504359415_16236450900976866144)) AS a27 - 134170 │ TABLE SCAN keyword WHERE TRUE - ∞ PROJECT keyword_id, movie_id, movie_id, name, title, id_left, kind_id - ∞ PROJECT movie_id, movie_id, keyword_id, name, title, id, kind_id - ∞ INNER JOIN HASH ON tuple(PROJECTION_2094.movie_id,PROJECTION_2094.id) = tuple(PROJECTION_2091.movie_id,PROJECTION_2091.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, name, title, kind_id - ∞ PROJECT movie_id, name, title, id, kind_id - ∞ INNER JOIN HASH ON PROJECTION_2100.person_id = PROJECTION_2097.id - 4167491 │└PROJECT id AS id_right, name - 4167491 │ PROJECT name, id - 4167491 │ TABLE SCAN name - ∞ PROJECT person_id, movie_id, title, id_left, kind_id - ∞ PROJECT movie_id, person_id, title, id, kind_id - ∞ INNER JOIN HASH ON PROJECTION_2106.person_role_id = PROJECTION_2103.id - ∞ │└PROJECT id AS id_right - ∞ │ FILTER (1 AND OR ( LIKE (name,'%man%'_String), LIKE (name,'%Man%'_String))) AS a19 - 180152 │ TABLE SCAN char_name WHERE name LIKE '%man%' OR name LIKE '%Man%' - 21334720 PROJECT person_role_id, movie_id, person_id, title, id AS id_left, kind_id - 21334720 PROJECT movie_id, person_role_id, person_id, title, id, kind_id - 21334720 INNER JOIN HASH ON PROJECTION_2112.movie_id = PROJECTION_2109.id - 1381453 │└PROJECT id, title, kind_id - 1381453 │ FILTER (1 AND production_year > 2000_UInt16) AS a15 - 1381453 │ TABLE SCAN title WHERE production_year > 2000 - 36244344 PROJECT movie_id, person_role_id, person_id - 36244344 PROJECT movie_id, person_role_id, person_id - 36244344 TABLE SCAN cast_info
	Estimate Actual Operator - 1 AGGREGATE MIN(#0), MIN(#1) 311 5406 PROJECT name, title 311 5406 INNER JOIN HASH ON id = person_id 268 5406 │└INNER JOIN HASH ON id = person_role_id 1344 189844 │ │└INNER JOIN HASH ON movie_id = movie_id 92 1267 │ │ │└INNER JOIN HASH ON id = keyword_id 447 294672 │ │ │ │└INNER JOIN HASH ON movie_id = movie_id 245 4589 │ │ │ │ │└INNER JOIN HASH ON status_id = id 1 2 │ │ │ │ │ │└FILTER id >= 3 1 2 │ │ │ │ │ │ TABLE SCAN comp_cast_type WHERE contains(kind,'complete') 982 4589 │ │ │ │ │ INNER JOIN HASH ON subject_id = id 1 1 │ │ │ │ │ │└FILTER id <= 2 1 1 │ │ │ │ │ │ TABLE SCAN comp_cast_type WHERE kind = 'cast' 3928 6090 │ │ │ │ │ INNER JOIN HASH ON kind_id = id 1 1 │ │ │ │ │ │└TABLE SCAN kind_type WHERE kind = 'movie' 27501 6090 │ │ │ │ │ INNER JOIN HASH ON id = movie_id 135086 132439 │ │ │ │ │ │└TABLE SCAN complete_cast WHERE movie_id <= 2525971 505662 5237 │ │ │ │ │ FILTER id BETWEEN 285 AND 2525971 505662 5239 │ │ │ │ │ TABLE SCAN title WHERE production_year > 2000 4523930 3689305 │ │ │ │ TABLE SCAN movie_keyword WHERE movie_id >= 285 26834 10 │ │ │ FILTER IN ... 134170 134058 │ │ │ INNER JOIN HASH ON keyword = #0 0 10 │ │ │ │└SCAN MATERIALISED 134170 134058 │ │ │ TABLE SCAN keyword WHERE keyword IN('superhero','marvel-comics','based-on-comic','tv-special','fight','violence','magnet','web','claw','laser') 36244344 185965 │ │ TABLE SCAN cast_info WHERE movie_id >= 285 AND movie_id <= 2525971 628067 2689 │ TABLE SCAN char_name WHERE (name IS NOT NULL) AND (contains(name,'man') OR contains(name,'Man')) 4167491 13427 TABLE SCAN "name" WHERE id <= 4061926
	Estimate Actual Operator 1 1 PROJECT cast_member, complete_dynamic_hero_movie 1 1 AGGREGATE MIN(name), MIN(title) 49591 10 DISTRIBUTE GATHER 49591 10 AGGREGATE MIN(name), MIN(title) 49591 5406 INNER JOIN HASH ON id = kind_id 2 1 │└DISTRIBUTE GATHER 2 1 │ FILTER kind = 'movie' 7 7 │ DISTRIBUTE ROUND ROBIN 7 7 │ TABLE SCAN kind_type WHERE kind = 'movie' 173569 5643 INNER JOIN HASH ON movie_id = id AND movie_id = id AND movie_id = id 173569 20718 │└DISTRIBUTE HASH ON movie_id, movie_id, movie_id 173569 20718 │ INNER JOIN HASH ON person_id = id 173569 20718 │ │└DISTRIBUTE HASH ON person_id 173569 20718 │ │ INNER JOIN HASH ON id = keyword_id 26834 10 │ │ │└DISTRIBUTE GATHER 26834 10 │ │ │ FILTER keyword IN('superhero','marvel-comics','based-on-comic','tv-special','fight','violence','magnet','web','claw','laser') 134170 134170 │ │ │ DISTRIBUTE ROUND ROBIN 134170 134170 │ │ │ TABLE SCAN keyword WHERE keyword IN('superhero','marvel-comics','based-on-comic','tv-special','fight','violence','magnet','web','claw','laser') 867845 4614301 │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id 484568 118833 │ │ │└DISTRIBUTE HASH ON movie_id, movie_id 484568 118833 │ │ │ INNER JOIN HASH ON person_role_id = id 484568 3409569 │ │ │ │└DISTRIBUTE HASH ON person_role_id 484568 3409569 │ │ │ │ INNER JOIN HASH ON movie_id = movie_id 33771 85941 │ │ │ │ │└DISTRIBUTE GATHER 33771 85941 │ │ │ │ │ INNER JOIN HASH ON id = status_id 1 2 │ │ │ │ │ │└DISTRIBUTE GATHER 1 2 │ │ │ │ │ │ FILTER kind LIKE '%complete%' 4 4 │ │ │ │ │ │ DISTRIBUTE ROUND ROBIN 4 4 │ │ │ │ │ │ TABLE SCAN comp_cast_type WHERE kind LIKE '%complete%' 67543 85941 │ │ │ │ │ INNER JOIN HASH ON id = subject_id 1 1 │ │ │ │ │ │└DISTRIBUTE GATHER 1 1 │ │ │ │ │ │ FILTER kind = 'cast' 4 4 │ │ │ │ │ │ DISTRIBUTE ROUND ROBIN 4 4 │ │ │ │ │ │ TABLE SCAN comp_cast_type WHERE kind = 'cast' 135086 122880 │ │ │ │ │ DISTRIBUTE ROUND ROBIN 135086 122880 │ │ │ │ │ TABLE SCAN complete_cast WHERE (((subject_id >= 1) AND (subject_id <= 1)) AND subject_id IN 1) AND (((status_id >= 3) AND (status_id <= 4)) AND status_id IN(3,4)) 36244344 36244344 │ │ │ │ TABLE SCAN cast_info WHERE ((movie_id >= 285) AND (movie_id <= 2528181)) AND TRUE 628068 180152 │ │ │ DISTRIBUTE HASH ON id 628068 180152 │ │ │ FILTER name IS NOT NULL AND (name LIKE '%man%' OR name LIKE '%Man%') 3140339 3140339 │ │ │ TABLE SCAN char_name WHERE (name IS NOT NULL AND (name LIKE '%man%' OR name LIKE '%Man%')) AND CASE MOD(HASH_REPARTITION id,10) WHEN 0 THEN (((id >= 5) AND (id <= 3140184)) AND TRUE) WHEN 1 THEN (((id >= 15) AND (id <= 3140113)) AND TRUE) WHEN 2 THEN (((id >= 10) AND (id <= 3140201)) AND TRUE) WHEN 3 THEN (((id >= 1) AND (id <= 3139991)) AND TRUE) WHEN 4 THEN (((id >= 21) AND (id <= 3140267)) AND TRUE) WHEN 5 THEN (((id >= 20) AND (id <= 3140246)) AND TRUE) WHE... 4523930 4523930 │ │ DISTRIBUTE HASH ON movie_id, movie_id 4523930 4523930 │ │ TABLE SCAN movie_keyword WHERE CASE MOD(HASH_REPARTITION(movie_id,movie_id),10) WHEN 1 THEN ((((movie_id >= 294) AND (movie_id <= 2525620)) AND ((movie_id >= 294) AND (movie_id <= 2525620))) AND TRUE) WHEN 3 THEN ((((movie_id >= 286) AND (movie_id <= 2525477)) AND ((movie_id >= 286) AND (movie_id <= 2525477))) AND TRUE) WHEN 5 THEN ((((movie_id >= 296) AND (movie_id <= 2525667)) AND ((movie_id >= 296) AND (movie_id <= 2525667))) AND TRUE) WHEN 7 THEN ((((movie_id >... 4167491 4167491 │ DISTRIBUTE HASH ON id 4167491 4167491 │ TABLE SCAN name WHERE CASE MOD(HASH_REPARTITION id,10) WHEN 0 THEN (((id >= 568) AND (id <= 2699679)) AND TRUE) WHEN 1 THEN (((id >= 1668) AND (id <= 2699221)) AND TRUE) WHEN 2 THEN (((id >= 1117) AND (id <= 2698586)) AND TRUE) WHEN 3 THEN (((id >= 6293) AND (id <= 2695168)) AND TRUE) WHEN 4 THEN (((id >= 6541) AND (id <= 2700941)) AND TRUE) WHEN 5 THEN (((id >= 959) AND (id <= 2689211)) AND TRUE) WHEN 6 THEN (((id >= 2034) AND (id <= 2696588)) AND TRUE) WHEN 7 THEN ((... 343129 645078 DISTRIBUTE HASH ON id, id, id 343129 645078 FILTER production_year > 2000 2528312 1297449 TABLE SCAN title WHERE ((production_year > 2000) AND CASE MOD(HASH_REPARTITION(id,id,id),10) WHEN 0 THEN (((((id >= 40543) AND (id <= 2520974)) AND ((id >= 40543) AND (id <= 2520974))) AND ((id >= 40543) AND (id <= 2520974))) AND TRUE) WHEN 1 THEN (((((id >= 125326) AND (id <= 2524079)) AND ((id >= 125326) AND (id <= 2524079))) AND ((id >= 125326) AND (id <= 2524079))) AND TRUE) WHEN 2 THEN (((((id >= 470722) AND (id <= 2524051)) AND ((id >= 470722) AND (id <= 2524051))) A...
	Estimate Actual Operator 1 1 AGGREGATE MIN(n.name), MIN(t.title) 1 2 DISTRIBUTE GATHER 1 2 AGGREGATE MIN(n.name), MIN(t.title) 9870 5406 INNER JOIN HASH ON ci.person_id = n.id 9870 5406 │└DISTRIBUTE GATHER 9870 5406 │ INNER JOIN HASH ON ci.person_role_id = chn.id 9870 74157 │ │└DISTRIBUTE GATHER 9870 74157 │ │ INNER JOIN HASH ON cc.movie_id = ci.movie_id 9870 1267 │ │ │└DISTRIBUTE GATHER 599 1267 │ │ │ INNER JOIN HASH ON t.kind_id = kt.id 599 1 │ │ │ │└DISTRIBUTE GATHER 4 1 │ │ │ │ TABLE SCAN kind_type WHERE kt.kind = 'movie' 599 1446 │ │ │ INNER JOIN HASH ON cc.movie_id = t.id 599 6396 │ │ │ │└DISTRIBUTE GATHER 569 6396 │ │ │ │ INNER JOIN HASH ON cc.subject_id = cct1.id 569 1 │ │ │ │ │└DISTRIBUTE GATHER 2530000 1 │ │ │ │ │ TABLE SCAN comp_cast_type WHERE cct1.kind = 'cast' 569 9392 │ │ │ │ INNER JOIN HASH ON cc.status_id = cct2.id 569 2 │ │ │ │ │└DISTRIBUTE GATHER 36200000 2 │ │ │ │ │ TABLE SCAN comp_cast_type WHERE contains(cct2.kind,'complete') 569 9392 │ │ │ │ INNER JOIN HASH ON mk.movie_id = cc.movie_id 569 24091 │ │ │ │ │└DISTRIBUTE GATHER 387 24091 │ │ │ │ │ INNER JOIN HASH ON mk.keyword_id = k.id 387 10 │ │ │ │ │ │└DISTRIBUTE GATHER 4170000 10 │ │ │ │ │ │ TABLE SCAN keyword WHERE k.keyword IN('superhero','marvel-comics','based-on-comic','tv-special','fight','violence','magnet','web','claw','laser') 3140000 4519841 │ │ │ │ │ TABLE SCAN movie_keyword 7 131210 │ │ │ │ TABLE SCAN complete_cast WHERE cc.movie_id IS NOT NULL 4 428605 │ │ │ TABLE SCAN title WHERE (t.production_year IS NOT NULL) AND (t.production_year > 2000L) 135000 17563890 │ │ TABLE SCAN cast_info WHERE ci.person_role_id IS NOT NULL 134000 179525 │ TABLE SCAN char_name WHERE contains(chn.name,'man') OR contains(chn.name,'Man') 4520000 4159303 TABLE SCAN name
	Estimate Actual Operator 1 1 AGGREGATE MIN(partialagg1054) AS Expr1020, MIN(partialagg1055) AS Expr1021 1 1 FILTER kind as kind = 'cast' 2 2 INNER JOIN LOOP ON Bmk1002 = Bmk1002 1 2 │└TABLE SEEK comp_cast_type AS cct1 2 2 INNER JOIN LOOP ON cc.subject_id = cct1.id 1 2 │└TABLE SEEK comp_cast_type AS cct1 2 2 AGGREGATE MIN(name as name) AS partialagg1054, MIN(title as title) AS partialagg1055 GROUP BY SORT subject_id 94 6371 SORT subject_id 94 6371 INNER JOIN HASH ON cc.status_id = cct2.id 2 2 │└TABLE SCAN comp_cast_type AS cct2 WHERE kind as kind LIKE '%complete%' 94 6371 INNER JOIN HASH ON mk.keyword_id = k.id 10 10 │└TABLE SCAN keyword AS k WHERE keyword as keyword = 'based-on-comic' OR keyword as keyword = 'claw' OR keyword as keyword = 'fight' OR keyword as keyword = 'laser' OR keyword as keyword = 'magnet' OR keyword as keyword = 'marvel-comics' OR keyword as keyword = 'superhero' OR keyword as keyword = 'tv-special' OR keyword as keyword = 'violence' OR keyword as keyword = 'web' 47 6371 INNER JOIN LOOP ON Bmk1000 = Bmk1000 1 6371 │└TABLE SEEK complete_cast AS cc 47 6371 INNER JOIN LOOP ON t.id = cc.movie_id 1 6371 │└TABLE SEEK complete_cast AS cc 32 11235 INNER JOIN LOOP ON Bmk1016 = Bmk1016 1 11235 │└TABLE SEEK name AS n 32 11235 PROJECT BmkToPage Bmk1016 AS Expr1336 32 11235 INNER JOIN LOOP ON ci.person_id = n.id 1 11235 │└TABLE SEEK name AS n 32 11235 FILTER name as name LIKE '%man%' OR name as name LIKE '%Man%' 556 175101 INNER JOIN LOOP ON Bmk1006 = Bmk1006 1 175101 │└TABLE SEEK char_name AS chn 556 175101 PROJECT BmkToPage Bmk1006 AS Expr1333 556 175101 INNER JOIN LOOP ON ci.person_role_id = chn.id 1 175101 │└TABLE SEEK char_name AS chn 1238 406258 INNER JOIN HASH ON t.kind_id = kt.id 1 1 │└TABLE SCAN kind_type AS kt WHERE kind as kind = 'movie' 742 406258 INNER JOIN LOOP ON Bmk1008 = Bmk1008 1 406258 │└TABLE SEEK cast_info AS ci 742 406258 PROJECT BmkToPage Bmk1008 AS Expr1330 742 406258 INNER JOIN LOOP ON t.id = ci.movie_id 30 406258 │└TABLE SEEK cast_info AS ci 24 5032 FILTER production_year as production_year > 2000 45 13935 INNER JOIN LOOP ON Bmk1018 = Bmk1018 1 13935 │└TABLE SEEK title AS t WHERE BLOOM(kind_id as kind_id) 452 24091 PROJECT BmkToPage Bmk1018 AS Expr1327 452 24091 INNER JOIN LOOP ON mk.movie_id = t.id 1 24091 │└TABLE SEEK title AS t 452 24091 TABLE SEEK movie_keyword AS mk WHERE BLOOM(keyword_id as keyword_id)
	Estimate Actual Operator 1 ∞ PROJECT min AS cast_member, min_50 AS complete_dynamic_hero_movie 1 1 AGGREGATE MIN(min_51) AS min, MIN(min_52) AS min_50 - 16 DISTRIBUTE GATHER - 16 AGGREGATE MIN(name_33) AS min_51, MIN(title) AS min_52 - 5406 INNER JOIN HASH ON kind_id = id_22 7 1 │└DISTRIBUTE GATHER 7 1 │ PROJECT id AS id_22 7 1 │ FILTER kind = 'movie' 7 1 │ TABLE SCAN kind_type - 5411 INNER JOIN HASH ON movie_id = id_42 335742 283091 │└DISTRIBUTE HASH ON id_42 335742 283091 │ PROJECT id AS id_42, title, kind_id 335742 283091 │ FILTER production_year > 2000 335742 283091 │ TABLE SCAN title - 5411 INNER JOIN HASH ON person_id = id_32 4167491 4167491 │└DISTRIBUTE HASH ON id_32 4167491 4167491 │ PROJECT id AS id_32, name AS name_33 4167491 4167491 │ TABLE SCAN name - 5411 INNER JOIN HASH ON keyword_id = id_18 134170 10 │└DISTRIBUTE GATHER 134170 10 │ PROJECT id AS id_18 134170 10 │ FILTER keyword IN('based-on-comic','claw','fight','laser','magnet','marvel-comics','superhero','tv-special','violence','web') 134170 10 │ TABLE SCAN keyword - 5411 INNER JOIN HASH ON movie_id = movie_id_28 4523930 5444 │└DISTRIBUTE HASH ON movie_id_28 4523930 5444 │ PROJECT movie_id AS movie_id_28, keyword_id 4523930 5444 │ TABLE SCAN movie_keyword - 3607 INNER JOIN HASH ON person_role_id = id_9 2826305 180152 │└DISTRIBUTE HASH ON id_9 2826305 180152 │ PROJECT id AS id_9 2826305 180152 │ FILTER NOT (name IS NULL) AND ((name LIKE '%man%') OR (name LIKE '%Man%')) 2826305 180152 │ TABLE SCAN char_name - 3607 INNER JOIN HASH ON movie_id = movie_id_14 36244344 8223 │└DISTRIBUTE HASH ON movie_id_14 36244344 8223 │ PROJECT person_id, movie_id AS movie_id_14, person_role_id 36244344 8223 │ TABLE SCAN cast_info - 769 INNER JOIN HASH ON status_id = id_4 4 2 │└DISTRIBUTE GATHER 4 2 │ PROJECT id AS id_4 4 2 │ FILTER kind LIKE '%complete%' 4 2 │ TABLE SCAN comp_cast_type - 769 INNER JOIN HASH ON subject_id = id_0 4 1 │└DISTRIBUTE GATHER 4 1 │ PROJECT id AS id_0 4 1 │ FILTER kind = 'cast' 4 1 │ TABLE SCAN comp_cast_type 135086 878 TABLE SCAN complete_cast
	Estimate Actual Operator 1 1 AGGREGATE MIN(name), MIN(title) 1 5406 INNER JOIN LOOP ON id = person_id 1 5406 │└INNER JOIN LOOP ON id = person_role_id 9 189844 │ │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id) 2 1267 │ │ │└INNER JOIN LOOP ON keyword IN('superhero','marvel-comics','based-on-comic','tv-special','fight','violence','magnet','web','claw','laser') AND id = status_id AND (id = status_id) 1 2 │ │ │ │└TABLE SCAN comp_cast_type AS cct2 WHERE cct2.kind LIKE '%complete%' 18 2534 │ │ │ INNER JOIN LOOP ON keyword IN('superhero','marvel-comics','based-on-comic','tv-special','fight','violence','magnet','web','claw','laser') AND id = subject_id AND (id = subject_id) 1 1 │ │ │ │└TABLE SCAN comp_cast_type AS cct1 WHERE cct1.kind = 'cast' 70 2970 │ │ │ INNER JOIN LOOP ON movie_id = id 52 10064 │ │ │ │└INNER JOIN LOOP ON keyword IN('superhero','marvel-comics','based-on-comic','tv-special','fight','violence','magnet','web','claw','laser') AND id = kind_id AND (id = kind_id) 1 1 │ │ │ │ │└TABLE SCAN kind_type AS kt WHERE kt.kind = 'movie' 366 21226 │ │ │ │ INNER JOIN LOOP ON id = movie_id 674 48182 │ │ │ │ │└INNER JOIN LOOP ON keyword_id = id 20 20 │ │ │ │ │ │└TABLE SEEK keyword AS k 6100 48182 │ │ │ │ │ TABLE SEEK movie_keyword AS mk 48182 48182 │ │ │ │ TABLE SEEK title AS t WHERE t.production_year > 2000 20128 10064 │ │ │ TABLE SEEK complete_cast AS cc 49413 189847 │ │ TABLE SEEK cast_info AS ci 189844 189844 │ TABLE SEEK char_name AS chn WHERE (chn.name LIKE '%man%') OR (chn.name LIKE '%Man%') 5406 5406 TABLE SEEK name AS n