Advertisement
Guest User

Untitled

a guest
Sep 11th, 2017
739
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. [5] pry(main)> User.where(email: 'mpokress@gmail.com').explain
  2. User Load (25.9ms) SELECT "users".* FROM "users" WHERE "users"."email" = $1 [["email", "mpokress@gmail.com"]]
  3. => EXPLAIN for: SELECT "users".* FROM "users" WHERE "users"."email" = $1 [["email", "mpokress@gmail.com"]]
  4. QUERY PLAN
  5. -------------------------------------------------------------------------------------
  6. Index Scan using index_users_on_email on users (cost=0.42..8.44 rows=1 width=2198)
  7. Index Cond: (email = 'mpokress@gmail.com'::text)
  8. (2 rows)
  9.  
  10. [6] pry(main)> User.where(email: 'mpokress@gmail.com').select(:email).explain
  11. User Load (31.1ms) SELECT "users"."email" FROM "users" WHERE "users"."email" = $1 [["email", "mpokress@gmail.com"]]
  12. => EXPLAIN for: SELECT "users"."email" FROM "users" WHERE "users"."email" = $1 [["email", "mpokress@gmail.com"]]
  13. QUERY PLAN
  14. ----------------------------------------------------------------------------------------
  15. Index Only Scan using index_users_on_email on users (cost=0.42..8.44 rows=1 width=23)
  16. Index Cond: (email = 'mpokress@gmail.com'::text)
  17. (2 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement