explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3k3t

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 25.458 ↑ 1.5 4 1

Nested Loop Left Join (cost=4.39..5,870.24 rows=6 width=837) (actual time=0.099..25.458 rows=4 loops=1)

  • Output: basicequip0_.basicequipment_id, basicequip0_.creation_timestamp, basicequip0_.creation_user, basicequip0_.modification_timestamp, basicequip0_.modification_user, basicequip0_.accepted_careservicecode, basicequip0_.btc_equivalent_careservicecode, basicequip0_.cancel_comment, basicequip0_.cancel_date, basicequip0_.cancel_reason, basicequip0_.end_comment, basicequip0_.end_date, basicequip0_.end_reason, basicequip0_.application_id, basicequip0_.original_careservicecode, basicequip0_.status, basicequip0_.status_date, mohmapplic1_.vsb_reference, mohmapplic1_.creation_timestamp, mohmapplic1_.creation_user, mohmapplic1_.modification_timestamp, mohmapplic1_.modification_user, mohmapplic1_.application_type,
  • mohmapplic1_.appointed_to_care_unit_employee, mohmapplic1_.assigned_zkc, mohmapplic1_.btc, mohmapplic1_.cancel_comment, mohmapplic1_.cancel_reason, mohmapplic1_.care_unit, mohmapplic1_.careprovider_reference, mohmapplic1_.dossier_id, mohmapplic1_.end_comment, mohmapplic1_.end_date, mohmapplic1_.end_reason, mohmapplic1_.max_delivery_date, mohmapplic1_.procedure, mohmapplic1_.provider_approval_number, mohmapplic1_.province, mohmapplic1_.received_date, mohmapplic1_.sda_calculated, mohmapplic1_.zip_code, mohmapplic1_.zkc, applicatio2_.vsb_reference, applicatio2_.application_status_id, applicatio2_.application_status_id, applicatio2_.creation_timestamp, applicatio2_.creation_user, applicatio2_.modification_timestamp, applicatio2_.modification_user, applicatio2_.is_current_status, applicatio2_.vsb_reference, applicatio2_.status, applicatio2_.status_date
  • Join Filter: ((mohmapplic1_.vsb_reference)::text = (applicatio2_.vsb_reference)::text)
  • Buffers: shared hit=1743
  • mohmapplic1_.zkc, mohmapplic1_.btc, mohmapplic1_.max_delivery_date, mohmapplic1_.creation_timestamp, mohmapplic1_.creation_user, mohmapplic1_.modification_timestamp, mohmapplic1_.modification_user, mohmapplic1_.care_unit, mohmapplic1_.assigned_zkc, mohmapplic1_.cancel_reason, mohmapplic1_.cancel_comment, mohmapplic1_.end_reason, mohmapplic1_.end_comment, mohmapplic1_.end_date, mohmapplic1_.zip_code, mohmapplic1_.province, mohmapplic1_.procedure, mohmapplic1_.appointed_to_care_unit_employee
2. 0.008 25.412 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.42..5,845.26 rows=1 width=754) (actual time=0.056..25.412 rows=1 loops=1)

  • Output: basicequip0_.basicequipment_id, basicequip0_.creation_timestamp, basicequip0_.creation_user, basicequip0_.modification_timestamp, basicequip0_.modification_user, basicequip0_.accepted_careservicecode, basicequip0_.btc_equivalent_careservicecode, basicequip0_.cancel_comment, basicequip0_.cancel_date, basicequip0_.cancel_reason, basicequip0_.end_comment, basicequip0_.end_date, basicequip0_.end_reason, basicequip0_.application_id, basicequip0_.original_careservicecode, basicequip0_.status, basicequip0_.status_date, mohmapplic1_.vsb_reference, mohmapplic1_.creation_timestamp, mohmapplic1_.creation_user, mohmapplic1_.modification_timestamp, mohmapplic1_.modification_user, mohmapplic1_.application_type, mohmapplic1_.appointed_to_care_unit_employee, mohmapplic1_.assigned_zkc, mohmapplic1_.btc, mohmapplic1_.cancel_comment, mohmapplic1_.cancel_reason, mohmapplic1_.care_unit, mohmapplic1_.careprovider_reference, mohmapplic1_.dossier_id, mohmapplic1_.end_comment, mohmapplic1_.end_date, mohmapplic1_.end_reason, mohmapplic1_.max_delivery_date, mohmapplic1_.procedure, mohmapplic1_.provider_approval_number, mohmapplic1_.province, mohmapplic1_.received_date, mohmapplic1_.sda_calculated, mohmapplic1_.zip_code, mohmapplic1_.zkc
  • Join Filter: ((basicequip0_.application_id)::text = (mohmapplic1_.vsb_reference)::text)
  • Buffers: shared hit=1739
3. 25.367 25.367 ↑ 1.0 1 1

Seq Scan on schema_emohm_adm.basic_equipment basicequip0_ (cost=0.00..5,837.77 rows=1 width=250) (actual time=0.013..25.367 rows=1 loops=1)

  • Output: basicequip0_.basicequipment_id, basicequip0_.application_id, basicequip0_.original_careservicecode, basicequip0_.accepted_careservicecode, basicequip0_.creation_timestamp, basicequip0_.creation_user, basicequip0_.modification_timestamp, basicequip0_.modification_user, basicequip0_.cancel_reason, basicequip0_.cancel_comment, basicequip0_.end_reason, basicequip0_.end_comment, basicequip0_.end_date, basicequip0_.btc_equivalent_careservicecode, basicequip0_.status, basicequip0_.status_date, basicequip0_.cancel_date
  • Filter: ((basicequip0_.application_id)::text = 'b3160bb3'::text)
  • Rows Removed by Filter: 126453
  • Buffers: shared hit=1735
4. 0.037 0.037 ↑ 1.0 1 1

Index Scan using application_pkey on schema_emohm_adm.application mohmapplic1_ (cost=0.42..7.46 rows=1 width=504) (actual time=0.036..0.037 rows=1 loops=1)

  • Output: mohmapplic1_.vsb_reference, mohmapplic1_.received_date, mohmapplic1_.careprovider_reference, mohmapplic1_.application_type, mohmapplic1_.dossier_id, mohmapplic1_.provider_approval_number, mohmapplic1_.sda_calculated,
  • Index Cond: ((mohmapplic1_.vsb_reference)::text = 'b3160bb3'::text)
  • Buffers: shared hit=4
5. 0.010 0.038 ↑ 1.5 4 1

Bitmap Heap Scan on schema_emohm_adm.application_status applicatio2_ (cost=3.97..24.79 rows=6 width=68) (actual time=0.038..0.038 rows=4 loops=1)

  • Output: applicatio2_.application_status_id, applicatio2_.vsb_reference, applicatio2_.status, applicatio2_.status_date, applicatio2_.is_current_status, applicatio2_.creation_timestamp, applicatio2_.creation_user, applicatio2_.modification_timestamp, applicatio2_.modification_user
  • Recheck Cond: ((applicatio2_.vsb_reference)::text = 'b3160bb3'::text)
  • Heap Blocks: exact=1
  • Buffers: shared hit=4
6. 0.028 0.028 ↑ 1.5 4 1

Bitmap Index Scan on application_status_vsb_reference_index (cost=0.00..3.97 rows=6 width=0) (actual time=0.028..0.028 rows=4 loops=1)

  • Index Cond: ((applicatio2_.vsb_reference)::text = 'b3160bb3'::text)
  • Buffers: shared hit=3
Planning time : 21.808 ms
Execution time : 25.623 ms