Skip to content

Instantly share code, notes, and snippets.

@jchen123

jchen123/gist:5696312

Last active December 18, 2015 00:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jchen123/5696312 to your computer and use it in GitHub Desktop.
Save jchen123/5696312 to your computer and use it in GitHub Desktop.
Download ZIP
explain analyze example
Raw
gistfile1.txt
EXPLAIN ANALYZE SELECT
photos.id, album_photos.album_id, connected_users.email_address
FROM photos JOIN album_photos ON album_photos.photo_id = photos.id
JOIN albums ON album_photos.album_id = albums.id
LEFT OUTER JOIN connected_users ON photos.connected_user_id = connected_users.id
WHERE album_photos.album_id = 1060
AND photos.dead is not true
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment