explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9xfC

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 202.176 ↓ 0.0 0 1

Limit (cost=0.42..83,898.97 rows=1 width=1,273) (actual time=202.176..202.176 rows=0 loops=1)

2. 0.000 202.174 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.42..83,898.97 rows=1 width=1,273) (actual time=202.174..202.174 rows=0 loops=1)

3. 202.174 202.174 ↓ 0.0 0 1

Seq Scan on customers customer (cost=0.00..83,890.52 rows=1 width=1,057) (actual time=202.174..202.174 rows=0 loops=1)

  • Filter: (("deletedAt" IS NULL) AND (("phoneVerificationToken")::text = '291920'::text))
  • Rows Removed by Filter: 1238063
4. 0.000 0.000 ↓ 0.0 0

Index Scan using users_pkey on users "user" (cost=0.42..8.44 rows=1 width=216) (never executed)

  • Index Cond: (customer."userId" = id)