explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6OjO

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.111 ↓ 0.0 0 1

Nested Loop (cost=0.86..23.80 rows=1 width=502) (actual time=0.111..0.111 rows=0 loops=1)

  • Join Filter: (providerli0_.provider_id = provider2_.id)
  • Rows Removed by Join Filter: 2
2. 0.002 0.048 ↓ 2.0 2 1

Nested Loop Left Join (cost=0.86..16.91 rows=1 width=502) (actual time=0.041..0.048 rows=2 loops=1)

3. 0.022 0.022 ↓ 2.0 2 1

Index Scan using idx_provider_link_user_id_provider_id on provider_link providerli0_ (cost=0.43..8.45 rows=1 width=170) (actual time=0.021..0.022 rows=2 loops=1)

  • Index Cond: (user_id = 100)
  • Filter: ((link_state)::text = ANY ('{ACTIVE,INACTIVE,REFUSED,WAITING}'::text[]))
4. 0.024 0.024 ↑ 1.0 1 2

Index Scan using activation_code_pkey on activation_code activation1_ (cost=0.43..8.45 rows=1 width=332) (actual time=0.011..0.012 rows=1 loops=2)

  • Index Cond: (providerli0_.activation_code_id = id)
5. 0.056 0.056 ↑ 1.0 1 2

Seq Scan on provider provider2_ (cost=0.00..6.88 rows=1 width=8) (actual time=0.022..0.028 rows=1 loops=2)

  • Filter: (laboratory_id = 6)
  • Rows Removed by Filter: 69