explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QMhB : Optimization for: Optimization for: plan #LvZ; plan #vJmR

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 0.048 ↓ 0.0 0 1

Bitmap Heap Scan on patient_clinical_elements (cost=47.27..51.29 rows=1 width=8) (actual time=0.048..0.048 rows=0 loops=1)

  • Recheck Cond: ((patient_clinical_elements_encounterid = 43) AND (patient_clinical_elements_patientid = 2822))
  • Filter: ((patient_clinical_elements_gwid)::text ~~* '00001003%'::text)
2. 0.000 0.046 ↓ 0.0 0 1

BitmapAnd (cost=47.27..47.27 rows=1 width=0) (actual time=0.046..0.046 rows=0 loops=1)

3. 0.046 0.046 ↓ 0.0 0 1

Bitmap Index Scan on patient_clinical_elements_encounterid_index (cost=0.00..6.48 rows=273 width=0) (actual time=0.046..0.046 rows=0 loops=1)

  • Index Cond: (patient_clinical_elements_encounterid = 43)
4. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on patient_clinical_elements_patientid_index (cost=0.00..40.54 rows=2,147 width=0) (never executed)

  • Index Cond: (patient_clinical_elements_patientid = 2822)
Planning time : 0.641 ms
Execution time : 0.109 ms