explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dWeM

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=)

2. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (((authentication_method)::text = 'email'::text) AND ((auth_id)::text = '053e6e1a995bb1e6166a49b1d2664ee6'::text))
3. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = "chefclub-users_authenticationmethod".user_id)
  • Filter: (NOT marked_as_deleted)