explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P7p4

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

Nested Loop Anti Join (cost=1.00..1,078.25 rows=1 width=89) (actual time=3.015..3.015 rows=0 loops=1)

2. 0.153 3.015 ↓ 0.0 0 1

Nested Loop (cost=0.85..1,078.07 rows=1 width=93) (actual time=3.015..3.015 rows=0 loops=1)

3. 0.590 0.590 ↓ 1.1 284 1

Index Scan using tmp_index_for_email_unconfirmation_migration on emails (cost=0.42..184.95 rows=258 width=89) (actual time=0.029..0.590 rows=284 loops=1)

  • Index Cond: ((id >= 425,000) AND (id <= 426,000))
4. 2.272 2.272 ↓ 0.0 0 284

Index Scan using users_pkey on users (cost=0.43..3.45 rows=1 width=35) (actual time=0.008..0.008 rows=0 loops=284)

  • Index Cond: (id = emails.user_id)
  • Filter: ((user_type IS NULL) AND ((state)::text = 'active'::text) AND ((emails.email)::text <> (email)::text) AND (emails.confirmed_at = confirmed_at))
  • Rows Removed by Filter: 1
5. 0.000 0.000 ↓ 0.0 0

Index Scan using index_user_synced_attributes_metadata_on_user_id on user_synced_attributes_metadata (cost=0.15..0.17 rows=1 width=4) (never executed)

  • Index Cond: (user_id = users.id)
  • Filter: (email_synced IS TRUE)
Planning time : 0.992 ms
Execution time : 3.115 ms