explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ye1y

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.260 ↑ 1.0 1 1

Aggregate (cost=2,666.93..2,666.94 rows=1 width=8) (actual time=0.260..0.260 rows=1 loops=1)

2. 0.000 0.257 ↓ 0.0 0 1

Nested Loop (cost=163.65..2,666.93 rows=1 width=8) (actual time=0.257..0.257 rows=0 loops=1)

  • Join Filter: (((providerli2_.activation_code)::text = (activation1_.activation_code)::text) AND (providerli2_.provider_id = activation1_.provider_id))
3. 0.001 0.257 ↓ 0.0 0 1

Nested Loop (cost=163.22..2,658.52 rows=1 width=43) (actual time=0.257..0.257 rows=0 loops=1)

  • Join Filter: (smsrequest0_.ac_id = providerli2_.activation_code_id)
4. 0.256 0.256 ↓ 0.0 0 1

Index Scan using idx_provider_link_user_id_provider_id on provider_link providerli2_ (cost=0.43..8.45 rows=1 width=27) (actual time=0.256..0.256 rows=0 loops=1)

  • Index Cond: (user_id = '8664'::bigint)
  • Filter: ((link_state)::text = 'ACTIVE'::text)
5. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on sms_request smsrequest0_ (cost=162.79..2,643.59 rows=519 width=16) (never executed)

  • Recheck Cond: ((type)::text = 'RESULTAT'::text)
  • Filter: ((message IS NOT NULL) AND (NOT read))
6. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_sms_request_type_read (cost=0.00..162.66 rows=6,224 width=0) (never executed)

  • Index Cond: (((type)::text = 'RESULTAT'::text) AND (read = false))
7. 0.000 0.000 ↓ 0.0 0

Index Scan using activation_code_pkey on activation_code activation1_ (cost=0.43..8.39 rows=1 width=27) (never executed)

  • Index Cond: (id = smsrequest0_.ac_id)