explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i5Uw

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

Gather (cost=9453.45..686942.71 rows=60428 width=342)Workers Planned: 2-> Hash Join (cost=8453.45..678842.41 rows=25178 width=342)Hash Cond: (e.encounter_type_id = et.encounter_type_id)-> Hash Join (cost=8452.24..677988.65 rows=25178 width=336)Hash Cond: (e.encounter_class_id = ec.encounter_class_id)-> Hash Join (cost=8451.00..677895.84 rows=25178 width=306)Hash Cond: ((scd.organization)::text = (o.org_unit_mongo_original_id)::text)-> Hash Join (cost=8059.41..677438.08 rows=25178 width=184)Hash Cond: (e.resource_to_org_unit_technical_id = scd.resource_to_org_unit_technical_id)-> Nested Loop (cost=96.69..669409.27 rows=25178 width=149)-> Hash Join (cost=96.26..488455.28 rows=36615 width=64)Hash Cond: (e.created_dsk = d.date_small_key)-> Parallel Seq Scan on event_encounter e (cost=0.00..480186.89 rows=3111489 width=66)-> Hash (cost=95.12..95.12 rows=91 width=2)-> Index Scan using idx_dim_date_full_date on dim_date d (cost=0.28..95.12 rows=91 width=2)Index Cond: ((full_date >= '2020-05-01'::date) AND (full_date <= '2020-07-31'::date))-> Index Scan using uidx_pstg_encounters_synchronization_id on pstg_encounters_synchronization es (cost=0.43..4.94 rows=1 width=101)Index Cond: (id = e.encounter_id)-> Hash (cost=5812.32..5812.32 rows=172032 width=43)-> Seq Scan on his_resource_to_org_unit_scd scd (cost=0.00..5812.32 rows=172032 width=43)-> Hash (cost=351.26..351.26 rows=3226 width=193)-> Seq Scan on dm_organization o (cost=0.00..351.26 rows=3226 width=193)-> Hash (cost=1.11..1.11 rows=11 width=34)-> Seq Scan on dict_encounter_class ec (cost=0.00..1.11 rows=11 width=34)-> Hash (cost=1.09..1.09 rows=9 width=34)-> Seq Scan on dict_encounter_type et (cost=0.00..1.09 rows=9 width=34) (actual rows= loops=)