explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iBqy : Optimization for: plan #CC6A

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.040 ↓ 0.0 0 1

Nested Loop Anti Join (cost=5.17..28.19 rows=1 width=392) (actual time=0.040..0.040 rows=0 loops=1)

  • Join Filter: (dossieruse3_.document_id = document0_.id)
2. 0.000 0.040 ↓ 0.0 0 1

Nested Loop (cost=4.88..26.45 rows=1 width=392) (actual time=0.040..0.040 rows=0 loops=1)

3. 0.000 0.040 ↓ 0.0 0 1

Nested Loop (cost=4.60..25.93 rows=1 width=219) (actual time=0.040..0.040 rows=0 loops=1)

4. 0.003 0.040 ↓ 0.0 0 1

Bitmap Heap Scan on document document0_ (cost=4.33..17.63 rows=1 width=211) (actual time=0.040..0.040 rows=0 loops=1)

  • Recheck Cond: (((insertion_date)::date >= '2020-09-12'::date) AND ((insertion_date)::date <= '2020-09-12'::date))
  • Filter: ((NOT cancelled) AND (pathological_results IS NOT NULL) AND (insertion_date >= '2020-09-12 11:00:00.107'::timestamp without time zone) AND (insertion_date < '2020-09-12 17:00:00.086'::timestamp without time zone) AND ((pathological_results)::text <> 'NONE'::text) AND ((type)::text = 'CR'::text))
5. 0.037 0.037 ↓ 0.0 0 1

Bitmap Index Scan on idx_document_temporal_insertion_date (cost=0.00..4.33 rows=5 width=0) (actual time=0.037..0.037 rows=0 loops=1)

  • Index Cond: (((insertion_date)::date >= '2020-09-12'::date) AND ((insertion_date)::date <= '2020-09-12'::date))
6. 0.000 0.000 ↓ 0.0 0

Index Scan using document_receivers_pkey on document_receivers documentre1_ (cost=0.28..8.29 rows=1 width=16) (never executed)

  • Index Cond: (id = document0_.id)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using provider_link_pkey on provider_link providerli2_ (cost=0.28..0.50 rows=1 width=181) (never executed)

  • Index Cond: (id = documentre1_.provider_link_id)
  • Filter: (((link_state)::text = ANY ('{ACTIVE,INACTIVE}'::text[])) AND ((link_type)::text <> 'PATIENT'::text))
8. 0.000 0.000 ↓ 0.0 0

Index Scan using dossier_user_view_user_id on dossier_user_view dossieruse3_ (cost=0.28..0.96 rows=9 width=16) (never executed)

  • Index Cond: (user_id = providerli2_.user_id)