explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 45u9

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

Unique (cost=16.21..16.31 rows=1 width=571) (actual time=0.138..0.138 rows=0 loops=1)

2. 0.105 0.137 ↓ 0.0 0 1

Sort (cost=16.21..16.21 rows=1 width=571) (actual time=0.137..0.137 rows=0 loops=1)

  • Sort Key: laboratory2_.id, laboratory2_.address1, laboratory2_.address2, laboratory2_.user_id, laboratory2_.authorized_ip, laboratory2_.city, laboratory2_.countrycode, laboratory2_.customer_code, laboratory2_.date_begin_contract, laboratory2_.doctolib_link, laboratory2_.email, laboratory2_.finess_number, laboratory2_.name, laboratory2_.parentid, laboratory2_.postalcode, laboratory2_.sitedetailsid, laboratory2_.url, laboratory2_1_.activate_survey, laboratory2_1_.activate_survey_email, laboratory2_1_.age_max, laboratory2_1_.age_max_email, laboratory2_1_.age_min, laboratory2_1_.age_min_email, laboratory2_1_.date_end_survey, laboratory2_1_.date_end_survey_email, laboratory2_1_.days_after_closed, laboratory2_1_.days_after_consultation, laboratory2_1_.folder_created_since, laboratory2_1_.for_doctor, laboratory2_1_.for_doctor_email, laboratory2_1_.for_paramedic, laboratory2_1_.for_patient, laboratory2_1_.for_patient_email, laboratory2_1_.for_trans, laboratory2_1_.for_trans_email, laboratory2_1_.message, laboratory2_1_.message_email, laboratory2_1_.survey_link, laboratory2_1_.survey_link_email
  • Sort Method: quicksort Memory: 25kB
3. 0.000 0.032 ↓ 0.0 0 1

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

4. 0.001 0.032 ↓ 0.0 0 1

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

5. 0.005 0.031 ↓ 0.0 0 1

Hash Join (cost=8.46..15.43 rows=1 width=8) (actual time=0.031..0.031 rows=0 loops=1)

  • Hash Cond: (provider1_.id = providerli0_.provider_id)
6. 0.010 0.010 ↑ 70.0 1 1

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

7. 0.000 0.016 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
8. 0.016 0.016 ↓ 0.0 0 1

Index Scan using idx_provider_link_user_id_provider_id on provider_link providerli0_ (cost=0.43..8.45 rows=1 width=8) (actual time=0.016..0.016 rows=0 loops=1)

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

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

  • Index Cond: (id = provider1_.laboratory_id)
10. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (laboratory2_.id = laboratory_id)