Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

HTAP Optimizer effectiveness on IMDB dataset(Join-Order-Benchmark) Test Report #18906

Open
mahjonp opened this issue Jul 31, 2020 · 0 comments
Open

HTAP Optimizer effectiveness on IMDB dataset(Join-Order-Benchmark) Test Report #18906

mahjonp opened this issue Jul 31, 2020 · 0 comments
Assignees
@winoros
Labels
sig/planner SIG: Planner

Comments

@mahjonp
Copy link
Contributor

mahjonp commented Jul 31, 2020 •
edited
Loading

Follow by previous issue #18644, I give a report for TiDB with the TiFlash deployed.

TiDB Server Configuration

server_configs:
  tidb:
    log.slow-threshold: 300
    binlog.enable: false
    binlog.ignore-error: false
    mem-quota-query: 34359738368
    oom-use-tmp-storage: false
    tikv-client.copr-cache.enable: false
  tikv:
    # server.grpc-concurrency: 4
    # raftstore.apply-pool-size: 2
    # raftstore.store-pool-size: 2
    # rocksdb.max-sub-compactions: 1
    # storage.block-cache.capacity: "16GB"
    # readpool.unified.max-thread-count: 12
    readpool.storage.use-unified-pool: false
    readpool.coprocessor.use-unified-pool: true

tidb_servers:
  - host: 172.16.4.92
tikv_servers:
  - host: 172.16.4.82
tiflash_servers:
  - host: 172.16.4.85

172.16.4.92, 172.16.4.82 and 172.16.4.85 are40core, Intel(R) Xeon(R) CPU E5-2630, 2 NUMA nodes with NVME SSD.

Version info:

MySQL [INFORMATION_SCHEMA]> select * from CLUSTER_INFO;
+---------+-------------------+-------------------+----------------------------+------------------------------------------+---------------------------+---------------------+
| TYPE    | INSTANCE          | STATUS_ADDRESS    | VERSION                    | GIT_HASH                                 | START_TIME                | UPTIME              |
+---------+-------------------+-------------------+----------------------------+------------------------------------------+---------------------------+---------------------+
| tidb    | 172.16.4.92:4000  | 172.16.4.92:10080 | 4.0.0-beta.2               | 1e7454c81d1f4fae464e835d1a4023a911cfa87b | 2020-07-29T21:14:40+08:00 | 41h51m19.03627045s  |
| pd      | 172.16.4.82:2379  | 172.16.4.82:2379  | 4.1.0-alpha                | 434cefb50d2749a4045d00aa62765ca90761e749 | 2020-07-29T21:14:34+08:00 | 41h51m25.036276775s |
| pd      | 172.16.4.83:2379  | 172.16.4.83:2379  | 4.1.0-alpha                | 434cefb50d2749a4045d00aa62765ca90761e749 | 2020-07-29T21:14:34+08:00 | 41h51m25.036279688s |
| pd      | 172.16.4.85:2379  | 172.16.4.85:2379  | 4.1.0-alpha                | 434cefb50d2749a4045d00aa62765ca90761e749 | 2020-07-29T21:14:34+08:00 | 41h51m25.036282775s |
| tikv    | 172.16.4.82:20160 | 172.16.4.82:20180 | 4.1.0-alpha                | 3739657ff807102fb7acd495146dd8d95d63281d | 2020-07-29T21:14:37+08:00 | 41h51m22.036285395s |
| tiflash | 172.16.4.85:3930  | 172.16.4.85:20292 | v4.1.0-alpha-87-g13327c043 | 13327c043c5867c3561a08d593b0b6eecacd2a3a | 2020-07-29T21:15:30+08:00 | 41h50m29.036287735s |
+---------+-------------------+-------------------+----------------------------+------------------------------------------+---------------------------+---------------------+

Test Report

