explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vTH8

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..16.89 rows=1 width=4) (actual rows= loops=)

  • Output: "chefclub-users_authenticationmethod".id
  • Inner Unique: true
  • Output: "chefclub-users_authenticationmethod".id
  • Inner Unique: true
  • Execution time: 0.032 mss=1 width=12)
2. 0.016 0.016 ↑ 1.0 1 1

Index Scan using "chefclub-users_authentic_authentication_method_au_769983bf_uniq" on public."chefclub-users_authenticationmethod" (cost=0.42..8.45 row Nested Loop (cost=0.85..16.89 rows=1 width=4) (actual time=0.016..0.016 rows=1 loops=1)

3. 0.011 0.011 ↑ 1.0 1 1

Index Scan using "chefclub-users_authentic_authentication_method_au_769983bf_uniq" on public."chefclub-users_authenticationmethod" (cost=0.42..8.45 rows=1 width=12) (actual time=0.010..0.011 rows=1 loops=1)

  • Output: "chefclub-users_authenticationmethod".id, "chefclub-users_authenticationmethod".created, "chefclub-users_authenticationmethod".modified, "chefclub-users_authenticationmethod".authentication_method, "chefclub-users_authenticationmethod".auth_id, "chefclub-users_authenticationmethod".email, "chefclub-users_authenticationmethod".email_validated, "chefclub-users_authenticationmethod".password, "chefclub-users_authenticationmethod".phone_number, "chefclub-users_authenticationmethod".user_id
  • Index Cond: ((("chefclub-users_authenticationmethod".authentication_method)::text = 'email'::text) AND (("chefclub-users_authenticationmethod".auth_id)::text = '053e6e1a995bb1e6166a49b1d2664ee6'::text))
4. 0.004 0.004 ↑ 1.0 1 1

Index Scan using "chefclub-users_user_pkey" on public."chefclub-users_user" (cost=0.42..8.44 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=1)

  • Output: "chefclub-users_user".created, "chefclub-users_user".modified, "chefclub-users_user".id, "chefclub-users_user".profile_pic, "chefclub-users_user".gender, "chefclub-users_user".first_name, "chefclub-users_user".last_name, "chefclub-users_user".email, "chefclub-users_user".phone_number, "chefclub-users_user".locale, "chefclub-users_user".user_id, "chefclub-users_user".settings, "chefclub-users_user".feature_flags, "chefclub-users_user".profile_picture, "chefclub-users_user".marked_as_deleted, "chefclub-users_user".django_user_id, "chefclub-users_user".is_optin_newsletter, "chefclub-users_user".is_optin_newsletter_confirmed, "chefclub-users_user".is_premium_bypass
  • Index Cond: ("chefclub-users_user".id = "chefclub-users_authenticationmethod".user_id)
  • Filter: (NOT "chefclub-users_user".marked_as_deleted)
  • Output: "chefclub-users_authenticationmethod".id, "chefclub-users_authenticationmethod".created, "chefclub-users_authenticationmethod".modified, "chefclub-users_authenticationmethod".authentication_method, "chefclub-users_authenticationmethod".auth_id, "chefclub-users_authenticationmethod".email, "chefclub-users_authenticationmethod".email_validated, "chefclub-users_authenticationmethod".password, "chefclub-users_authenticationmethod".phone_number, "chefclub-users_authenticationmethod".user_id
  • Index Cond: ((("chefclub-users_authenticationmethod".authentication_method)::text = 'email'::text) AND (("chefclub-users_authenticationmethod".auth_id)::text = '053e6e1a995bb1e6166a49b1d2664ee6'::text))
5. 0.000 0.000 ↓ 0.0

Index Scan using "chefclub-users_user_pkey" on public."chefclub-users_user" (cost=0.42..8.44 rows=1 width=12) (actual rows= loops=)

  • Output: "chefclub-users_user".created, "chefclub-users_user".modified, "chefclub-users_user".id, "chefclub-users_user".profile_pic, "chefclub-users_user".gender, "chefclub-users_user".first_name, "chefclub-users_user".last_name, "chefclub-users_user".email, "chefclub-users_user".phone_number, "chefclub-users_user".locale, "chefclub-users_user".user_id, "chefclub-users_user".settings, "chefclub-users_user".feature_flags, "chefclub-users_user".profile_picture, "chefclub-users_user".marked_as_deleted, "chefclub-users_user".django_user_id, "chefclub-users_user".is_optin_newsletter, "chefclub-users_user".is_optin_newsletter_confirmed, "chefclub-users_user".is_premium_bypass
  • Index Cond: ("chefclub-users_user".id = "chefclub-users_authenticationmethod".user_id)
  • Filter: (NOT "chefclub-users_user".marked_as_deleted)
Planning time : 0.198 ms