Skip to content

Instantly share code, notes, and snippets.

@nikushi

nikushi/slow-query.md

Created May 1, 2014 10:55
Show Gist options
  • Save nikushi/65f80efd8f659bdc8719 to your computer and use it in GitHub Desktop.
Save nikushi/65f80efd8f659bdc8719 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
slow-query.md 
Count: 1  Time=0.25s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), yohoushi[yohoushi]@localhost
  SELECT  `nodes`.* FROM `nodes`  WHERE `nodes`.`type` IN ('S') AND `nodes`.`path` = 'S' LIMIT N

Count: 1922  Time=0.23s (450s)  Lock=0.00s (0s)  Rows=0.0 (0), yohoushi[yohoushi]@localhost
  SELECT  `nodes`.* FROM `nodes`  WHERE `nodes`.`type` IN ('S') AND `nodes`.`path` = 'S'  ORDER BY `nodes`.`id` ASC LIMIT N

Count: 8017  Time=0.09s (749s)  Lock=0.00s (0s)  Rows=0.9 (7563), yohoushi[yohoushi]@localhost
  SELECT  id FROM `nodes`  WHERE `nodes`.`type` IN ('S') AND `nodes`.`path` = 'S'  ORDER BY `nodes`.`id` ASC LIMIT N
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment