explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R5iC

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 1.544 ↑ 1.0 1 1

Limit (cost=1.99..1,088.72 rows=1 width=4) (actual time=1.540..1.544 rows=1 loops=1)

  • Output: cal.id
  • Buffers: shared hit=300
2. 0.015 1.539 ↑ 34.0 1 1

Nested Loop (cost=1.99..36,950.75 rows=34 width=4) (actual time=1.538..1.539 rows=1 loops=1)

  • Output: cal.id
  • Join Filter: (cal.station_id = mc.id)
  • Rows Removed by Join Filter: 73
  • Buffers: shared hit=300
3. 0.010 1.301 ↑ 34.0 1 1

Nested Loop (cost=1.99..36,900.52 rows=34 width=16) (actual time=1.301..1.301 rows=1 loops=1)

  • Output: cal.id, cal.station_id, po.id, ppa.party_id
  • Join Filter: (po.id = cal.station_id)
  • Rows Removed by Join Filter: 26
  • Buffers: shared hit=291
4. 0.018 0.018 ↑ 555,655.0 1 1

Index Scan using md_ambulance_call_pkey on amb.md_ambulance_call cal (cost=0.42..28,062.12 rows=555,655 width=8) (actual time=0.018..0.018 rows=1 loops=1)

  • Output: cal.id, cal.call_number, cal.call_place_id, cal.call_type_id, cal.priority_id, cal.from_time, cal.to_time, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.phone_caller, cal.caller_note, cal.registrator_id, cal.call_kind_id, cal.reason_note, cal.caller_reason_id, cal.call_place_note, cal.place_org_id, cal.caller_id, cal.place_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.patient_id, cal.is_group_sufferer, cal.sum_sufferer, cal.station_id, cal.reason_diag, cal.is_chronic, cal.employee_id, cal.priority, cal.route_id, cal.call_dt, cal.brg_id, cal.note, cal.substation_id, cal.to_org_id, cal.to_department_id, cal.control, cal.emp_id, cal.age_years, cal.age_months, cal.age_days, cal.call_mark, cal.aud_who, cal.aud_when, cal.aud_source, cal.aud_who_create, cal.aud_when_create, cal.aud_source_create, cal.desk_id
  • Buffers: shared hit=4
5. 0.014 1.273 ↓ 27.0 27 1

Materialize (cost=1.57..503.57 rows=1 width=8) (actual time=0.201..1.273 rows=27 loops=1)

  • Output: po.id, ppa.party_id
  • Buffers: shared hit=287
6. 0.008 1.259 ↓ 27.0 27 1

Nested Loop (cost=1.57..503.57 rows=1 width=8) (actual time=0.199..1.259 rows=27 loops=1)

  • Output: po.id, ppa.party_id
  • Buffers: shared hit=287
7. 0.023 0.873 ↓ 27.0 27 1

Nested Loop (cost=1.14..503.07 rows=1 width=12) (actual time=0.112..0.873 rows=27 loops=1)

  • Output: po.id, ppa.party_id, ppa.addr_id
  • Buffers: shared hit=195
8. 0.008 0.715 ↑ 1.6 27 1

Nested Loop (cost=0.85..489.51 rows=43 width=8) (actual time=0.106..0.715 rows=27 loops=1)

  • Output: ppa.party_id, ppa.addr_id
  • Buffers: shared hit=138
9. 0.302 0.302 ↑ 1.6 27 1

Index Scan using pim_party_addr_to_addr_type_address_type_id_idx on public.pim_party_addr_to_addr_type ppatat (cost=0.43..126.05 rows=43 width=4) (actual time=0.097..0.302 rows=27 loops=1)

  • Output: ppatat.id, ppatat.address_type_id, ppatat.party_address_id, ppatat.aud_who, ppatat.aud_when, ppatat.aud_source, ppatat.aud_who_create, ppatat.aud_when_create, ppatat.aud_source_create
  • Index Cond: (ppatat.address_type_id = 6)
  • Buffers: shared hit=30
10. 0.405 0.405 ↑ 1.0 1 27

Index Scan using pim_party_address_pk on public.pim_party_address ppa (cost=0.42..8.44 rows=1 width=12) (actual time=0.014..0.015 rows=1 loops=27)

  • Output: ppa.id, ppa.from_date, ppa.note, ppa.text_addr, ppa.to_date, ppa.is_valid, ppa.addr_id, ppa.party_id, ppa.register_type_id, ppa.aud_who, ppa.aud_when, ppa.aud_source, ppa.aud_who_create, ppa.aud_when_create, ppa.aud_source_create
  • Index Cond: (ppa.id = ppatat.party_address_id)
  • Buffers: shared hit=108
11. 0.135 0.135 ↑ 1.0 1 27

Index Only Scan using pim_organization_pk on public.pim_organization po (cost=0.29..0.31 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=27)

  • Output: po.id
  • Index Cond: (po.id = ppa.party_id)
  • Heap Fetches: 2
  • Buffers: shared hit=57
12. 0.378 0.378 ↑ 1.0 1 27

Index Only Scan using address_element_data_pkey on public.address_element_data stael (cost=0.43..0.49 rows=1 width=4) (actual time=0.013..0.014 rows=1 loops=27)

  • Output: stael.id
  • Index Cond: (stael.id = ppa.addr_id)
  • Heap Fetches: 0
  • Buffers: shared hit=92
13. 0.025 0.223 ↑ 1.0 74 1

Materialize (cost=0.00..11.15 rows=77 width=4) (actual time=0.013..0.223 rows=74 loops=1)

  • Output: mc.id
  • Buffers: shared hit=9
14. 0.198 0.198 ↑ 1.0 74 1

Seq Scan on public.md_clinic mc (cost=0.00..10.77 rows=77 width=4) (actual time=0.011..0.198 rows=74 loops=1)

  • Output: mc.id
  • Buffers: shared hit=9
Planning time : 4.491 ms
Execution time : 1.643 ms