explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1G3q

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 201.555 ↓ 0.0 0 1

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

2. 0.001 201.554 ↓ 0.0 0 1

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

3. 201.553 201.553 ↓ 0.0 0 1

Seq Scan on customers customer (cost=0.00..83,890.52 rows=1 width=1,057) (actual time=201.553..201.553 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)