explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

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

Nested Loop Anti Join (cost=20.90..82.67 rows=2 width=415) (actual time=0.013..0.013 rows=0 loops=1)

2. 0.000 0.012 ↓ 0.0 0 1

Nested Loop (cost=8.59..22.29 rows=2 width=423) (actual time=0.012..0.012 rows=0 loops=1)

3. 0.002 0.012 ↓ 0.0 0 1

Bitmap Heap Scan on dossier dossier0_ (cost=4.30..12.79 rows=1 width=415) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: (provider = 64)
  • Filter: ((NOT for_delete) AND (((modificationdate IS NULL) AND ((insertion_date)::date < '2020-06-08'::date)) OR ((modificationdate IS NOT NULL) AND ((modificationdate)::date < '2020-06-08'::date))))
4. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on idx_dossier_provider_id (cost=0.00..4.29 rows=3 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (provider = 64)
5. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on dossier_receivers dossierrec1_ (cost=4.29..9.49 rows=2 width=16) (never executed)

  • Recheck Cond: (id = dossier0_.id)
6. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on dossier_receivers_pkey (cost=0.00..4.29 rows=2 width=0) (never executed)

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

Bitmap Heap Scan on activation_code activation2_ (cost=12.32..24.23 rows=1 width=8) (never executed)

  • Recheck Cond: ((id = dossier0_.activation_code_patient_id) OR (id = dossier0_.activation_code_prescriber_id) OR (id = dossierrec1_.activation_code_id))
  • Filter: ((state)::text = 'UNSUBSCRIBE'::text)
8. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=12.32..12.32 rows=3 width=0) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on activation_code_pkey (cost=0.00..4.43 rows=1 width=0) (never executed)

  • Index Cond: (id = dossier0_.activation_code_patient_id)
10. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on activation_code_pkey (cost=0.00..4.43 rows=1 width=0) (never executed)

  • Index Cond: (id = dossier0_.activation_code_prescriber_id)
11. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on activation_code_pkey (cost=0.00..3.46 rows=1 width=0) (never executed)

  • Index Cond: (id = dossierrec1_.activation_code_id)