Skip to content

Instantly share code, notes, and snippets.

@tpetry

tpetry/medium-learning-explain.csv

Last active August 19, 2024 15:45
Show Gist options
  • Save tpetry/9a671c007513160d858f8ae5796311b2 to your computer and use it in GitHub Desktop.
Save tpetry/9a671c007513160d858f8ae5796311b2 to your computer and use it in GitHub Desktop.
Download ZIP
medium-learning-explain.csv
Raw
medium-learning-explain.csv
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE actor ALL PRIMARY 200 100.00
1 SIMPLE <subquery2> eq_ref <auto_distinct_key> <auto_distinct_key> 2 sakila.actor.actor_id 1 100.00
2 MATERIALIZED film index PRIMARY idx_title 514 1000 11.11 Using where; Using index
2 MATERIALIZED film_actor ref PRIMARY,idx_fk_film_id idx_fk_film_id 2 sakila.film.film_id 5 100.00 Using index
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment