explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I2E8

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.351 ↓ 1.1 12 1

Nested Loop Left Join (cost=61.10..81.24 rows=11 width=5,533) (actual time=0.255..0.351 rows=12 loops=1)

2. 0.003 0.312 ↓ 1.1 12 1

Nested Loop (cost=60.96..79.16 rows=11 width=3,621) (actual time=0.249..0.312 rows=12 loops=1)

3. 0.014 0.249 ↓ 1.1 12 1

Hash Right Join (cost=60.69..75.15 rows=11 width=2,328) (actual time=0.241..0.249 rows=12 loops=1)

  • Hash Cond: ((ifre.medical_case_id)::text = (imc.id)::text)
  • Join Filter: ((mc.status)::text = 'ACTIVE'::text)
4. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on inpat_fin_rep_errors ifre (cost=0.00..13.20 rows=320 width=220) (actual time=0.000..0.000 rows=0 loops=1)

5. 0.013 0.235 ↓ 1.1 12 1

Hash (cost=60.55..60.55 rows=11 width=2,108) (actual time=0.235..0.235 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
6. 0.008 0.222 ↓ 1.1 12 1

Nested Loop (cost=1.93..60.55 rows=11 width=2,108) (actual time=0.040..0.222 rows=12 loops=1)

7. 0.007 0.109 ↑ 2.1 15 1

Nested Loop (cost=1.66..32.08 rows=32 width=1,444) (actual time=0.030..0.109 rows=15 loops=1)

8. 0.011 0.027 ↑ 2.1 15 1

Hash Join (cost=1.38..16.93 rows=32 width=1,007) (actual time=0.019..0.027 rows=15 loops=1)

  • Hash Cond: ((dml.diet_assignment_id)::text = (da.id)::text)
9. 0.004 0.004 ↑ 25.3 15 1

Seq Scan on dias_meca_link dml (cost=0.00..13.80 rows=380 width=180) (actual time=0.002..0.004 rows=15 loops=1)

10. 0.008 0.012 ↑ 1.0 17 1

Hash (cost=1.17..1.17 rows=17 width=827) (actual time=0.012..0.012 rows=17 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
11. 0.004 0.004 ↑ 1.0 17 1

Seq Scan on diet_assignments da (cost=0.00..1.17 rows=17 width=827) (actual time=0.002..0.004 rows=17 loops=1)

12. 0.075 0.075 ↑ 1.0 1 15

Index Scan using in_patient_medical_cases_pkey on inpatient_medical_cases imc (cost=0.28..0.46 rows=1 width=437) (actual time=0.005..0.005 rows=1 loops=15)

  • Index Cond: ((id)::text = (dml.medical_case_id)::text)
13. 0.105 0.105 ↑ 1.0 1 15

Index Scan using medical_cases_pk on medical_cases mc (cost=0.28..0.88 rows=1 width=664) (actual time=0.007..0.007 rows=1 loops=15)

  • Index Cond: ((id)::text = (imc.id)::text)
  • Filter: (((NOT deleted) AND ((status)::text = ANY ('{ACTIVE,DISCHARGED}'::text[]))) OR (((status)::text = 'CLOSED'::text) AND (close_date >= '2019-01-04 00:00:00'::timestamp without time zone) AND (close_date <= '2019-01-05 00:00:00'::timestamp without time zone)))
  • Rows Removed by Filter: 0
14. 0.060 0.060 ↑ 1.0 1 12

Index Scan using medical_units_pkey on medical_units mu (cost=0.27..0.35 rows=1 width=1,293) (actual time=0.005..0.005 rows=1 loops=12)

  • Index Cond: ((id)::text = (mc.attendant_organization_id)::text)
15. 0.036 0.036 ↑ 1.0 1 12

Index Scan using employees_pkey on employees emp (cost=0.14..0.18 rows=1 width=1,912) (actual time=0.003..0.003 rows=1 loops=12)

  • Index Cond: ((mc.attendant_employee_id)::text = (id)::text)