explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oTvK

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

Nested Loop Left Join (cost=8.74..16.12 rows=1 width=571) (actual time=0.038..0.038 rows=0 loops=1)

2. 0.000 0.037 ↓ 0.0 0 1

Nested Loop (cost=8.60..15.75 rows=1 width=205) (actual time=0.037..0.037 rows=0 loops=1)

3. 0.009 0.037 ↓ 0.0 0 1

Hash Semi Join (cost=8.46..15.35 rows=1 width=8) (actual time=0.037..0.037 rows=0 loops=1)

  • Hash Cond: (provider0_.id = providerli2_.provider_id)
4. 0.023 0.023 ↑ 70.0 1 1

Seq Scan on provider provider0_ (cost=0.00..6.70 rows=70 width=16) (actual time=0.023..0.023 rows=1 loops=1)

5. 0.000 0.005 ↓ 0.0 0 1

Hash (cost=8.45..8.45 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
6. 0.005 0.005 ↓ 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=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (user_id = 8664)
  • Filter: ((link_state)::text = ANY ('{ACTIVE,INACTIVE}'::text[]))
7. 0.000 0.000 ↓ 0.0 0

Index Scan using laboratory_pkey on laboratory laboratory1_ (cost=0.14..0.39 rows=1 width=205) (never executed)

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

Index Scan using laboratory_parameter_pkey on laboratory_parameter laboratory1_1_ (cost=0.14..0.36 rows=1 width=374) (never executed)

  • Index Cond: (laboratory1_.id = laboratory_id)