explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nB9e : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #EnRL; plan #HHM9; plan #FxYF; plan #AU47; plan #SQBN

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.062 0.080 ↓ 0.0 0 1

Sort (cost=70.30..70.31 rows=3 width=15) (actual time=0.080..0.080 rows=0 loops=1)

  • Sort Key: user0_.state
  • Sort Method: quicksort Memory: 25kB
2. 0.000 0.018 ↓ 0.0 0 1

HashAggregate (cost=70.25..70.28 rows=3 width=15) (actual time=0.018..0.018 rows=0 loops=1)

  • Group Key: user0_.state
3. 0.000 0.018 ↓ 0.0 0 1

Nested Loop Semi Join (cost=57.81..70.20 rows=10 width=15) (actual time=0.018..0.018 rows=0 loops=1)

4. 0.000 0.018 ↓ 0.0 0 1

Nested Loop (cost=57.40..63.38 rows=10 width=23) (actual time=0.018..0.018 rows=0 loops=1)

5. 0.001 0.018 ↓ 0.0 0 1

HashAggregate (cost=57.12..57.22 rows=10 width=8) (actual time=0.018..0.018 rows=0 loops=1)

  • Group Key: providerli1_.user_id
6. 0.000 0.017 ↓ 0.0 0 1

Nested Loop (cost=4.63..57.09 rows=10 width=8) (actual time=0.017..0.017 rows=0 loops=1)

7. 0.017 0.017 ↓ 0.0 0 1

Index Scan using provider_laboratory_id on provider provider2_ (cost=0.14..8.16 rows=1 width=8) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (laboratory_id = 6)
8. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on provider_link providerli1_ (cost=4.49..48.67 rows=26 width=16) (never executed)

  • Recheck Cond: (provider_id = provider2_.id)
  • Filter: ((link_state)::text = ANY ('{ACTIVE,INACTIVE}'::text[]))
9. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_provider_link_provider_id_ac (cost=0.00..4.48 rows=27 width=0) (never executed)

  • Index Cond: (provider_id = provider2_.id)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using bwuser_pkey on bwuser user0_ (cost=0.28..0.61 rows=1 width=15) (never executed)

  • Index Cond: (id = providerli1_.user_id)
11. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.41..0.71 rows=1 width=8) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_user_profile_user_id on user_profile userprofil3_ (cost=0.28..0.38 rows=2 width=16) (never executed)

  • Index Cond: (user_id = providerli1_.user_id)
13. 0.000 0.000 ↓ 0.0 0

Index Scan using profile_pkey on profile profile4_ (cost=0.13..0.16 rows=1 width=8) (never executed)

  • Index Cond: (id = userprofil3_.profile_id)
  • Filter: ((code)::text <> ALL ('{ADMINISTRATEUR_LABOCONNECT,ADMINISTRATEUR_LABO}'::text[]))