|
1 1 AGGREGATE min, min
1 761 INNER JOIN HASH ON id = info_type_id53
1 1 │└TABLE SCAN info_type WHERE info = rating
2 761 INNER JOIN HASH ON movie_id44 = movie_id52
2 1281 │└INNER JOIN HASH ON id6 = info_type_id
1 1 │ │└TABLE SCAN info_type WHERE info = countries
12 1391 │ INNER JOIN HASH ON movie_id = movie_id44
5 1966 │ │└INNER JOIN HASH ON id11 = kind_id
1 1 │ │ │└TABLE SCAN kind_type WHERE kind = movie
20 2046 │ │ INNER JOIN HASH ON id28 = movie_id
129 37091 │ │ │└INNER JOIN HASH ON id16 = keyword_id
4 3 │ │ │ │└TABLE SCAN keyword WHERE keyword IN(blood,murder,murder - in - title,violence)
4523930 4523930 │ │ │ TABLE SCAN movie_keyword
365420 1513 │ │ TABLE SCAN title WHERE production_year >= 2011
608496 1001 │ TABLE SCAN movie_info WHERE info BETWEEN American AND USA AND info46 IN(American,Denish,Denmark,German,Germany,Norway,Norwegian,Sweden,Swedish,USA)
1342299 483 TABLE SCAN movie_info_idx WHERE info < 8.5
|
|
- 1 PROJECT a1 AS rating, a2 AS northern_dark_movie
- 1 AGGREGATE MIN(info) AS a1, MIN(title) AS a2
- 0 PROJECT info, title
- 0 PROJECT info, title
- 0 INNER JOIN HASH ON tuple(PROJECTION_696.movie_id,PROJECTION_696.movie_id,PROJECTION_696.movie_id,PROJECTION_696.movie_id) = tuple(PROJECTION_675.movie_id,PROJECTION_675.movie_id,PROJECTION_675.id,PROJECTION_675.id)
- 164339 │└PROJECT movie_id AS movie_id_right, id, title
- 164339 │ PROJECT movie_id, title, id
- 164339 │ INNER JOIN HASH ON PROJECTION_681.kind_id = PROJECTION_678.id
- 1 │ │└PROJECT id AS id_right
- 1 │ │ PROJECT id
- 1 │ │ TABLE SCAN kind_type WHERE kind = 'movie'
- 299534 │ PROJECT kind_id, movie_id, title, id_left
- 299534 │ PROJECT movie_id, title, id, kind_id
- 299534 │ INNER JOIN HASH ON PROJECTION_687.keyword_id = PROJECTION_684.id
- 134170 │ │└PROJECT id AS id_right
- 134170 │ │ PROJECT id
- 134170 │ │ TABLE SCAN keyword WHERE TRUE
- 299534 │ PROJECT keyword_id, movie_id, title, id AS id_left, kind_id
- 299534 │ PROJECT movie_id, keyword_id, title, id, kind_id
- 299534 │ INNER JOIN HASH ON PROJECTION_693.movie_id = PROJECTION_690.id
- 391666 │ │└PROJECT id, title, kind_id
- 391666 │ │ PROJECT id, title, kind_id
- 391666 │ │ TABLE SCAN title WHERE production_year > 2010
- 4523930 │ PROJECT movie_id, keyword_id
- 4523930 │ PROJECT movie_id, keyword_id
- 4523930 │ TABLE SCAN movie_keyword
- 420182 PROJECT movie_id AS movie_id_left, movie_id AS movie_id_left_2, info
- 420182 PROJECT movie_id, info, movie_id
- 420182 INNER JOIN HASH ON PROJECTION_708.movie_id = PROJECTION_699.movie_id
- 1325361 │└PROJECT movie_id AS movie_id_right
- 1325361 │ PROJECT movie_id
- 1325361 │ INNER JOIN HASH ON PROJECTION_705.id = PROJECTION_702.info_type_id
- 14835720 │ │└PROJECT info_type_id, movie_id
- 14835720 │ │ PROJECT info_type_id, movie_id
- 14835720 │ │ TABLE SCAN movie_info WHERE TRUE
- 1 │ PROJECT id
- 1 │ PROJECT id
- 1 │ TABLE SCAN info_type WHERE info = 'countries'
- 454230 PROJECT movie_id AS movie_id_left, info
- 454230 PROJECT info, movie_id
- 454230 INNER JOIN HASH ON PROJECTION_714.info_type_id = PROJECTION_711.id
- 1 │└PROJECT id
- 1 │ PROJECT id
- 1 │ TABLE SCAN info_type WHERE info = 'rating'
- 1337634 PROJECT info_type_id, info, movie_id
- 1337634 PROJECT movie_id, info, info_type_id
- 1337634 TABLE SCAN movie_info_idx WHERE info < '8.5'
|
|
- 1 AGGREGATE MIN(#0), MIN(#1)
1 761 PROJECT info, title
1 761 INNER JOIN HASH ON id = keyword_id
5 75669 │└INNER JOIN HASH ON movie_id = movie_id
3 8746 │ │└INNER JOIN HASH ON info_type_id = id
2 1 │ │ │└FILTER id <= 110
2 1 │ │ │ TABLE SCAN info_type WHERE info = 'countries'
169 8746 │ │ INNER JOIN HASH ON movie_id = movie_id
142 17272 │ │ │└INNER JOIN HASH ON kind_id = id
1 1 │ │ │ │└TABLE SCAN kind_type WHERE kind = 'movie'
994 17272 │ │ │ INNER JOIN HASH ON id = movie_id
4885 454230 │ │ │ │└INNER JOIN HASH ON info_type_id = id
2 1 │ │ │ │ │└FILTER id >= 99
2 1 │ │ │ │ │ TABLE SCAN info_type WHERE info = 'rating'
276007 454230 │ │ │ │ TABLE SCAN movie_info_idx WHERE info < '8.5'
505662 17561 │ │ │ FILTER id BETWEEN 2 AND 2525793
505662 17562 │ │ │ TABLE SCAN title WHERE production_year > 2010
2967144 435112 │ │ FILTER movie_id BETWEEN 2 AND 2525793
2967144 435119 │ │ FILTER IN ...
14835720 944605 │ │ INNER JOIN HASH ON info = #0
0 10 │ │ │└SCAN MATERIALISED
14835720 944605 │ │ TABLE SCAN movie_info WHERE info IN('Sweden','Norway','Germany','Denmark','Swedish','Denish','Norwegian','German','USA','American')
4523930 91860 │ TABLE SCAN movie_keyword WHERE movie_id <= 2525793
26834 3 FILTER (keyword = 'murder') OR (keyword = 'murder-in-title') OR (keyword = 'blood') OR (keyword = 'violence')
134170 134135 TABLE SCAN keyword WHERE keyword IN('murder','murder-in-title','blood','violence')
|
|
1 1 PROJECT rating, northern_dark_movie
1 1 AGGREGATE MIN(info), MIN(title)
28246 10 DISTRIBUTE GATHER
28246 10 AGGREGATE MIN(info), MIN(title)
28246 761 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'
98863 917 INNER JOIN HASH ON movie_id = id AND movie_id = id AND movie_id = id
98863 20967 │└DISTRIBUTE GATHER
98863 20967 │ INNER JOIN HASH ON id = keyword_id
26834 3 │ │└DISTRIBUTE GATHER
26834 3 │ │ FILTER keyword IN('murder','murder-in-title','blood','violence')
134170 134170 │ │ DISTRIBUTE ROUND ROBIN
134170 134170 │ │ TABLE SCAN keyword WHERE keyword IN('murder','murder-in-title','blood','violence')
494319 2302523 │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id
276007 213239 │ │└DISTRIBUTE HASH ON movie_id, movie_id
276007 213239 │ │ INNER JOIN HASH ON id = info_type_id
23 1 │ │ │└DISTRIBUTE GATHER
23 1 │ │ │ FILTER info = 'rating'
113 113 │ │ │ DISTRIBUTE ROUND ROBIN
113 113 │ │ │ TABLE SCAN info_type WHERE info = 'rating'
276007 629486 │ │ PROJECT movie_id, movie_id, info_type_id, info
276007 629486 │ │ INNER JOIN HASH ON movie_id = movie_id
276007 1337634 │ │ │└DISTRIBUTE HASH ON movie_id
276007 1337634 │ │ │ FILTER info < '8.5'
1380035 1380035 │ │ │ TABLE SCAN movie_info_idx WHERE (info < '8.5') AND (((info_type_id >= 101) AND (info_type_id <= 101)) AND info_type_id IN 101)
620402 614251 │ │ DISTRIBUTE HASH ON movie_id
620402 614251 │ │ INNER JOIN HASH ON id = info_type_id
23 1 │ │ │└DISTRIBUTE GATHER
23 1 │ │ │ FILTER info = 'countries'
113 113 │ │ │ DISTRIBUTE ROUND ROBIN
113 113 │ │ │ TABLE SCAN info_type WHERE info = 'countries'
2967144 614251 │ │ FILTER info IN('Sweden','Norway','Germany','Denmark','Swedish','Denish','Norwegian','German','USA','American')
14835720 1355825 │ │ TABLE SCAN movie_info WHERE (info IN('Sweden','Norway','Germany','Denmark','Swedish','Denish','Norwegian','German','USA','American') AND (((info_type_id >= 8) AND (info_type_id <= 8)) AND info_type_id IN 8)) AND CASE MOD(HASH_REPARTITION movie_id,10) WHEN 0 THEN (((movie_id >= 67) AND (movie_id <= 2525666)) AND TRUE) WHEN 1 THEN (((movie_id >= 63) AND (movie_id <= 2525670)) AND TRUE) WHEN 2 THEN (((movie_id >= 24) AND (movie_id <= 2525791)) AND TRUE) WHEN 3 THEN ((...
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 >= 57) AND (movie_id <= 2525790)) AND ((movie_id >= 57) AND (movie_id <= 2525790))) AND TRUE) WHEN 3 THEN ((((movie_id >= 51) AND (movie_id <= 2525784)) AND ((movie_id >= 51) AND (movie_id <= 2525784))) AND TRUE) WHEN 5 THEN ((((movie_id >= 52) AND (movie_id <= 2525792)) AND ((movie_id >= 52) AND (movie_id <= 2525792))) AND TRUE) WHEN 7 THEN ((((movie_id >= 24) AND ...
162535 187709 FILTER production_year > 2010
2528312 1297449 TABLE SCAN title WHERE ((production_year > 2010) AND (((((id >= 581) AND (id <= 2525471)) AND ((id >= 581) AND (id <= 2525471))) AND ((id >= 581) AND (id <= 2525471))) AND TRUE)) AND (((kind_id >= 1) AND (kind_id <= 1)) AND kind_id IN 1)
|
|
1 1 AGGREGATE MIN(mi_idx.info), MIN(t.title)
1 1 DISTRIBUTE GATHER
1 1 AGGREGATE MIN(mi_idx.info), MIN(t.title)
579 761 INNER JOIN HASH ON mi.movie_id = mk.movie_id
579 37091 │└DISTRIBUTE GATHER
579 37091 │ INNER JOIN HASH ON mk.keyword_id = k.id
579 3 │ │└DISTRIBUTE GATHER
7 3 │ │ TABLE SCAN keyword WHERE k.keyword IN('murder','murder-in-title','blood','violence')
4520000 4519843 │ TABLE SCAN movie_keyword
579 8746 INNER JOIN HASH ON mi_idx.info_type_id = it2.id
579 1 │└DISTRIBUTE GATHER
2530000 1 │ TABLE SCAN info_type WHERE it2.info = 'rating'
579 25839 INNER JOIN HASH ON mi.movie_id = mi_idx.movie_id
579 55882 │└DISTRIBUTE GATHER
186 55882 │ INNER JOIN HASH ON t.kind_id = kt.id
186 1 │ │└DISTRIBUTE GATHER
1380000 1 │ │ TABLE SCAN kind_type WHERE kt.kind = 'movie'
186 89788 │ INNER JOIN HASH ON mi.movie_id = t.id
186 614251 │ │└DISTRIBUTE GATHER
176 614251 │ │ INNER JOIN HASH ON it1.id = mi.info_type_id
176 1 │ │ │└DISTRIBUTE GATHER
113 1 │ │ │ TABLE SCAN info_type WHERE it1.info = 'countries'
14800000 626978 │ │ TABLE SCAN movie_info WHERE mi.info IN('Sweden','Norway','Germany','Denmark','Swedish','Denish','Norwegian','German','USA','American')
113 375531 │ TABLE SCAN title WHERE (t.production_year IS NOT NULL) AND (t.production_year > 2010L)
134000 815170 TABLE SCAN movie_info_idx WHERE mi_idx.info < '8.5'
|
|
1 1 AGGREGATE MIN(info as info) AS Expr1016, MIN(title as title) AS Expr1017
1 761 FILTER info as info = 'rating'
1 2255 INNER JOIN LOOP ON Bmk1002 = Bmk1002
1 2255 │└TABLE SEEK info_type AS it2
1 2255 INNER JOIN LOOP ON mi_idx.info_type_id = it2.id
1 2255 │└TABLE SEEK info_type AS it2
1 2255 INNER JOIN LOOP ON t.id = mi_idx.movie_id
2 2255 │└TABLE SEEK movie_info_idx AS mi_idx WHERE info as info < '8.5'
1 1281 FILTER kind as kind = 'movie'
2 1614 INNER JOIN LOOP ON Bmk1006 = Bmk1006
1 1614 │└TABLE SEEK kind_type AS kt
2 1614 INNER JOIN LOOP ON t.kind_id = kt.id
1 1614 │└TABLE SEEK kind_type AS kt
2 1614 INNER JOIN LOOP ON Bmk1014 = Bmk1014
0 1614 │└TABLE SEEK title AS t WHERE production_year as production_year > 2010
13 23916 PROJECT BmkToPage Bmk1014 AS Expr1243
13 23916 INNER JOIN LOOP ON mk.movie_id = t.id
1 23916 │└TABLE SEEK title AS t
13 23916 FILTER info as info = 'American' OR info as info = 'Denish' OR info as info = 'Denmark' OR info as info = 'German' OR info as info = 'Germany' OR info as info = 'Norway' OR info as info = 'Norwegian' OR info as info = 'Sweden' OR info as info = 'Swedish' OR info as info = 'USA'
308 44297 INNER JOIN LOOP ON mi.movie_id = mi.movie_id AND Uniq1009 = Uniq1009
1 44297 │└TABLE SEEK movie_info AS mi
308 44297 INNER JOIN LOOP ON it1.id = mi.info_type_id AND mk.movie_id = mi.movie_id
1 44297 │└TABLE SEEK movie_info AS mi
362 37091 INNER JOIN LOOP ON info as info = 'countries'
1 1 │└MATERIALISE AS m30
1 1 │ TABLE SCAN info_type AS it1 WHERE info as info = 'countries'
362 37091 INNER JOIN LOOP ON Bmk1012 = Bmk1012
1 37091 │└TABLE SEEK movie_keyword AS mk
362 37091 INNER JOIN LOOP ON k.id = mk.keyword_id
90 37091 │└TABLE SEEK movie_keyword AS mk
4 3 TABLE SCAN keyword AS k WHERE keyword as keyword = 'blood' OR keyword as keyword = 'murder' OR keyword as keyword = 'murder-in-title' OR keyword as keyword = 'violence'
|
|
1 ∞ PROJECT min AS rating, min_36 AS northern_dark_movie
1 1 AGGREGATE MIN(min_37) AS min, MIN(min_38) AS min_36
- 16 DISTRIBUTE GATHER
- 16 AGGREGATE MIN(info_21) AS min_37, MIN(title) AS min_38
- 761 INNER JOIN HASH ON kind_id = id_9
7 1 │└DISTRIBUTE GATHER
7 1 │ PROJECT id AS id_9
7 1 │ FILTER kind = 'movie'
7 1 │ TABLE SCAN kind_type
- 777 INNER JOIN HASH ON movie_id = id_31
159036 100553 │└DISTRIBUTE HASH ON id_31
159036 100553 │ PROJECT id AS id_31, title, kind_id
159036 100553 │ FILTER production_year > 2010
159036 100553 │ TABLE SCAN title
- 777 INNER JOIN HASH ON keyword_id = id_5
134170 3 │└DISTRIBUTE GATHER
134170 3 │ PROJECT id AS id_5
134170 3 │ FILTER keyword IN('blood','murder','murder-in-title','violence')
134170 3 │ TABLE SCAN keyword
- 777 INNER JOIN HASH ON movie_id = movie_id_27
4523930 1987 │└DISTRIBUTE HASH ON movie_id_27
4523930 1987 │ PROJECT movie_id AS movie_id_27, keyword_id
4523930 1987 │ TABLE SCAN movie_keyword
- 534 INNER JOIN HASH ON info_type_id_20 = id_0
113 1 │└DISTRIBUTE GATHER
113 1 │ PROJECT id AS id_0
113 1 │ FILTER info = 'rating'
113 1 │ TABLE SCAN info_type
- 534 INNER JOIN HASH ON movie_id = movie_id_19
1380035 820 │└DISTRIBUTE HASH ON movie_id_19
1380035 820 │ PROJECT movie_id AS movie_id_19, info_type_id AS info_type_id_20, info AS info_21
1380035 820 │ FILTER info < '8.5'
1380035 820 │ TABLE SCAN movie_info_idx
- 534 INNER JOIN HASH ON info_type_id = id
113 1 │└DISTRIBUTE GATHER
113 1 │ FILTER info = 'countries'
113 1 │ TABLE SCAN info_type
13352148 534 FILTER info IN('American','Denish','Denmark','German','Germany','Norway','Norwegian','Sweden','Swedish','USA')
13352148 534 TABLE SCAN movie_info
|
|
1 1 AGGREGATE MIN(info), MIN(title)
1 761 INNER JOIN LOOP ON id = info_type_id
1 878 │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id)
1 1147 │ │└INNER JOIN LOOP ON id = info_type_id
9 3403 │ │ │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id)
3 1966 │ │ │ │└INNER JOIN LOOP ON keyword IN('murder','murder-in-title','blood','violence') AND id = kind_id AND (id = kind_id)
1 1 │ │ │ │ │└TABLE SCAN kind_type AS kt WHERE kt.kind = 'movie'
21 2582 │ │ │ │ INNER JOIN LOOP ON id = movie_id
135 37091 │ │ │ │ │└INNER JOIN LOOP ON keyword_id = id
4 3 │ │ │ │ │ │└TABLE SEEK keyword AS k
915 37091 │ │ │ │ │ TABLE SEEK movie_keyword AS mk
37091 37091 │ │ │ │ TABLE SEEK title AS t WHERE t.production_year > 2010
5898 3401 │ │ │ TABLE SEEK movie_info_idx AS mi_idx WHERE mi_idx.info < '8.5'
4 4 │ │ TABLE SEEK info_type AS it2 WHERE it2.info = 'rating'
2294 1147 │ TABLE SEEK movie_info AS mi WHERE mi.info IN('Sweden','Norway','Germany','Denmark','Swedish','Denish','Norwegian','German','USA','American')
878 878 TABLE SEEK info_type AS it1 WHERE it1.info = 'countries'
|