+---------+-------------+------------------------+--------------------------+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ID      | #PLAN SPACE | DEFAULT EXECUTION TIME | BEST PLAN EXECUTION TIME | EFFECTIVENESS | BETTER OPTIMAL PLANS                                                                                                                                                                                                                                                                                                                                                                                                              | ESTROW Q-ERROR                                   | QUERY                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
+---------+-------------+------------------------+--------------------------+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 20a.sql |         100 | 2927.5ms ±26%          | 1487.0ms ± 9%            | 62.0%         | #34(68.1%),#35(70.4%),#36(69.4%),#37(69.1%),#38(70.1%),#39(67.3%),#40(68.3%),#41(66.4%),#42(67.7%),#43(68.1%),#44(69.1%),#45(68.6%),#46(64.8%),#47(73.2%),#48(58.4%),#49(64.1%),#50(66.7%),#51(62.9%),#52(59.2%),#53(60.1%),#54(63.2%),#55(61.5%),#56(59.8%),#57(57.5%),#58(62.5%),#62(59.3%),#63(55.6%),#64(58.7%),#65(55.8%),#66(52.7%),#67(53.5%),#68(56.3%),#69(77.6%),#70(51.8%),#72(80.3%),#73(50.8%),#75(78.9%),#81(84.0%) | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(t.title) AS complete_downey_ironman_movie FROM (((((((((complete_cast AS cc) JOIN comp_cast_type AS cct1) JOIN comp_cast_type AS cct2) JOIN char_name AS chn) JOIN cast_info AS ci) JOIN keyword AS k) JOIN kind_type AS kt) JOIN movie_keyword AS mk) JOIN name AS n) JOIN title AS t WHERE cct1.kind="cast" AND cct2.kind LIKE "%complete%" AND chn.name NOT LIKE "%Sherlock%" AND (chn.name LIKE "%Tony%Stark%" OR chn.name LIKE "%Iron%Man%") AND k.keyword IN ("superhero","sequel","second-part","marvel-comics","based-on-comic","tv-special","fight","violence") AND kt.kind="movie" AND t.production_year>1950 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                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| 20b.sql |          96 | 1024.0ms ±22%          | 814.5ms ±13%             | 92.7%         | #53(85.9%),#54(84.7%),#56(83.4%),#62(84.5%),#64(85.0%),#70(85.0%),#73(79.5%)                                                                                                                                                                                                                                                                                                                                                      | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(t.title) AS complete_downey_ironman_movie FROM (((((((((complete_cast AS cc) JOIN comp_cast_type AS cct1) JOIN comp_cast_type AS cct2) JOIN char_name AS chn) JOIN cast_info AS ci) JOIN keyword AS k) JOIN kind_type AS kt) JOIN movie_keyword AS mk) JOIN name AS n) JOIN title AS t WHERE cct1.kind="cast" AND cct2.kind LIKE "%complete%" AND chn.name NOT LIKE "%Sherlock%" AND (chn.name LIKE "%Tony%Stark%" OR chn.name LIKE "%Iron%Man%") AND k.keyword IN ("superhero","sequel","second-part","marvel-comics","based-on-comic","tv-special","fight","violence") AND kt.kind="movie" AND n.name LIKE "%Downey%Robert%" 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                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| 20c.sql |         100 | 1057.0ms ±15%          | 814.0ms ±20%             | 81.0%         | #48(87.5%),#49(89.2%),#51(87.7%),#52(84.9%),#53(83.4%),#54(82.8%),#55(82.7%),#56(81.9%),#57(84.3%),#58(84.2%),#62(78.3%),#63(83.4%),#64(81.1%),#65(83.9%),#66(83.7%),#67(80.9%),#68(84.4%),#70(77.6%),#73(77.0%)                                                                                                                                                                                                                  | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(n.name) AS cast_member,MIN(t.title) AS complete_dynamic_hero_movie FROM (((((((((complete_cast AS cc) JOIN comp_cast_type AS cct1) JOIN comp_cast_type AS cct2) JOIN char_name AS chn) JOIN cast_info AS ci) JOIN keyword AS k) JOIN kind_type AS kt) JOIN movie_keyword AS mk) JOIN name AS n) JOIN 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                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| 21a.sql |         100 | 994.5ms ± 8%           | 994.5ms ± 8%             | 100.0%        |                                                                                                                                                                                                                                                                                                                                                                                                                                   | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(cn.name) AS company_name,MIN(lt.link) AS link_type,MIN(t.title) AS western_follow_up FROM ((((((((company_name AS cn) JOIN company_type AS ct) JOIN keyword AS k) JOIN link_type AS lt) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN movie_keyword AS mk) JOIN movie_link AS ml) JOIN title AS t WHERE cn.country_code!="[pl]" AND (cn.name LIKE "%Film%" OR cn.name LIKE "%Warner%") AND ct.kind="production companies" AND k.keyword="sequel" AND lt.link LIKE "%follow%" AND mc.note IS NULL AND mi.info IN ("Sweden","Norway","Germany","Denmark","Swedish","Denish","Norwegian","German") AND t.production_year BETWEEN 1950 AND 2000 AND lt.id=ml.link_type_id AND ml.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND t.id=mc.movie_id AND mc.company_type_id=ct.id AND mc.company_id=cn.id AND mi.movie_id=t.id AND ml.movie_id=mk.movie_id AND ml.movie_id=mc.movie_id AND mk.movie_id=mc.movie_id AND ml.movie_id=mi.movie_id AND mk.movie_id=mi.movie_id AND mc.movie_id=mi.movie_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| 21b.sql |         100 | 1023.8ms ±14%          | 1023.8ms ±14%            | 100.0%        |                                                                                                                                                                                                                                                                                                                                                                                                                                   | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(cn.name) AS company_name,MIN(lt.link) AS link_type,MIN(t.title) AS german_follow_up FROM ((((((((company_name AS cn) JOIN company_type AS ct) JOIN keyword AS k) JOIN link_type AS lt) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN movie_keyword AS mk) JOIN movie_link AS ml) JOIN title AS t WHERE cn.country_code!="[pl]" AND (cn.name LIKE "%Film%" OR cn.name LIKE "%Warner%") AND ct.kind="production companies" AND k.keyword="sequel" AND lt.link LIKE "%follow%" AND mc.note IS NULL AND mi.info IN ("Germany","German") AND t.production_year BETWEEN 2000 AND 2010 AND lt.id=ml.link_type_id AND ml.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND t.id=mc.movie_id AND mc.company_type_id=ct.id AND mc.company_id=cn.id AND mi.movie_id=t.id AND ml.movie_id=mk.movie_id AND ml.movie_id=mc.movie_id AND mk.movie_id=mc.movie_id AND ml.movie_id=mi.movie_id AND mk.movie_id=mi.movie_id AND mc.movie_id=mi.movie_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| 21c.sql |         100 | 1794.5ms ± 5%          | 1794.5ms ± 5%            | 100.0%        |                                                                                                                                                                                                                                                                                                                                                                                                                                   | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(cn.name) AS company_name,MIN(lt.link) AS link_type,MIN(t.title) AS western_follow_up FROM ((((((((company_name AS cn) JOIN company_type AS ct) JOIN keyword AS k) JOIN link_type AS lt) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN movie_keyword AS mk) JOIN movie_link AS ml) JOIN title AS t WHERE cn.country_code!="[pl]" AND (cn.name LIKE "%Film%" OR cn.name LIKE "%Warner%") AND ct.kind="production companies" AND k.keyword="sequel" AND lt.link LIKE "%follow%" AND mc.note IS NULL AND mi.info IN ("Sweden","Norway","Germany","Denmark","Swedish","Denish","Norwegian","German","English") AND t.production_year BETWEEN 1950 AND 2010 AND lt.id=ml.link_type_id AND ml.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND t.id=mc.movie_id AND mc.company_type_id=ct.id AND mc.company_id=cn.id AND mi.movie_id=t.id AND ml.movie_id=mk.movie_id AND ml.movie_id=mc.movie_id AND mk.movie_id=mc.movie_id AND ml.movie_id=mi.movie_id AND mk.movie_id=mi.movie_id AND mc.movie_id=mi.movie_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| 23a.sql |         100 | 1771.8ms ± 9%          | 633.5ms ±14%             | 96.0%         | #63(86.7%),#64(87.5%),#65(86.8%),#68(35.8%)                                                                                                                                                                                                                                                                                                                                                                                       | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(kt.kind) AS movie_kind,MIN(t.title) AS complete_us_internet_movie FROM ((((((((((complete_cast AS cc) JOIN comp_cast_type AS cct1) JOIN company_name AS cn) JOIN company_type AS ct) JOIN info_type AS it1) JOIN keyword AS k) JOIN kind_type AS kt) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN movie_keyword AS mk) JOIN title AS t WHERE cct1.kind="complete+verified" AND cn.country_code="[us]" AND it1.info="release dates" AND kt.kind IN ("movie") AND mi.note LIKE "%internet%" AND mi.info IS NOT NULL AND (mi.info LIKE "USA:% 199%" OR mi.info LIKE "USA:% 200%") AND t.production_year>2000 AND kt.id=t.kind_id AND t.id=mi.movie_id AND t.id=mk.movie_id AND t.id=mc.movie_id AND t.id=cc.movie_id AND mk.movie_id=mi.movie_id AND mk.movie_id=mc.movie_id AND mk.movie_id=cc.movie_id AND mi.movie_id=mc.movie_id AND mi.movie_id=cc.movie_id AND mc.movie_id=cc.movie_id AND k.id=mk.keyword_id AND it1.id=mi.info_type_id AND cn.id=mc.company_id AND ct.id=mc.company_type_id AND cct1.id=cc.status_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| 23b.sql |         100 | 1690.5ms ±14%          | 530.2ms ± 6%             | 99.0%         | #68(31.4%)                                                                                                                                                                                                                                                                                                                                                                                                                        | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(kt.kind) AS movie_kind,MIN(t.title) AS complete_nerdy_internet_movie FROM ((((((((((complete_cast AS cc) JOIN comp_cast_type AS cct1) JOIN company_name AS cn) JOIN company_type AS ct) JOIN info_type AS it1) JOIN keyword AS k) JOIN kind_type AS kt) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN movie_keyword AS mk) JOIN title AS t WHERE cct1.kind="complete+verified" AND cn.country_code="[us]" AND it1.info="release dates" AND k.keyword IN ("nerd","loner","alienation","dignity") AND kt.kind IN ("movie") AND mi.note LIKE "%internet%" AND mi.info LIKE "USA:% 200%" AND t.production_year>2000 AND kt.id=t.kind_id AND t.id=mi.movie_id AND t.id=mk.movie_id AND t.id=mc.movie_id AND t.id=cc.movie_id AND mk.movie_id=mi.movie_id AND mk.movie_id=mc.movie_id AND mk.movie_id=cc.movie_id AND mi.movie_id=mc.movie_id AND mi.movie_id=cc.movie_id AND mc.movie_id=cc.movie_id AND k.id=mk.keyword_id AND it1.id=mi.info_type_id AND cn.id=mc.company_id AND ct.id=mc.company_type_id AND cct1.id=cc.status_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| 23c.sql |         100 | 1781.0ms ±11%          | 646.0ms ± 8%             | 97.0%         | #62(89.0%),#64(89.2%),#68(36.3%)                                                                                                                                                                                                                                                                                                                                                                                                  | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(kt.kind) AS movie_kind,MIN(t.title) AS complete_us_internet_movie FROM ((((((((((complete_cast AS cc) JOIN comp_cast_type AS cct1) JOIN company_name AS cn) JOIN company_type AS ct) JOIN info_type AS it1) JOIN keyword AS k) JOIN kind_type AS kt) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN movie_keyword AS mk) JOIN title AS t WHERE cct1.kind="complete+verified" AND cn.country_code="[us]" AND it1.info="release dates" AND kt.kind IN ("movie","tv movie","video movie","video game") AND mi.note LIKE "%internet%" AND mi.info IS NOT NULL AND (mi.info LIKE "USA:% 199%" OR mi.info LIKE "USA:% 200%") AND t.production_year>1990 AND kt.id=t.kind_id AND t.id=mi.movie_id AND t.id=mk.movie_id AND t.id=mc.movie_id AND t.id=cc.movie_id AND mk.movie_id=mi.movie_id AND mk.movie_id=mc.movie_id AND mk.movie_id=cc.movie_id AND mi.movie_id=mc.movie_id AND mi.movie_id=cc.movie_id AND mc.movie_id=cc.movie_id AND k.id=mk.keyword_id AND it1.id=mi.info_type_id AND cn.id=mc.company_id AND ct.id=mc.company_type_id AND cct1.id=cc.status_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| 24a.sql |         100 | 2675.2ms ± 8%          | 2155.2ms ± 6%            | 99.0%         | #79(80.6%)                                                                                                                                                                                                                                                                                                                                                                                                                        | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | 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 (((((((((((aka_name AS an) JOIN char_name AS chn) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN info_type AS it) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN movie_keyword AS mk) JOIN name AS n) JOIN role_type AS rt) JOIN 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                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| 24b.sql |         100 | 49.5ms ±84%            | 49.5ms ±84%              | 100.0%        |                                                                                                                                                                                                                                                                                                                                                                                                                                   | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(chn.name) AS voiced_char_name,MIN(n.name) AS voicing_actress_name,MIN(t.title) AS kung_fu_panda FROM (((((((((((aka_name AS an) JOIN char_name AS chn) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN info_type AS it) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN movie_keyword AS mk) JOIN name AS n) JOIN role_type AS rt) JOIN 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                                                                                                                                                                                                                                                                                                                                                                                           |
| 27a.sql |         100 | 857.2ms ±13%           | 857.2ms ±13%             | 100.0%        |                                                                                                                                                                                                                                                                                                                                                                                                                                   | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(cn.name) AS producing_company,MIN(lt.link) AS link_type,MIN(t.title) AS complete_western_sequel FROM (((((((((((complete_cast AS cc) JOIN comp_cast_type AS cct1) JOIN comp_cast_type AS cct2) JOIN company_name AS cn) JOIN company_type AS ct) JOIN keyword AS k) JOIN link_type AS lt) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN movie_keyword AS mk) JOIN movie_link AS ml) JOIN title AS t WHERE cct1.kind IN ("cast","crew") AND cct2.kind="complete" AND cn.country_code!="[pl]" AND (cn.name LIKE "%Film%" OR cn.name LIKE "%Warner%") AND ct.kind="production companies" AND k.keyword="sequel" AND lt.link LIKE "%follow%" AND mc.note IS NULL AND mi.info IN ("Sweden","Germany","Swedish","German") AND t.production_year BETWEEN 1950 AND 2000 AND lt.id=ml.link_type_id AND ml.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND t.id=mc.movie_id AND mc.company_type_id=ct.id AND mc.company_id=cn.id AND mi.movie_id=t.id AND t.id=cc.movie_id AND cct1.id=cc.subject_id AND cct2.id=cc.status_id AND ml.movie_id=mk.movie_id AND ml.movie_id=mc.movie_id AND mk.movie_id=mc.movie_id AND ml.movie_id=mi.movie_id AND mk.movie_id=mi.movie_id AND mc.movie_id=mi.movie_id AND ml.movie_id=cc.movie_id AND mk.movie_id=cc.movie_id AND mc.movie_id=cc.movie_id AND mi.movie_id=cc.movie_id                                                                                                                                                                                                                                                                                                                                                                                                                        |
| 27b.sql |         100 | 787.0ms ±11%           | 787.0ms ±11%             | 100.0%        |                                                                                                                                                                                                                                                                                                                                                                                                                                   | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(cn.name) AS producing_company,MIN(lt.link) AS link_type,MIN(t.title) AS complete_western_sequel FROM (((((((((((complete_cast AS cc) JOIN comp_cast_type AS cct1) JOIN comp_cast_type AS cct2) JOIN company_name AS cn) JOIN company_type AS ct) JOIN keyword AS k) JOIN link_type AS lt) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN movie_keyword AS mk) JOIN movie_link AS ml) JOIN title AS t WHERE cct1.kind IN ("cast","crew") AND cct2.kind="complete" AND cn.country_code!="[pl]" AND (cn.name LIKE "%Film%" OR cn.name LIKE "%Warner%") AND ct.kind="production companies" AND k.keyword="sequel" AND lt.link LIKE "%follow%" AND mc.note IS NULL AND mi.info IN ("Sweden","Germany","Swedish","German") AND t.production_year=1998 AND lt.id=ml.link_type_id AND ml.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND t.id=mc.movie_id AND mc.company_type_id=ct.id AND mc.company_id=cn.id AND mi.movie_id=t.id AND t.id=cc.movie_id AND cct1.id=cc.subject_id AND cct2.id=cc.status_id AND ml.movie_id=mk.movie_id AND ml.movie_id=mc.movie_id AND mk.movie_id=mc.movie_id AND ml.movie_id=mi.movie_id AND mk.movie_id=mi.movie_id AND mc.movie_id=mi.movie_id AND ml.movie_id=cc.movie_id AND mk.movie_id=cc.movie_id AND mc.movie_id=cc.movie_id AND mi.movie_id=cc.movie_id                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| 27c.sql |         100 | 1711.8ms ± 2%          | 1711.8ms ± 2%            | 100.0%        |                                                                                                                                                                                                                                                                                                                                                                                                                                   | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(cn.name) AS producing_company,MIN(lt.link) AS link_type,MIN(t.title) AS complete_western_sequel FROM (((((((((((complete_cast AS cc) JOIN comp_cast_type AS cct1) JOIN comp_cast_type AS cct2) JOIN company_name AS cn) JOIN company_type AS ct) JOIN keyword AS k) JOIN link_type AS lt) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN movie_keyword AS mk) JOIN movie_link AS ml) JOIN title AS t WHERE cct1.kind="cast" AND cct2.kind LIKE "complete%" AND cn.country_code!="[pl]" AND (cn.name LIKE "%Film%" OR cn.name LIKE "%Warner%") AND ct.kind="production companies" AND k.keyword="sequel" AND lt.link LIKE "%follow%" AND mc.note IS NULL AND mi.info IN ("Sweden","Norway","Germany","Denmark","Swedish","Denish","Norwegian","German","English") AND t.production_year BETWEEN 1950 AND 2010 AND lt.id=ml.link_type_id AND ml.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND t.id=mc.movie_id AND mc.company_type_id=ct.id AND mc.company_id=cn.id AND mi.movie_id=t.id AND t.id=cc.movie_id AND cct1.id=cc.subject_id AND cct2.id=cc.status_id AND ml.movie_id=mk.movie_id AND ml.movie_id=mc.movie_id AND mk.movie_id=mc.movie_id AND ml.movie_id=mi.movie_id AND mk.movie_id=mi.movie_id AND mc.movie_id=mi.movie_id AND ml.movie_id=cc.movie_id AND mk.movie_id=cc.movie_id AND mc.movie_id=cc.movie_id AND mi.movie_id=cc.movie_id                                                                                                                                                                                                                                                                                                                                                                            |
| 29a.sql |         100 | 337.5ms ±29%           | 337.5ms ±29%             | 100.0%        |                                                                                                                                                                                                                                                                                                                                                                                                                                   | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(chn.name) AS voiced_char,MIN(n.name) AS voicing_actress,MIN(t.title) AS voiced_animation FROM ((((((((((((((((aka_name AS an) JOIN complete_cast AS cc) JOIN comp_cast_type AS cct1) JOIN comp_cast_type AS cct2) JOIN char_name AS chn) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN info_type AS it) JOIN info_type AS it3) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN movie_keyword AS mk) JOIN name AS n) JOIN person_info AS pi) JOIN role_type AS rt) JOIN title AS t WHERE cct1.kind="cast" AND cct2.kind="complete+verified" AND chn.name="Queen" AND ci.note IN ("(voice)","(voice) (uncredited)","(voice: English version)") AND cn.country_code="[us]" AND it.info="release dates" AND it3.info="trivia" AND k.keyword="computer-animation" AND mi.info IS NOT NULL AND (mi.info LIKE "Japan:%200%" OR mi.info LIKE "USA:%200%") AND n.gender="f" AND n.name LIKE "%An%" AND rt.role="actress" AND t.title="Shrek 2" AND t.production_year BETWEEN 2000 AND 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 t.id=cc.movie_id AND mc.movie_id=ci.movie_id AND mc.movie_id=mi.movie_id AND mc.movie_id=mk.movie_id AND mc.movie_id=cc.movie_id AND mi.movie_id=ci.movie_id AND mi.movie_id=mk.movie_id AND mi.movie_id=cc.movie_id AND ci.movie_id=mk.movie_id AND ci.movie_id=cc.movie_id AND mk.movie_id=cc.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 n.id=pi.person_id AND ci.person_id=pi.person_id AND it3.id=pi.info_type_id AND k.id=mk.keyword_id AND cct1.id=cc.subject_id AND cct2.id=cc.status_id |
| 29b.sql |         100 | 56.2ms ±75%            | 56.2ms ±75%              | 100.0%        |                                                                                                                                                                                                                                                                                                                                                                                                                                   | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(chn.name) AS voiced_char,MIN(n.name) AS voicing_actress,MIN(t.title) AS voiced_animation FROM ((((((((((((((((aka_name AS an) JOIN complete_cast AS cc) JOIN comp_cast_type AS cct1) JOIN comp_cast_type AS cct2) JOIN char_name AS chn) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN info_type AS it) JOIN info_type AS it3) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN movie_keyword AS mk) JOIN name AS n) JOIN person_info AS pi) JOIN role_type AS rt) JOIN title AS t WHERE cct1.kind="cast" AND cct2.kind="complete+verified" AND chn.name="Queen" AND ci.note IN ("(voice)","(voice) (uncredited)","(voice: English version)") AND cn.country_code="[us]" AND it.info="release dates" AND it3.info="height" AND k.keyword="computer-animation" AND mi.info LIKE "USA:%200%" AND n.gender="f" AND n.name LIKE "%An%" AND rt.role="actress" AND t.title="Shrek 2" AND t.production_year BETWEEN 2000 AND 2005 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 t.id=cc.movie_id AND mc.movie_id=ci.movie_id AND mc.movie_id=mi.movie_id AND mc.movie_id=mk.movie_id AND mc.movie_id=cc.movie_id AND mi.movie_id=ci.movie_id AND mi.movie_id=mk.movie_id AND mi.movie_id=cc.movie_id AND ci.movie_id=mk.movie_id AND ci.movie_id=cc.movie_id AND mk.movie_id=cc.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 n.id=pi.person_id AND ci.person_id=pi.person_id AND it3.id=pi.info_type_id AND k.id=mk.keyword_id AND cct1.id=cc.subject_id AND cct2.id=cc.status_id                                                         |
| 29c.sql |         100 | 2938.0ms ± 5%          | 2938.0ms ± 5%            | 100.0%        |                                                                                                                                                                                                                                                                                                                                                                                                                                   | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(chn.name) AS voiced_char,MIN(n.name) AS voicing_actress,MIN(t.title) AS voiced_animation FROM ((((((((((((((((aka_name AS an) JOIN complete_cast AS cc) JOIN comp_cast_type AS cct1) JOIN comp_cast_type AS cct2) JOIN char_name AS chn) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN info_type AS it) JOIN info_type AS it3) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN movie_keyword AS mk) JOIN name AS n) JOIN person_info AS pi) JOIN role_type AS rt) JOIN title AS t WHERE cct1.kind="cast" AND cct2.kind="complete+verified" AND ci.note IN ("(voice)","(voice: Japanese version)","(voice) (uncredited)","(voice: English version)") AND cn.country_code="[us]" AND it.info="release dates" AND it3.info="trivia" AND k.keyword="computer-animation" AND mi.info IS NOT NULL AND (mi.info LIKE "Japan:%200%" OR mi.info LIKE "USA:%200%") AND n.gender="f" AND n.name LIKE "%An%" AND rt.role="actress" AND t.production_year BETWEEN 2000 AND 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 t.id=cc.movie_id AND mc.movie_id=ci.movie_id AND mc.movie_id=mi.movie_id AND mc.movie_id=mk.movie_id AND mc.movie_id=cc.movie_id AND mi.movie_id=ci.movie_id AND mi.movie_id=mk.movie_id AND mi.movie_id=cc.movie_id AND ci.movie_id=mk.movie_id AND ci.movie_id=cc.movie_id AND mk.movie_id=cc.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 n.id=pi.person_id AND ci.person_id=pi.person_id AND it3.id=pi.info_type_id AND k.id=mk.keyword_id AND cct1.id=cc.subject_id AND cct2.id=cc.status_id                |
| 2a.sql  |          45 | 1093.8ms ± 9%          | 477.8ms ±15%             | 80.0%         | #28(83.5%),#29(84.8%),#30(88.8%),#33(87.2%),#35(87.5%),#38(43.7%),#41(88.5%),#42(88.2%),#43(86.2%)                                                                                                                                                                                                                                                                                                                                | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(t.title) AS movie_title FROM ((((company_name AS cn) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_keyword AS mk) JOIN title AS t WHERE cn.country_code="[de]" AND k.keyword="character-name-in-title" AND cn.id=mc.company_id AND mc.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND mc.movie_id=mk.movie_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| 2b.sql  |          45 | 967.2ms ±23%           | 475.5ms ±15%             | 97.8%         | #38(49.2%)                                                                                                                                                                                                                                                                                                                                                                                                                        | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(t.title) AS movie_title FROM ((((company_name AS cn) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_keyword AS mk) JOIN title AS t WHERE cn.country_code="[nl]" AND k.keyword="character-name-in-title" AND cn.id=mc.company_id AND mc.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND mc.movie_id=mk.movie_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| 2c.sql  |          45 | 10.2ms ±22%            | 10.2ms ±22%              | 100.0%        |                                                                                                                                                                                                                                                                                                                                                                                                                                   | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(t.title) AS movie_title FROM ((((company_name AS cn) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_keyword AS mk) JOIN title AS t WHERE cn.country_code="[sm]" AND k.keyword="character-name-in-title" AND cn.id=mc.company_id AND mc.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND mc.movie_id=mk.movie_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| 2d.sql  |          45 | 1061.2ms ± 3%          | 500.0ms ±12%             | 86.7%         | #28(81.4%),#30(88.9%),#33(87.1%),#35(87.4%),#38(47.1%),#42(89.6%)                                                                                                                                                                                                                                                                                                                                                                 | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(t.title) AS movie_title FROM ((((company_name AS cn) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_keyword AS mk) JOIN title AS t WHERE cn.country_code="[us]" AND k.keyword="character-name-in-title" AND cn.id=mc.company_id AND mc.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND mc.movie_id=mk.movie_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
+---------+-------------+------------------------+--------------------------+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

+---------+-------------+------------------------+--------------------------+---------------+----------------------------------------------------------------------------------------------------+--------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ID      | #PLAN SPACE | DEFAULT EXECUTION TIME | BEST PLAN EXECUTION TIME | EFFECTIVENESS | BETTER OPTIMAL PLANS                                                                               | ESTROW Q-ERROR                                   | QUERY                                                                                                                                                                                                                                                                                                                                                                                                                   |
+---------+-------------+------------------------+--------------------------+---------------+----------------------------------------------------------------------------------------------------+--------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 32a.sql |          44 | 3.2ms ±33%             | 3.2ms ±33%               | 100.0%        |                                                                                                    | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(lt.link) AS link_type,MIN(t1.title) AS first_movie,MIN(t2.title) AS second_movie FROM (((((keyword AS k) JOIN link_type AS lt) JOIN movie_keyword AS mk) JOIN movie_link AS ml) JOIN title AS t1) JOIN title AS t2 WHERE k.keyword="10,000-mile-club" AND mk.keyword_id=k.id AND t1.id=mk.movie_id AND ml.movie_id=t1.id AND ml.linked_movie_id=t2.id AND lt.id=ml.link_type_id AND mk.movie_id=t1.id        |
| 32b.sql |          54 | 15811.8ms ± 8%         | 15811.8ms ± 8%           | 100.0%        |                                                                                                    | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(lt.link) AS link_type,MIN(t1.title) AS first_movie,MIN(t2.title) AS second_movie FROM (((((keyword AS k) JOIN link_type AS lt) JOIN movie_keyword AS mk) JOIN movie_link AS ml) JOIN title AS t1) JOIN title AS t2 WHERE k.keyword="character-name-in-title" AND mk.keyword_id=k.id AND t1.id=mk.movie_id AND ml.movie_id=t1.id AND ml.linked_movie_id=t2.id AND lt.id=ml.link_type_id AND mk.movie_id=t1.id |
| 3a.sql  |          35 | 605.8ms ±12%           | 605.8ms ±12%             | 100.0%        |                                                                                                    | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(t.title) AS movie_title FROM (((keyword AS k) JOIN movie_info AS mi) JOIN movie_keyword AS mk) JOIN title AS t WHERE k.keyword LIKE "%sequel%" AND mi.info IN ("Sweden","Norway","Germany","Denmark","Swedish","Denish","Norwegian","German") AND t.production_year>2005 AND t.id=mi.movie_id AND t.id=mk.movie_id AND mk.movie_id=mi.movie_id AND k.id=mk.keyword_id                                        |
| 3b.sql  |          35 | 84.5ms ±14%            | 45.2ms ±32%              | 85.7%         | #26(85.2%),#31(85.8%),#33(58.9%),#34(53.6%),#35(87.6%)                                             | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(t.title) AS movie_title FROM (((keyword AS k) JOIN movie_info AS mi) JOIN movie_keyword AS mk) JOIN title AS t WHERE k.keyword LIKE "%sequel%" AND mi.info IN ("Bulgaria") AND t.production_year>2010 AND t.id=mi.movie_id AND t.id=mk.movie_id AND mk.movie_id=mi.movie_id AND k.id=mk.keyword_id                                                                                                           |
| 3c.sql  |          38 | 1468.8ms ± 3%          | 243.0ms ±14%             | 76.3%         | #16(26.5%),#17(17.2%),#18(16.5%),#19(17.4%),#24(75.2%),#25(22.8%),#26(24.2%),#27(24.0%),#31(32.6%) | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(t.title) AS movie_title FROM (((keyword AS k) JOIN movie_info AS mi) JOIN movie_keyword AS mk) JOIN title AS t WHERE k.keyword LIKE "%sequel%" AND mi.info IN ("Sweden","Norway","Germany","Denmark","Swedish","Denish","Norwegian","German","USA","American") AND t.production_year>1990 AND t.id=mi.movie_id AND t.id=mk.movie_id AND mk.movie_id=mi.movie_id AND k.id=mk.keyword_id                       |
+---------+-------------+------------------------+--------------------------+---------------+----------------------------------------------------------------------------------------------------+--------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

+--------+-------------+------------------------+--------------------------+---------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ID     | #PLAN SPACE | DEFAULT EXECUTION TIME | BEST PLAN EXECUTION TIME | EFFECTIVENESS | BETTER OPTIMAL PLANS                                                                                                                                                                                                                                                                                                                      | ESTROW Q-ERROR                                   | QUERY                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
+--------+-------------+------------------------+--------------------------+---------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 5a.sql |          50 | 82.5ms ±17%            | 70.2ms ± 6%              | 94.0%         | #32(86.7%),#34(87.6%),#41(85.2%)                                                                                                                                                                                                                                                                                                          | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(t.title) AS typical_european_movie FROM ((((company_type AS ct) JOIN info_type AS it) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN title AS t WHERE ct.kind="production companies" AND mc.note LIKE "%(theatrical)%" AND mc.note LIKE "%(France)%" AND mi.info IN ("Sweden","Norway","Germany","Denmark","Swedish","Denish","Norwegian","German") AND t.production_year>2005 AND t.id=mi.movie_id AND t.id=mc.movie_id AND mc.movie_id=mi.movie_id AND ct.id=mc.company_type_id AND it.id=mi.info_type_id                                                                                                                                                                                                                                                                                                                                                                            |
| 5b.sql |          50 | 76.2ms ±10%            | 62.8ms ±36%              | 98.0%         | #34(82.3%)                                                                                                                                                                                                                                                                                                                                | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(t.title) AS american_vhs_movie FROM ((((company_type AS ct) JOIN info_type AS it) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN title AS t WHERE ct.kind="production companies" AND mc.note LIKE "%(VHS)%" AND mc.note LIKE "%(USA)%" AND mc.note LIKE "%(1994)%" AND mi.info IN ("USA","America") AND t.production_year>2010 AND t.id=mi.movie_id AND t.id=mc.movie_id AND mc.movie_id=mi.movie_id AND ct.id=mc.company_type_id AND it.id=mi.info_type_id                                                                                                                                                                                                                                                                                                                                                                                                                            |
| 5c.sql |          50 | 1187.2ms ± 6%          | 156.8ms ±13%             | 74.0%         | #22(88.2%),#23(88.2%),#24(87.6%),#25(84.8%),#27(50.9%),#28(18.1%),#29(16.6%),#30(14.0%),#31(15.8%),#32(13.8%),#33(13.4%),#34(13.2%),#36(57.6%)                                                                                                                                                                                            | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(t.title) AS american_movie FROM ((((company_type AS ct) JOIN info_type AS it) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN title AS t WHERE ct.kind="production companies" AND mc.note NOT LIKE "%(TV)%" AND mc.note LIKE "%(USA)%" AND mi.info IN ("Sweden","Norway","Germany","Denmark","Swedish","Denish","Norwegian","German","USA","American") AND t.production_year>1990 AND t.id=mi.movie_id AND t.id=mc.movie_id AND mc.movie_id=mi.movie_id AND ct.id=mc.company_type_id AND it.id=mi.info_type_id                                                                                                                                                                                                                                                                                                                                                                          |
| 6a.sql |          45 | 77.5ms ±218%           | 77.5ms ±218%             | 100.0%        |                                                                                                                                                                                                                                                                                                                                           | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(k.keyword) AS movie_keyword,MIN(n.name) AS actor_name,MIN(t.title) AS marvel_movie FROM ((((cast_info AS ci) JOIN keyword AS k) JOIN movie_keyword AS mk) JOIN name AS n) JOIN title AS t WHERE k.keyword="marvel-cinematic-universe" AND n.name LIKE "%Downey%Robert%" AND t.production_year>2010 AND k.id=mk.keyword_id AND t.id=mk.movie_id AND t.id=ci.movie_id AND ci.movie_id=mk.movie_id AND n.id=ci.person_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| 6b.sql |          47 | 795.5ms ±28%           | 561.5ms ±17%             | 80.9%         | #17(80.8%),#18(73.3%),#19(71.7%),#20(78.7%),#26(77.5%),#27(74.9%),#28(76.9%),#34(70.6%),#41(82.3%)                                                                                                                                                                                                                                        | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(k.keyword) AS movie_keyword,MIN(n.name) AS actor_name,MIN(t.title) AS hero_movie FROM ((((cast_info AS ci) JOIN keyword AS k) JOIN movie_keyword AS mk) JOIN name AS n) JOIN title AS t WHERE k.keyword IN ("superhero","sequel","second-part","marvel-comics","based-on-comic","tv-special","fight","violence") AND n.name LIKE "%Downey%Robert%" AND t.production_year>2014 AND k.id=mk.keyword_id AND t.id=mk.movie_id AND t.id=ci.movie_id AND ci.movie_id=mk.movie_id AND n.id=ci.person_id                                                                                                                                                                                                                                                                                                                                                                                                |
| 6c.sql |          45 | 43.8ms ±71%            | 43.8ms ±71%              | 100.0%        |                                                                                                                                                                                                                                                                                                                                           | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(k.keyword) AS movie_keyword,MIN(n.name) AS actor_name,MIN(t.title) AS marvel_movie FROM ((((cast_info AS ci) JOIN keyword AS k) JOIN movie_keyword AS mk) JOIN name AS n) JOIN title AS t WHERE k.keyword="marvel-cinematic-universe" AND n.name LIKE "%Downey%Robert%" AND t.production_year>2014 AND k.id=mk.keyword_id AND t.id=mk.movie_id AND t.id=ci.movie_id AND ci.movie_id=mk.movie_id AND n.id=ci.person_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| 6d.sql |          47 | 2734.5ms ± 3%          | 1755.0ms ± 7%            | 74.5%         | #16(78.8%),#17(74.2%),#18(73.0%),#19(68.7%),#20(70.5%),#26(64.5%),#27(69.3%),#28(69.3%),#32(64.2%),#34(64.4%),#37(72.0%),#46(89.5%)                                                                                                                                                                                                       | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(k.keyword) AS movie_keyword,MIN(n.name) AS actor_name,MIN(t.title) AS hero_movie FROM ((((cast_info AS ci) JOIN keyword AS k) JOIN movie_keyword AS mk) JOIN name AS n) JOIN title AS t WHERE k.keyword IN ("superhero","sequel","second-part","marvel-comics","based-on-comic","tv-special","fight","violence") AND n.name LIKE "%Downey%Robert%" AND t.production_year>2000 AND k.id=mk.keyword_id AND t.id=mk.movie_id AND t.id=ci.movie_id AND ci.movie_id=mk.movie_id AND n.id=ci.person_id                                                                                                                                                                                                                                                                                                                                                                                                |
| 6e.sql |          45 | 76.0ms ±83%            | 76.0ms ±83%              | 100.0%        |                                                                                                                                                                                                                                                                                                                                           | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(k.keyword) AS movie_keyword,MIN(n.name) AS actor_name,MIN(t.title) AS marvel_movie FROM ((((cast_info AS ci) JOIN keyword AS k) JOIN movie_keyword AS mk) JOIN name AS n) JOIN title AS t WHERE k.keyword="marvel-cinematic-universe" AND n.name LIKE "%Downey%Robert%" AND t.production_year>2000 AND k.id=mk.keyword_id AND t.id=mk.movie_id AND t.id=ci.movie_id AND ci.movie_id=mk.movie_id AND n.id=ci.person_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| 6f.sql |          47 | 2966.0ms ± 9%          | 1941.2ms ±11%            | 74.5%         | #16(79.7%),#17(74.0%),#18(74.6%),#19(71.1%),#20(74.4%),#26(68.4%),#27(71.3%),#28(71.7%),#32(67.6%),#34(65.5%),#37(66.6%),#43(88.8%)                                                                                                                                                                                                       | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(k.keyword) AS movie_keyword,MIN(n.name) AS actor_name,MIN(t.title) AS hero_movie FROM ((((cast_info AS ci) JOIN keyword AS k) JOIN movie_keyword AS mk) JOIN name AS n) JOIN title AS t WHERE k.keyword IN ("superhero","sequel","second-part","marvel-comics","based-on-comic","tv-special","fight","violence") AND t.production_year>2000 AND k.id=mk.keyword_id AND t.id=mk.movie_id AND t.id=ci.movie_id AND ci.movie_id=mk.movie_id AND n.id=ci.person_id                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| 7a.sql |          77 | 141.0ms ±52%           | 141.0ms ±52%             | 100.0%        |                                                                                                                                                                                                                                                                                                                                           | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(n.name) AS of_person,MIN(t.title) AS biography_movie FROM (((((((aka_name AS an) JOIN cast_info AS ci) JOIN info_type AS it) JOIN link_type AS lt) JOIN movie_link AS ml) JOIN name AS n) JOIN person_info AS pi) JOIN title AS t WHERE an.name LIKE "%a%" AND it.info="mini biography" AND lt.link="features" AND n.name_pcode_cf BETWEEN "A" AND "F" AND (n.gender="m" OR (n.gender="f" AND n.name LIKE "B%")) AND pi.note="Volker Boehm" AND t.production_year BETWEEN 1980 AND 1995 AND n.id=an.person_id AND n.id=pi.person_id AND ci.person_id=n.id AND t.id=ci.movie_id AND ml.linked_movie_id=t.id AND lt.id=ml.link_type_id AND it.id=pi.info_type_id AND pi.person_id=an.person_id AND pi.person_id=ci.person_id AND an.person_id=ci.person_id AND ci.movie_id=ml.linked_movie_id                                                                                                     |
| 7b.sql |          88 | 103.2ms ±19%           | 103.2ms ±19%             | 100.0%        |                                                                                                                                                                                                                                                                                                                                           | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(n.name) AS of_person,MIN(t.title) AS biography_movie FROM (((((((aka_name AS an) JOIN cast_info AS ci) JOIN info_type AS it) JOIN link_type AS lt) JOIN movie_link AS ml) JOIN name AS n) JOIN person_info AS pi) JOIN title AS t WHERE an.name LIKE "%a%" AND it.info="mini biography" AND lt.link="features" AND n.name_pcode_cf LIKE "D%" AND n.gender="m" AND pi.note="Volker Boehm" AND t.production_year BETWEEN 1980 AND 1984 AND n.id=an.person_id AND n.id=pi.person_id AND ci.person_id=n.id AND t.id=ci.movie_id AND ml.linked_movie_id=t.id AND lt.id=ml.link_type_id AND it.id=pi.info_type_id AND pi.person_id=an.person_id AND pi.person_id=ci.person_id AND an.person_id=ci.person_id AND ci.movie_id=ml.linked_movie_id                                                                                                                                                        |
| 7c.sql |          77 | 8508.0ms ± 5%          | 8508.0ms ± 5%            | 100.0%        |                                                                                                                                                                                                                                                                                                                                           | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(n.name) AS cast_member_name,MIN(pi.info) AS cast_member_info FROM (((((((aka_name AS an) JOIN cast_info AS ci) JOIN info_type AS it) JOIN link_type AS lt) JOIN movie_link AS ml) JOIN name AS n) JOIN person_info AS pi) JOIN title AS t WHERE an.name IS NOT NULL AND (an.name LIKE "%a%" OR an.name LIKE "A%") AND it.info="mini biography" AND lt.link IN ("references","referenced in","features","featured in") AND n.name_pcode_cf BETWEEN "A" AND "F" AND (n.gender="m" OR (n.gender="f" AND n.name LIKE "A%")) AND pi.note IS NOT NULL AND t.production_year BETWEEN 1980 AND 2010 AND n.id=an.person_id AND n.id=pi.person_id AND ci.person_id=n.id AND t.id=ci.movie_id AND ml.linked_movie_id=t.id AND lt.id=ml.link_type_id AND it.id=pi.info_type_id AND pi.person_id=an.person_id AND pi.person_id=ci.person_id AND an.person_id=ci.person_id AND ci.movie_id=ml.linked_movie_id |
| 8a.sql |          85 | 705.0ms ±14%           | 533.8ms ±13%             | 96.5%         | #57(85.0%),#64(75.7%),#65(79.6%)                                                                                                                                                                                                                                                                                                          | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(an1.name) AS actress_pseudonym,MIN(t.title) AS japanese_movie_dubbed FROM ((((((aka_name AS an1) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN movie_companies AS mc) JOIN name AS n1) JOIN role_type AS rt) JOIN title AS t WHERE ci.note="(voice: English version)" AND cn.country_code="[jp]" AND mc.note LIKE "%(Japan)%" AND mc.note NOT LIKE "%(USA)%" AND n1.name LIKE "%Yo%" AND n1.name NOT LIKE "%Yu%" AND rt.role="actress" AND an1.person_id=n1.id AND n1.id=ci.person_id AND ci.movie_id=t.id AND t.id=mc.movie_id AND mc.company_id=cn.id AND ci.role_id=rt.id AND an1.person_id=ci.person_id AND ci.movie_id=mc.movie_id                                                                                                                                                                                                                                                   |
| 8b.sql |          83 | 301.0ms ±16%           | 301.0ms ±16%             | 100.0%        |                                                                                                                                                                                                                                                                                                                                           | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(an.name) AS acress_pseudonym,MIN(t.title) AS japanese_anime_movie FROM ((((((aka_name AS an) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN movie_companies AS mc) JOIN name AS n) JOIN role_type AS rt) JOIN title AS t WHERE ci.note="(voice: English version)" AND cn.country_code="[jp]" AND mc.note LIKE "%(Japan)%" AND mc.note NOT LIKE "%(USA)%" AND (mc.note LIKE "%(2006)%" OR mc.note LIKE "%(2007)%") AND n.name LIKE "%Yo%" AND n.name NOT LIKE "%Yu%" AND rt.role="actress" AND t.production_year BETWEEN 2006 AND 2007 AND (t.title LIKE "One Piece%" OR t.title LIKE "Dragon Ball Z%") AND an.person_id=n.id AND n.id=ci.person_id AND ci.movie_id=t.id AND t.id=mc.movie_id AND mc.company_id=cn.id AND ci.role_id=rt.id AND an.person_id=ci.person_id AND ci.movie_id=mc.movie_id                                                                                        |
| 8c.sql |          84 | 9128.2ms ± 4%          | 9128.2ms ± 4%            | 100.0%        |                                                                                                                                                                                                                                                                                                                                           | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(a1.name) AS writer_pseudo_name,MIN(t.title) AS movie_title FROM ((((((aka_name AS a1) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN movie_companies AS mc) JOIN name AS n1) JOIN role_type AS rt) JOIN title AS t WHERE cn.country_code="[us]" AND rt.role="writer" AND a1.person_id=n1.id AND n1.id=ci.person_id AND ci.movie_id=t.id AND t.id=mc.movie_id AND mc.company_id=cn.id AND ci.role_id=rt.id AND a1.person_id=ci.person_id AND ci.movie_id=mc.movie_id                                                                                                                                                                                                                                                                                                                                                                                                                        |
| 8d.sql |          84 | 1379.8ms ±14%          | 1379.8ms ±14%            | 100.0%        |                                                                                                                                                                                                                                                                                                                                           | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(an1.name) AS costume_designer_pseudo,MIN(t.title) AS movie_with_costumes FROM ((((((aka_name AS an1) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN movie_companies AS mc) JOIN name AS n1) JOIN role_type AS rt) JOIN title AS t WHERE cn.country_code="[us]" AND rt.role="costume designer" AND an1.person_id=n1.id AND n1.id=ci.person_id AND ci.movie_id=t.id AND t.id=mc.movie_id AND mc.company_id=cn.id AND ci.role_id=rt.id AND an1.person_id=ci.person_id AND ci.movie_id=mc.movie_id                                                                                                                                                                                                                                                                                                                                                                                             |
| 9a.sql |         100 | 882.8ms ± 6%           | 525.5ms ± 6%             | 70.0%         | #56(85.1%),#59(71.5%),#60(88.8%),#61(73.9%),#62(63.9%),#63(71.3%),#65(59.5%),#67(66.5%),#68(69.3%),#69(70.7%),#72(73.8%),#73(73.3%),#74(77.3%),#78(89.5%),#79(76.5%),#80(72.4%),#81(78.3%),#82(75.8%),#83(76.6%),#84(75.3%),#85(76.4%),#86(73.4%),#87(76.8%),#88(79.9%),#89(76.1%),#90(74.8%),#91(77.4%),#96(83.5%),#97(79.4%),#98(75.4%) | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(an.name) AS alternative_name,MIN(chn.name) AS character_name,MIN(t.title) AS movie FROM (((((((aka_name AS an) JOIN char_name AS chn) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN movie_companies AS mc) JOIN name AS n) JOIN role_type AS rt) JOIN title AS t WHERE ci.note IN ("(voice)","(voice: Japanese version)","(voice) (uncredited)","(voice: English version)") AND cn.country_code="[us]" AND mc.note IS NOT NULL AND (mc.note LIKE "%(USA)%" OR mc.note LIKE "%(worldwide)%") AND n.gender="f" AND n.name LIKE "%Ang%" AND rt.role="actress" AND t.production_year BETWEEN 2005 AND 2015 AND ci.movie_id=t.id AND t.id=mc.movie_id AND ci.movie_id=mc.movie_id AND mc.company_id=cn.id AND ci.role_id=rt.id AND n.id=ci.person_id AND chn.id=ci.person_role_id AND an.person_id=n.id AND an.person_id=ci.person_id                                                          |
| 9b.sql |         100 | 725.5ms ±16%           | 595.0ms ± 7%             | 95.0%         | #63(85.8%),#66(82.0%),#72(88.3%),#75(88.4%),#77(89.1%)                                                                                                                                                                                                                                                                                    | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(an.name) AS alternative_name,MIN(chn.name) AS voiced_character,MIN(n.name) AS voicing_actress,MIN(t.title) AS american_movie FROM (((((((aka_name AS an) JOIN char_name AS chn) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN movie_companies AS mc) JOIN name AS n) JOIN role_type AS rt) JOIN title AS t WHERE ci.note="(voice)" AND cn.country_code="[us]" AND mc.note LIKE "%(200%)%" AND (mc.note LIKE "%(USA)%" OR mc.note LIKE "%(worldwide)%") AND n.gender="f" AND n.name LIKE "%Angel%" AND rt.role="actress" AND t.production_year BETWEEN 2007 AND 2010 AND ci.movie_id=t.id AND t.id=mc.movie_id AND ci.movie_id=mc.movie_id AND mc.company_id=cn.id AND ci.role_id=rt.id AND n.id=ci.person_id AND chn.id=ci.person_role_id AND an.person_id=n.id AND an.person_id=ci.person_id                                                                                             |
| 9c.sql |          94 | 832.8ms ± 8%           | 832.8ms ± 8%             | 100.0%        |                                                                                                                                                                                                                                                                                                                                           | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(an.name) AS alternative_name,MIN(chn.name) AS voiced_character_name,MIN(n.name) AS voicing_actress,MIN(t.title) AS american_movie FROM (((((((aka_name AS an) JOIN char_name AS chn) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN movie_companies AS mc) JOIN name AS n) JOIN role_type AS rt) JOIN title AS t WHERE ci.note IN ("(voice)","(voice: Japanese version)","(voice) (uncredited)","(voice: English version)") AND cn.country_code="[us]" AND n.gender="f" AND n.name LIKE "%An%" AND rt.role="actress" AND ci.movie_id=t.id AND t.id=mc.movie_id AND ci.movie_id=mc.movie_id AND mc.company_id=cn.id AND ci.role_id=rt.id AND n.id=ci.person_id AND chn.id=ci.person_role_id AND an.person_id=n.id AND an.person_id=ci.person_id                                                                                                                                             |
| 9d.sql |          94 | 2261.5ms ± 7%          | 2261.5ms ± 7%            | 100.0%        |                                                                                                                                                                                                                                                                                                                                           | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(an.name) AS alternative_name,MIN(chn.name) AS voiced_char_name,MIN(n.name) AS voicing_actress,MIN(t.title) AS american_movie FROM (((((((aka_name AS an) JOIN char_name AS chn) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN movie_companies AS mc) JOIN name AS n) JOIN role_type AS rt) JOIN title AS t WHERE ci.note IN ("(voice)","(voice: Japanese version)","(voice) (uncredited)","(voice: English version)") AND cn.country_code="[us]" AND n.gender="f" AND rt.role="actress" AND ci.movie_id=t.id AND t.id=mc.movie_id AND ci.movie_id=mc.movie_id AND mc.company_id=cn.id AND ci.role_id=rt.id AND n.id=ci.person_id AND chn.id=ci.person_role_id AND an.person_id=n.id AND an.person_id=ci.person_id                                                                                                                                                                         |
+--------+-------------+------------------------+--------------------------+---------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

+---------+-------------+------------------------+--------------------------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ID      | #PLAN SPACE | DEFAULT EXECUTION TIME | BEST PLAN EXECUTION TIME | EFFECTIVENESS | BETTER OPTIMAL PLANS                                                                                                                                                                                                                              | ESTROW Q-ERROR                                   | QUERY                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
+---------+-------------+------------------------+--------------------------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 10a.sql |          70 | 4317.2ms ± 4%          | 661.0ms ± 4%             | 92.9%         | #32(16.1%),#34(17.2%),#35(15.5%),#36(16.7%),#37(15.3%)                                                                                                                                                                                            | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(chn.name) AS uncredited_voiced_character,MIN(t.title) AS russian_movie FROM ((((((char_name AS chn) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN company_type AS ct) JOIN movie_companies AS mc) JOIN role_type AS rt) JOIN title AS t WHERE ci.note LIKE "%(voice)%" AND ci.note LIKE "%(uncredited)%" AND cn.country_code="[ru]" AND rt.role="actor" AND t.production_year>2005 AND t.id=mc.movie_id AND t.id=ci.movie_id AND ci.movie_id=mc.movie_id AND chn.id=ci.person_role_id AND rt.id=ci.role_id AND cn.id=mc.company_id AND ct.id=mc.company_type_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| 11a.sql |          89 | 1149.2ms ±20%          | 1149.2ms ±20%            | 100.0%        |                                                                                                                                                                                                                                                   | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(cn.name) AS from_company,MIN(lt.link) AS movie_link_type,MIN(t.title) AS non_polish_sequel_movie FROM (((((((company_name AS cn) JOIN company_type AS ct) JOIN keyword AS k) JOIN link_type AS lt) JOIN movie_companies AS mc) JOIN movie_keyword AS mk) JOIN movie_link AS ml) JOIN title AS t WHERE cn.country_code!="[pl]" AND (cn.name LIKE "%Film%" OR cn.name LIKE "%Warner%") AND ct.kind="production companies" AND k.keyword="sequel" AND lt.link LIKE "%follow%" AND mc.note IS NULL AND t.production_year BETWEEN 1950 AND 2000 AND lt.id=ml.link_type_id AND ml.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND t.id=mc.movie_id AND mc.company_type_id=ct.id AND mc.company_id=cn.id AND ml.movie_id=mk.movie_id AND ml.movie_id=mc.movie_id AND mk.movie_id=mc.movie_id                                                                                                                                                                                                                                                                                |
| 11b.sql |          97 | 591.2ms ± 7%           | 505.5ms ±11%             | 96.9%         | #64(86.3%),#65(85.5%),#70(89.0%)                                                                                                                                                                                                                  | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(cn.name) AS from_company,MIN(lt.link) AS movie_link_type,MIN(t.title) AS sequel_movie FROM (((((((company_name AS cn) JOIN company_type AS ct) JOIN keyword AS k) JOIN link_type AS lt) JOIN movie_companies AS mc) JOIN movie_keyword AS mk) JOIN movie_link AS ml) JOIN title AS t WHERE cn.country_code!="[pl]" AND (cn.name LIKE "%Film%" OR cn.name LIKE "%Warner%") AND ct.kind="production companies" AND k.keyword="sequel" AND lt.link LIKE "%follows%" AND mc.note IS NULL AND t.production_year=1998 AND t.title LIKE "%Money%" AND lt.id=ml.link_type_id AND ml.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND t.id=mc.movie_id AND mc.company_type_id=ct.id AND mc.company_id=cn.id AND ml.movie_id=mk.movie_id AND ml.movie_id=mc.movie_id AND mk.movie_id=mc.movie_id                                                                                                                                                                                                                                                                                |
| 11c.sql |          84 | 15512.0ms ± 7%         | 15512.0ms ± 7%           | 100.0%        |                                                                                                                                                                                                                                                   | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(cn.name) AS from_company,MIN(mc.note) AS production_note,MIN(t.title) AS movie_based_on_book FROM (((((((company_name AS cn) JOIN company_type AS ct) JOIN keyword AS k) JOIN link_type AS lt) JOIN movie_companies AS mc) JOIN movie_keyword AS mk) JOIN movie_link AS ml) JOIN title AS t WHERE cn.country_code!="[pl]" AND (cn.name LIKE "20th Century Fox%" OR cn.name LIKE "Twentieth Century Fox%") AND ct.kind!="production companies" AND ct.kind IS NOT NULL AND k.keyword IN ("sequel","revenge","based-on-novel") AND mc.note IS NOT NULL AND t.production_year>1950 AND lt.id=ml.link_type_id AND ml.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND t.id=mc.movie_id AND mc.company_type_id=ct.id AND mc.company_id=cn.id AND ml.movie_id=mk.movie_id AND ml.movie_id=mc.movie_id AND mk.movie_id=mc.movie_id                                                                                                                                                                                                                                           |
| 15a.sql |         100 | 1909.5ms ±13%          | 563.2ms ± 9%             | 99.0%         | #62(29.5%)                                                                                                                                                                                                                                        | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(mi.info) AS release_date,MIN(t.title) AS internet_movie FROM ((((((((aka_title AS at) JOIN company_name AS cn) JOIN company_type AS ct) JOIN info_type AS it1) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN movie_keyword AS mk) JOIN title AS t WHERE cn.country_code="[us]" AND it1.info="release dates" AND mc.note LIKE "%(200%)%" AND mc.note LIKE "%(worldwide)%" AND mi.note LIKE "%internet%" AND mi.info LIKE "USA:% 200%" AND t.production_year>2000 AND t.id=at.movie_id AND t.id=mi.movie_id AND t.id=mk.movie_id AND t.id=mc.movie_id AND mk.movie_id=mi.movie_id AND mk.movie_id=mc.movie_id AND mk.movie_id=at.movie_id AND mi.movie_id=mc.movie_id AND mi.movie_id=at.movie_id AND mc.movie_id=at.movie_id AND k.id=mk.keyword_id AND it1.id=mi.info_type_id AND cn.id=mc.company_id AND ct.id=mc.company_type_id                                                                                                                                                                                                                    |
| 15b.sql |         100 | 134.2ms ±24%           | 99.8ms ±43%              | 99.0%         | #83(74.3%)                                                                                                                                                                                                                                        | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(mi.info) AS release_date,MIN(t.title) AS youtube_movie FROM ((((((((aka_title AS at) JOIN company_name AS cn) JOIN company_type AS ct) JOIN info_type AS it1) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN movie_keyword AS mk) JOIN title AS t WHERE cn.country_code="[us]" AND cn.name="YouTube" AND it1.info="release dates" AND mc.note LIKE "%(200%)%" AND mc.note LIKE "%(worldwide)%" AND mi.note LIKE "%internet%" AND mi.info LIKE "USA:% 200%" AND t.production_year BETWEEN 2005 AND 2010 AND t.id=at.movie_id AND t.id=mi.movie_id AND t.id=mk.movie_id AND t.id=mc.movie_id AND mk.movie_id=mi.movie_id AND mk.movie_id=mc.movie_id AND mk.movie_id=at.movie_id AND mi.movie_id=mc.movie_id AND mi.movie_id=at.movie_id AND mc.movie_id=at.movie_id AND k.id=mk.keyword_id AND it1.id=mi.info_type_id AND cn.id=mc.company_id AND ct.id=mc.company_type_id                                                                                                                                                                              |
| 15c.sql |         100 | 2041.8ms ±10%          | 681.0ms ± 5%             | 99.0%         | #62(33.4%)                                                                                                                                                                                                                                        | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(mi.info) AS release_date,MIN(t.title) AS modern_american_internet_movie FROM ((((((((aka_title AS at) JOIN company_name AS cn) JOIN company_type AS ct) JOIN info_type AS it1) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN movie_keyword AS mk) JOIN title AS t WHERE cn.country_code="[us]" AND it1.info="release dates" AND mi.note LIKE "%internet%" AND mi.info IS NOT NULL AND (mi.info LIKE "USA:% 199%" OR mi.info LIKE "USA:% 200%") AND t.production_year>1990 AND t.id=at.movie_id AND t.id=mi.movie_id AND t.id=mk.movie_id AND t.id=mc.movie_id AND mk.movie_id=mi.movie_id AND mk.movie_id=mc.movie_id AND mk.movie_id=at.movie_id AND mi.movie_id=mc.movie_id AND mi.movie_id=at.movie_id AND mc.movie_id=at.movie_id AND k.id=mk.keyword_id AND it1.id=mi.info_type_id AND cn.id=mc.company_id AND ct.id=mc.company_type_id                                                                                                                                                                                                          |
| 15d.sql |         100 | 1962.8ms ± 4%          | 1582.5ms ± 5%            | 95.0%         | #62(80.6%),#63(80.9%),#64(83.3%),#65(82.5%),#66(83.2%)                                                                                                                                                                                            | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(at.title) AS aka_title,MIN(t.title) AS internet_movie_title FROM ((((((((aka_title AS at) JOIN company_name AS cn) JOIN company_type AS ct) JOIN info_type AS it1) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN movie_keyword AS mk) JOIN title AS t WHERE cn.country_code="[us]" AND it1.info="release dates" AND mi.note LIKE "%internet%" AND t.production_year>1990 AND t.id=at.movie_id AND t.id=mi.movie_id AND t.id=mk.movie_id AND t.id=mc.movie_id AND mk.movie_id=mi.movie_id AND mk.movie_id=mc.movie_id AND mk.movie_id=at.movie_id AND mi.movie_id=mc.movie_id AND mi.movie_id=at.movie_id AND mc.movie_id=at.movie_id AND k.id=mk.keyword_id AND it1.id=mi.info_type_id AND cn.id=mc.company_id AND ct.id=mc.company_type_id                                                                                                                                                                                                                                                                                                           |
| 16a.sql |          88 | 317.0ms ±75%           | 317.0ms ±75%             | 100.0%        |                                                                                                                                                                                                                                                   | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(an.name) AS cool_actor_pseudonym,MIN(t.title) AS series_named_after_char FROM (((((((aka_name AS an) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_keyword AS mk) JOIN name AS n) JOIN title AS t WHERE cn.country_code="[us]" AND k.keyword="character-name-in-title" AND t.episode_nr>=50 AND t.episode_nr<100 AND an.person_id=n.id AND n.id=ci.person_id AND ci.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND t.id=mc.movie_id AND mc.company_id=cn.id AND an.person_id=ci.person_id AND ci.movie_id=mc.movie_id AND ci.movie_id=mk.movie_id AND mc.movie_id=mk.movie_id                                                                                                                                                                                                                                                                                                                                                                                                                            |
| 16b.sql |          87 | 5569.5ms ± 7%          | 4328.5ms ± 7%            | 85.1%         | #46(87.7%),#48(89.8%),#51(89.8%),#53(89.3%),#67(83.7%),#70(78.8%),#71(77.7%),#74(87.9%),#75(87.3%),#76(88.2%),#78(89.9%),#80(87.5%),#86(88.2%)                                                                                                    | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(an.name) AS cool_actor_pseudonym,MIN(t.title) AS series_named_after_char FROM (((((((aka_name AS an) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_keyword AS mk) JOIN name AS n) JOIN title AS t WHERE cn.country_code="[us]" AND k.keyword="character-name-in-title" AND an.person_id=n.id AND n.id=ci.person_id AND ci.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND t.id=mc.movie_id AND mc.company_id=cn.id AND an.person_id=ci.person_id AND ci.movie_id=mc.movie_id AND ci.movie_id=mk.movie_id AND mc.movie_id=mk.movie_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| 16c.sql |          88 | 1016.5ms ± 9%          | 872.2ms ±21%             | 95.5%         | #71(87.7%),#72(85.8%),#86(88.4%),#88(89.9%)                                                                                                                                                                                                       | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(an.name) AS cool_actor_pseudonym,MIN(t.title) AS series_named_after_char FROM (((((((aka_name AS an) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_keyword AS mk) JOIN name AS n) JOIN title AS t WHERE cn.country_code="[us]" AND k.keyword="character-name-in-title" AND t.episode_nr<100 AND an.person_id=n.id AND n.id=ci.person_id AND ci.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND t.id=mc.movie_id AND mc.company_id=cn.id AND an.person_id=ci.person_id AND ci.movie_id=mc.movie_id AND ci.movie_id=mk.movie_id AND mc.movie_id=mk.movie_id                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| 16d.sql |          88 | 762.0ms ±20%           | 762.0ms ±20%             | 100.0%        |                                                                                                                                                                                                                                                   | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(an.name) AS cool_actor_pseudonym,MIN(t.title) AS series_named_after_char FROM (((((((aka_name AS an) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_keyword AS mk) JOIN name AS n) JOIN title AS t WHERE cn.country_code="[us]" AND k.keyword="character-name-in-title" AND t.episode_nr>=5 AND t.episode_nr<100 AND an.person_id=n.id AND n.id=ci.person_id AND ci.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND t.id=mc.movie_id AND mc.company_id=cn.id AND an.person_id=ci.person_id AND ci.movie_id=mc.movie_id AND ci.movie_id=mk.movie_id AND mc.movie_id=mk.movie_id                                                                                                                                                                                                                                                                                                                                                                                                                             |
| 17a.sql |          83 | 3927.2ms ± 3%          | 2578.2ms ± 8%            | 73.5%         | #36(77.0%),#37(70.6%),#38(71.7%),#39(72.3%),#40(74.3%),#45(86.5%),#46(67.3%),#47(69.6%),#48(69.8%),#60(70.9%),#61(72.5%),#62(70.6%),#63(87.2%),#64(82.1%),#65(71.7%),#66(87.3%),#67(85.8%),#68(72.7%),#69(72.0%),#70(70.1%),#73(65.7%),#76(89.2%) | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(n.name) AS member_in_charnamed_american_movie,MIN(n.name) AS a1 FROM ((((((cast_info AS ci) JOIN company_name AS cn) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_keyword AS mk) JOIN name AS n) JOIN title AS t WHERE cn.country_code="[us]" AND k.keyword="character-name-in-title" AND n.name LIKE "B%" AND n.id=ci.person_id AND ci.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND t.id=mc.movie_id AND mc.company_id=cn.id AND ci.movie_id=mc.movie_id AND ci.movie_id=mk.movie_id AND mc.movie_id=mk.movie_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| 17b.sql |          88 | 3886.5ms ± 6%          | 3886.5ms ± 6%            | 100.0%        |                                                                                                                                                                                                                                                   | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(n.name) AS member_in_charnamed_movie,MIN(n.name) AS a1 FROM ((((((cast_info AS ci) JOIN company_name AS cn) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_keyword AS mk) JOIN name AS n) JOIN title AS t WHERE k.keyword="character-name-in-title" AND n.name LIKE "Z%" AND n.id=ci.person_id AND ci.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND t.id=mc.movie_id AND mc.company_id=cn.id AND ci.movie_id=mc.movie_id AND ci.movie_id=mk.movie_id AND mc.movie_id=mk.movie_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| 17c.sql |          88 | 4000.5ms ± 6%          | 4000.5ms ± 6%            | 100.0%        |                                                                                                                                                                                                                                                   | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(n.name) AS member_in_charnamed_movie,MIN(n.name) AS a1 FROM ((((((cast_info AS ci) JOIN company_name AS cn) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_keyword AS mk) JOIN name AS n) JOIN title AS t WHERE k.keyword="character-name-in-title" AND n.name LIKE "X%" AND n.id=ci.person_id AND ci.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND t.id=mc.movie_id AND mc.company_id=cn.id AND ci.movie_id=mc.movie_id AND ci.movie_id=mk.movie_id AND mc.movie_id=mk.movie_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| 17d.sql |          87 | 4968.0ms ± 7%          | 3959.5ms ± 2%            | 96.6%         | #84(83.6%),#85(81.1%),#86(79.7%)                                                                                                                                                                                                                  | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(n.name) AS member_in_charnamed_movie FROM ((((((cast_info AS ci) JOIN company_name AS cn) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_keyword AS mk) JOIN name AS n) JOIN title AS t WHERE k.keyword="character-name-in-title" AND n.name LIKE "%Bert%" AND n.id=ci.person_id AND ci.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND t.id=mc.movie_id AND mc.company_id=cn.id AND ci.movie_id=mc.movie_id AND ci.movie_id=mk.movie_id AND mc.movie_id=mk.movie_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| 17e.sql |          82 | 4000.0ms ± 4%          | 2942.8ms ± 4%            | 80.5%         | #36(84.4%),#37(79.5%),#38(80.4%),#39(79.0%),#40(81.5%),#46(75.1%),#47(78.5%),#48(78.9%),#60(81.0%),#61(80.5%),#62(78.5%),#65(78.0%),#68(78.9%),#69(79.5%),#70(78.1%),#73(73.6%)                                                                   | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(n.name) AS member_in_charnamed_movie FROM ((((((cast_info AS ci) JOIN company_name AS cn) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_keyword AS mk) JOIN name AS n) JOIN title AS t WHERE cn.country_code="[us]" AND k.keyword="character-name-in-title" AND n.id=ci.person_id AND ci.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND t.id=mc.movie_id AND mc.company_id=cn.id AND ci.movie_id=mc.movie_id AND ci.movie_id=mk.movie_id AND mc.movie_id=mk.movie_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| 17f.sql |          87 | 5052.2ms ± 6%          | 3809.5ms ± 9%            | 96.6%         | #84(81.3%),#85(75.4%),#86(82.6%)                                                                                                                                                                                                                  | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(n.name) AS member_in_charnamed_movie FROM ((((((cast_info AS ci) JOIN company_name AS cn) JOIN keyword AS k) JOIN movie_companies AS mc) JOIN movie_keyword AS mk) JOIN name AS n) JOIN title AS t WHERE k.keyword="character-name-in-title" AND n.name LIKE "%B%" AND n.id=ci.person_id AND ci.movie_id=t.id AND t.id=mk.movie_id AND mk.keyword_id=k.id AND t.id=mc.movie_id AND mc.company_id=cn.id AND ci.movie_id=mc.movie_id AND ci.movie_id=mk.movie_id AND mc.movie_id=mk.movie_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| 19a.sql |         100 | 2771.2ms ± 2%          | 2247.2ms ± 9%            | 99.0%         | #63(81.1%)                                                                                                                                                                                                                                        | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(n.name) AS voicing_actress,MIN(t.title) AS voiced_movie FROM (((((((((aka_name AS an) JOIN char_name AS chn) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN info_type AS it) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN name AS n) JOIN role_type AS rt) JOIN 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 mc.note IS NOT NULL AND (mc.note LIKE "%(USA)%" OR mc.note LIKE "%(worldwide)%") AND mi.info IS NOT NULL AND (mi.info LIKE "Japan:%200%" OR mi.info LIKE "USA:%200%") AND n.gender="f" AND n.name LIKE "%Ang%" AND rt.role="actress" AND t.production_year BETWEEN 2005 AND 2009 AND t.id=mi.movie_id AND t.id=mc.movie_id AND t.id=ci.movie_id AND mc.movie_id=ci.movie_id AND mc.movie_id=mi.movie_id AND mi.movie_id=ci.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 |
| 19b.sql |         100 | 2583.0ms ±12%          | 619.0ms ±16%             | 83.0%         | #45(81.7%),#46(80.4%),#47(80.0%),#48(79.8%),#51(24.0%),#52(81.1%),#53(86.4%),#55(83.1%),#56(83.8%),#57(83.3%),#59(81.3%),#60(79.7%),#61(83.3%),#62(83.2%),#63(83.3%),#64(86.7%),#66(85.1%)                                                        | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(n.name) AS voicing_actress,MIN(t.title) AS kung_fu_panda FROM (((((((((aka_name AS an) JOIN char_name AS chn) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN info_type AS it) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN name AS n) JOIN role_type AS rt) JOIN title AS t WHERE ci.note="(voice)" AND cn.country_code="[us]" AND it.info="release dates" AND mc.note LIKE "%(200%)%" AND (mc.note LIKE "%(USA)%" OR mc.note LIKE "%(worldwide)%") AND mi.info IS NOT NULL AND (mi.info LIKE "Japan:%2007%" OR mi.info LIKE "USA:%2008%") AND n.gender="f" AND n.name LIKE "%Angel%" AND rt.role="actress" AND t.production_year BETWEEN 2007 AND 2008 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 mc.movie_id=ci.movie_id AND mc.movie_id=mi.movie_id AND mi.movie_id=ci.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                                        |
| 19c.sql |         100 | 2677.0ms ± 4%          | 2167.2ms ± 5%            | 99.0%         | #56(81.0%)                                                                                                                                                                                                                                        | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(n.name) AS voicing_actress,MIN(t.title) AS jap_engl_voiced_movie FROM (((((((((aka_name AS an) JOIN char_name AS chn) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN info_type AS it) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN name AS n) JOIN role_type AS rt) JOIN 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 mi.info IS NOT NULL AND (mi.info LIKE "Japan:%200%" OR mi.info LIKE "USA:%200%") AND n.gender="f" AND n.name LIKE "%An%" AND rt.role="actress" AND t.production_year>2000 AND t.id=mi.movie_id AND t.id=mc.movie_id AND t.id=ci.movie_id AND mc.movie_id=ci.movie_id AND mc.movie_id=mi.movie_id AND mi.movie_id=ci.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                                                                                               |
| 19d.sql |         100 | 11362.0ms ± 3%         | 11362.0ms ± 3%           | 100.0%        |                                                                                                                                                                                                                                                   | count:0, median:NaN, 90th:NaN, 95th:NaN, max:NaN | SELECT MIN(n.name) AS voicing_actress,MIN(t.title) AS jap_engl_voiced_movie FROM (((((((((aka_name AS an) JOIN char_name AS chn) JOIN cast_info AS ci) JOIN company_name AS cn) JOIN info_type AS it) JOIN movie_companies AS mc) JOIN movie_info AS mi) JOIN name AS n) JOIN role_type AS rt) JOIN 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 n.gender="f" AND rt.role="actress" AND t.production_year>2000 AND t.id=mi.movie_id AND t.id=mc.movie_id AND t.id=ci.movie_id AND mc.movie_id=ci.movie_id AND mc.movie_id=mi.movie_id AND mi.movie_id=ci.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.pe
@mahjonp mahjonp added the sig/planner SIG: Planner label Jul 31, 2020
@winoros winoros self-assigned this Aug 13, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@winoros winoros

Labels
sig/planner SIG: Planner
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@mahjonp @winoros