explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DGO2

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 127.265 ↓ 0.0 0 1

Nested Loop Left Join (cost=2,678,991.74..2,746,242.62 rows=207 width=581) (actual time=127.265..127.265 rows=0 loops=1)

2. 0.000 127.264 ↓ 0.0 0 1

Merge Left Join (cost=2,678,991.46..2,746,158.11 rows=207 width=633) (actual time=127.264..127.264 rows=0 loops=1)

  • Merge Cond: ((b.bill_no)::text = (all_insurance_remittance_details_view.bill_no)::text)
3. 0.001 127.264 ↓ 0.0 0 1

Merge Left Join (cost=612,655.34..662,300.89 rows=207 width=511) (actual time=127.264..127.264 rows=0 loops=1)

  • Merge Cond: ((b.bill_no)::text = (bcl.bill_no)::text)
4. 0.000 127.263 ↓ 0.0 0 1

Sort (cost=44,225.23..44,225.75 rows=207 width=483) (actual time=127.263..127.263 rows=0 loops=1)

  • Sort Key: b.bill_no
  • Sort Method: quicksort Memory: 25kB
5. 16.438 129.659 ↓ 0.0 0 1

Gather (cost=42,511.27..44,217.27 rows=207 width=483) (actual time=127.258..129.659 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 0.001 113.221 ↓ 0.0 0 3 / 3

Hash Left Join (cost=41,511.27..43,196.57 rows=86 width=483) (actual time=113.221..113.221 rows=0 loops=3)

  • Hash Cond: ((icl.claim_id)::text = (insurance_claim_resubmission.claim_id)::text)
7. 0.001 113.220 ↓ 0.0 0 3 / 3

Nested Loop Left Join (cost=39,399.16..41,084.24 rows=86 width=465) (actual time=113.220..113.220 rows=0 loops=3)

8. 0.000 113.219 ↓ 0.0 0 3 / 3

Nested Loop Left Join (cost=39,398.88..41,057.80 rows=86 width=466) (actual time=113.219..113.219 rows=0 loops=3)

9. 0.001 113.219 ↓ 0.0 0 3 / 3

Nested Loop Left Join (cost=39,398.45..41,012.00 rows=86 width=457) (actual time=113.218..113.219 rows=0 loops=3)

10. 0.000 113.218 ↓ 0.0 0 3 / 3

Hash Left Join (cost=39,398.03..40,368.99 rows=86 width=443) (actual time=113.218..113.218 rows=0 loops=3)

  • Hash Cond: ((pd.salutation)::text = (sm.salutation_id)::text)
11. 0.001 113.218 ↓ 0.0 0 3 / 3

Nested Loop Left Join (cost=39,396.63..40,367.31 rows=86 width=334) (actual time=113.218..113.218 rows=0 loops=3)

12. 0.000 113.217 ↓ 0.0 0 3 / 3

Hash Left Join (cost=39,396.21..40,327.38 rows=86 width=325) (actual time=113.217..113.217 rows=0 loops=3)

  • Hash Cond: ((pr.secondary_sponsor_id)::text = (stpa.tpa_id)::text)
13. 0.001 113.217 ↓ 0.0 0 3 / 3

Hash Left Join (cost=39,386.35..40,317.30 rows=86 width=303) (actual time=113.217..113.217 rows=0 loops=3)

  • Hash Cond: ((pr.primary_sponsor_id)::text = (ptpa.tpa_id)::text)
14. 0.000 113.216 ↓ 0.0 0 3 / 3

Nested Loop Left Join (cost=39,376.49..40,307.21 rows=86 width=291) (actual time=113.216..113.216 rows=0 loops=3)

15. 0.001 113.216 ↓ 0.0 0 3 / 3

Hash Left Join (cost=39,376.21..40,282.05 rows=86 width=278) (actual time=113.215..113.216 rows=0 loops=3)

  • Hash Cond: (pr.visit_type = vn.visit_type)
16. 0.001 113.215 ↓ 0.0 0 3 / 3

Nested Loop Left Join (cost=39,375.12..40,280.49 rows=86 width=248) (actual time=113.215..113.215 rows=0 loops=3)

17. 0.001 113.214 ↓ 0.0 0 3 / 3

Nested Loop (cost=39,374.13..40,175.76 rows=86 width=260) (actual time=113.214..113.214 rows=0 loops=3)

18. 0.015 113.193 ↑ 135.6 7 3 / 3

Nested Loop Left Join (cost=39,374.00..40,027.75 rows=949 width=250) (actual time=113.141..113.193 rows=7 loops=3)

19. 0.005 113.118 ↑ 135.6 7 3 / 3

Merge Left Join (cost=39,373.57..39,496.56 rows=949 width=218) (actual time=113.111..113.118 rows=7 loops=3)

  • Merge Cond: ((b.visit_id)::text = (isr.incoming_visit_id)::text)
20. 0.007 113.080 ↑ 135.6 7 3 / 3

Merge Left Join (cost=39,373.30..39,379.45 rows=949 width=209) (actual time=113.076..113.080 rows=7 loops=3)

  • Merge Cond: ((b.visit_id)::text = (prc.customer_id)::text)
21. 0.043 113.045 ↑ 135.6 7 3 / 3

Sort (cost=39,349.12..39,351.49 rows=949 width=161) (actual time=113.044..113.045 rows=7 loops=3)

  • Sort Key: b.visit_id
  • Sort Method: quicksort Memory: 25kB
22. 0.031 113.002 ↑ 135.6 7 3 / 3

Nested Loop (cost=0.42..39,302.19 rows=949 width=161) (actual time=64.792..113.002 rows=7 loops=3)

23. 112.844 112.844 ↑ 135.6 7 3 / 3

Parallel Seq Scan on bill b (cost=0.00..32,846.37 rows=949 width=92) (actual time=64.701..112.844 rows=7 loops=3)

  • Filter: (is_tpa AND (status <> 'X'::bpchar) AND (date(open_date) >= '2018-02-10'::date) AND (date(open_date) <= '2018-02-20'::date))
  • Rows Removed by Filter: 193736
24. 0.127 0.127 ↑ 1.0 1 20 / 3

Index Scan using patient_registration_pkey on patient_registration pr (cost=0.42..6.80 rows=1 width=69) (actual time=0.019..0.019 rows=1 loops=20)

  • Index Cond: ((patient_id)::text = (b.visit_id)::text)
25. 0.016 0.028 ↓ 0.0 0 3 / 3

Sort (cost=24.18..24.88 rows=280 width=48) (actual time=0.028..0.028 rows=0 loops=3)

  • Sort Key: prc.customer_id
  • Sort Method: quicksort Memory: 25kB
26. 0.012 0.012 ↓ 0.0 0 3 / 3

Seq Scan on store_retail_customers prc (cost=0.00..12.80 rows=280 width=48) (actual time=0.012..0.012 rows=0 loops=3)

27. 0.033 0.033 ↑ 1,400.0 1 3 / 3

Index Only Scan using incoming_sample_registration_pkey on incoming_sample_registration isr (cost=0.28..111.20 rows=1,400 width=9) (actual time=0.033..0.033 rows=1 loops=3)

  • Heap Fetches: 1
28. 0.060 0.060 ↑ 1.0 1 20 / 3

Index Scan using patient_details_pkey on patient_details pd (cost=0.42..0.56 rows=1 width=47) (actual time=0.009..0.009 rows=1 loops=20)

  • Index Cond: ((mr_no)::text = (pr.mr_no)::text)
29. 0.020 0.020 ↓ 0.0 0 20 / 3

Index Scan using center_pkey on hospital_center_master hcm (cost=0.14..0.16 rows=1 width=18) (actual time=0.003..0.003 rows=0 loops=20)

  • Index Cond: (center_id = pr.center_id)
  • Filter: ((center_name)::text = 'NMC Royal'::text)
  • Rows Removed by Filter: 1
30. 0.000 0.000 ↓ 0.0 0 / 3

Nested Loop Left Join (cost=0.99..1.21 rows=1 width=20) (never executed)

31. 0.000 0.000 ↓ 0.0 0 / 3

Nested Loop (cost=0.57..0.68 rows=1 width=20) (never executed)

32. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using policy_patient_idx on patient_insurance_plans pri_plan (cost=0.42..0.51 rows=1 width=42) (never executed)

  • Index Cond: ((patient_id)::text = (pr.patient_id)::text)
  • Filter: (priority = 1)
33. 0.000 0.000 ↓ 0.0 0 / 3

Index Only Scan using tpa_master_pkey on tpa_master pri_tm (cost=0.14..0.16 rows=1 width=10) (never executed)

  • Index Cond: (tpa_id = (pri_plan.sponsor_id)::text)
  • Heap Fetches: 0
34. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using policy_patient_idx on patient_insurance_plans sec_plan (cost=0.42..0.52 rows=1 width=38) (never executed)

  • Index Cond: ((pri_plan.patient_id)::text = (patient_id)::text)
  • Filter: (priority = 2)
35. 0.000 0.000 ↓ 0.0 0 / 3

Hash (cost=1.04..1.04 rows=4 width=40) (never executed)

36. 0.000 0.000 ↓ 0.0 0 / 3

Seq Scan on visit_type_names vn (cost=0.00..1.04 rows=4 width=40) (never executed)

37. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using organization_details_pkey on organization_details od (cost=0.28..0.29 rows=1 width=29) (never executed)

  • Index Cond: ((pr.org_id)::text = (org_id)::text)
38. 0.000 0.000 ↓ 0.0 0 / 3

Hash (cost=7.16..7.16 rows=216 width=32) (never executed)

39. 0.000 0.000 ↓ 0.0 0 / 3

Seq Scan on tpa_master ptpa (cost=0.00..7.16 rows=216 width=32) (never executed)

40. 0.000 0.000 ↓ 0.0 0 / 3

Hash (cost=7.16..7.16 rows=216 width=32) (never executed)

41. 0.000 0.000 ↓ 0.0 0 / 3

Seq Scan on tpa_master stpa (cost=0.00..7.16 rows=216 width=32) (never executed)

42. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using patient_policy_details_patient_policy_id_key on patient_policy_details pppd (cost=0.42..0.46 rows=1 width=17) (never executed)

  • Index Cond: (patient_policy_id = pri_plan.patient_policy_id)
43. 0.000 0.000 ↓ 0.0 0 / 3

Hash (cost=1.18..1.18 rows=18 width=156) (never executed)

44. 0.000 0.000 ↓ 0.0 0 / 3

Seq Scan on salutation_master sm (cost=0.00..1.18 rows=18 width=156) (never executed)

45. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using bill_claim_bill_no_idx on bill_claim bclm (cost=0.42..7.47 rows=1 width=28) (never executed)

  • Index Cond: ((bill_no)::text = (b.bill_no)::text)
46. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using insurance_claim_id_index on insurance_claim icl (cost=0.42..0.53 rows=1 width=23) (never executed)

  • Index Cond: ((claim_id)::text = (bclm.claim_id)::text)
47. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using insurance_submission_batch_pkey on insurance_submission_batch firstsub (cost=0.29..0.31 rows=1 width=17) (never executed)

  • Index Cond: ((submission_batch_id)::text = (icl.submission_batch_id)::text)
  • Filter: (is_resubmission = 'N'::bpchar)
48. 0.000 0.000 ↓ 0.0 0 / 3

Hash (cost=1,809.53..1,809.53 rows=24,206 width=46) (never executed)

49. 0.000 0.000 ↓ 0.0 0 / 3

HashAggregate (cost=1,325.41..1,567.47 rows=24,206 width=46) (never executed)

  • Group Key: insurance_claim_resubmission.claim_id
50. 0.000 0.000 ↓ 0.0 0 / 3

Seq Scan on insurance_claim_resubmission (cost=0.00..1,137.94 rows=37,494 width=23) (never executed)

51. 0.000 0.000 ↓ 0.0 0

Materialize (cost=568,430.11..616,862.11 rows=484,320 width=42) (never executed)

52. 0.000 0.000 ↓ 0.0 0

Group (cost=568,430.11..610,808.11 rows=484,320 width=886) (never executed)

  • Group Key: bcl.bill_no, bcl_1.claim_id, sic.submission_batch_id, sic.main_visit_id, sic.status, sic.resubmission_count, sic.closure_type, sic.action_remarks, sic.attachment, sic.attachment_content_type, sic.resubmission_type, sic.comments, sic.account_group, sip.patient_id, sic.denial_remarks, sic.submission_id_with_correction, sic.payers_reference_no, bcl_2.claim_id, sic_1.submission_batch_id, sic_1.main_visit_id, sic_1.status, sic_1.resubmission_count, sic_1.closure_type, sic_1.action_remarks, sic_1.attachment, sic_1.attachment_content_type, sic_1.resubmission_type, sic_1.comments, sic_1.account_group, sic_1.denial_remarks, sic_1.submission_id_with_correction, sic_1.payers_reference_no, sic.op_type, sic_1.op_type
53. 0.000 0.000 ↓ 0.0 0

Sort (cost=568,430.11..569,640.91 rows=484,320 width=886) (never executed)

  • Sort Key: bcl.bill_no, bcl_1.claim_id, sic.submission_batch_id, sic.main_visit_id, sic.status, sic.resubmission_count, sic.closure_type, sic.action_remarks, sic.attachment, sic.attachment_content_type, sic.resubmission_type, sic.comments, sic.account_group, sip.patient_id, sic.denial_remarks, sic.submission_id_with_correction, sic.payers_reference_no, bcl_2.claim_id, sic_1.submission_batch_id, sic_1.main_visit_id, sic_1.status, sic_1.resubmission_count, sic_1.closure_type, sic_1.action_remarks, sic_1.attachment, sic_1.attachment_content_type, sic_1.resubmission_type, sic_1.comments, sic_1.account_group, sic_1.denial_remarks, sic_1.submission_id_with_correction, sic_1.payers_reference_no, sic.op_type, sic_1.op_type
54. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=113,160.89..145,263.73 rows=484,320 width=886) (never executed)

  • Merge Cond: ((bcl.bill_no)::text = (bcl_1.bill_no)::text)
55. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=32,085.90..62,865.76 rows=484,320 width=442) (never executed)

  • Merge Cond: ((bcl.bill_no)::text = (bcl_2.bill_no)::text)
56. 0.000 0.000 ↓ 0.0 0

Index Only Scan using bill_claim_bill_no_idx on bill_claim bcl (cost=0.42..29,565.22 rows=484,320 width=14) (never executed)

  • Heap Fetches: 0
57. 0.000 0.000 ↓ 0.0 0

Sort (cost=32,085.47..32,086.06 rows=233 width=442) (never executed)

  • Sort Key: bcl_2.bill_no
58. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.85..32,076.31 rows=233 width=442) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
59. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..31,053.01 rows=97 width=442) (never executed)

60. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..30,992.04 rows=100 width=428) (never executed)

61. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on patient_insurance_plans sip_1 (cost=0.00..9,683.81 rows=7,160 width=20) (never executed)

  • Filter: (priority = 2)
62. 0.000 0.000 ↓ 0.0 0

Index Scan using insurance_claim_patient_id_idx on insurance_claim sic_1 (cost=0.42..2.97 rows=1 width=448) (never executed)

  • Index Cond: ((patient_id)::text = (sip_1.patient_id)::text)
  • Filter: (sip_1.plan_id = plan_id)
63. 0.000 0.000 ↓ 0.0 0

Index Scan using bill_claim_claim_idx on bill_claim bcl_2 (cost=0.42..0.60 rows=1 width=28) (never executed)

  • Index Cond: ((claim_id)::text = (sic_1.claim_id)::text)
64. 0.000 0.000 ↓ 0.0 0

Sort (cost=81,074.99..81,090.36 rows=6,145 width=458) (never executed)

  • Sort Key: bcl_1.bill_no
65. 0.000 0.000 ↓ 0.0 0

Gather (cost=23,567.65..80,688.31 rows=6,145 width=458) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
66. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=22,567.65..79,073.81 rows=2,560 width=458) (never executed)

67. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=22,567.22..77,475.16 rows=2,622 width=444) (never executed)

  • Hash Cond: (((sic.patient_id)::text = (sip.patient_id)::text) AND (sic.plan_id = sip.plan_id))
68. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on insurance_claim sic (cost=0.00..11,356.78 rows=206,678 width=448) (never executed)

69. 0.000 0.000 ↓ 0.0 0

Hash (cost=13,113.54..13,113.54 rows=453,179 width=20) (never executed)

70. 0.000 0.000 ↓ 0.0 0

Seq Scan on patient_insurance_plans sip (cost=0.00..13,113.54 rows=453,179 width=20) (never executed)

  • Filter: (priority = 1)
71. 0.000 0.000 ↓ 0.0 0

Index Scan using bill_claim_claim_idx on bill_claim bcl_1 (cost=0.42..0.60 rows=1 width=28) (never executed)

  • Index Cond: ((claim_id)::text = (sic.claim_id)::text)
72. 0.000 0.000 ↓ 0.0 0

Materialize (cost=2,066,336.12..2,083,564.28 rows=116,801 width=170) (never executed)

73. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=2,066,336.12..2,082,104.27 rows=116,801 width=388) (never executed)

  • Group Key: all_insurance_remittance_details_view.bill_no, all_insurance_remittance_details_view.payment_reference, all_insurance_remittance_details_view.reference_no
74. 0.000 0.000 ↓ 0.0 0

Sort (cost=2,066,336.12..2,069,256.15 rows=1,168,011 width=388) (never executed)

  • Sort Key: all_insurance_remittance_details_view.bill_no, all_insurance_remittance_details_view.payment_reference, all_insurance_remittance_details_view.reference_no
75. 0.000 0.000 ↓ 0.0 0

Subquery Scan on all_insurance_remittance_details_view (cost=1,518,828.04..1,533,428.18 rows=1,168,011 width=388) (never executed)

76. 0.000 0.000 ↓ 0.0 0

Sort (cost=1,518,828.04..1,521,748.07 rows=1,168,011 width=400) (never executed)

  • Sort Key: bill_charge.bill_no DESC
77. 0.000 0.000 ↓ 0.0 0

Unique (cost=957,499.90..977,940.10 rows=1,168,011 width=400) (never executed)

78. 0.000 0.000 ↓ 0.0 0

Sort (cost=957,499.90..960,419.93 rows=1,168,011 width=400) (never executed)

  • Sort Key: bill_charge.bill_no, insurance_payment_allocation.payment_reference, ir.remittance_id, ir.received_date, ir.is_recovery, ir.reference_no
79. 0.000 0.000 ↓ 0.0 0

Append (cost=191,355.38..416,611.96 rows=1,168,011 width=400) (never executed)

80. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=191,355.38..252,522.31 rows=1,129,465 width=40) (never executed)

  • Hash Cond: (insurance_payment_allocation.remittance_id = ir.remittance_id)
81. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=191,023.77..249,224.26 rows=1,129,465 width=26) (never executed)

  • Hash Cond: ((insurance_payment_allocation.charge_id)::text = (bill_charge.charge_id)::text)
82. 0.000 0.000 ↓ 0.0 0

Seq Scan on insurance_payment_allocation (cost=0.00..27,523.65 rows=1,129,465 width=21) (never executed)

83. 0.000 0.000 ↓ 0.0 0

Hash (cost=145,666.23..145,666.23 rows=2,470,523 width=23) (never executed)

84. 0.000 0.000 ↓ 0.0 0

Seq Scan on bill_charge (cost=0.00..145,666.23 rows=2,470,523 width=23) (never executed)

85. 0.000 0.000 ↓ 0.0 0

Hash (cost=232.94..232.94 rows=7,894 width=18) (never executed)

86. 0.000 0.000 ↓ 0.0 0

Seq Scan on insurance_remittance ir (cost=0.00..232.94 rows=7,894 width=18) (never executed)

87. 0.000 0.000 ↓ 0.0 0

Gather (cost=71,907.83..126,535.84 rows=12,849 width=40) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
88. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=70,907.83..124,250.94 rows=5,354 width=40) (never executed)

89. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=70,907.40..116,897.20 rows=5,354 width=35) (never executed)

  • Hash Cond: (ipa.remittance_id = ipu.remittance_id)
90. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on insurance_payment_allocation ipa (cost=70,570.95..92,682.58 rows=235,305 width=21) (never executed)

  • Filter: (NOT (hashed SubPlan 1))
91.          

SubPlan (for Parallel Seq Scan)

92. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.86..70,506.70 rows=25,697 width=4) (never executed)

93. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..47,109.55 rows=25,697 width=13) (never executed)

94. 0.000 0.000 ↓ 0.0 0

Seq Scan on insurance_payment_unalloc_amount ipu_2 (cost=0.00..3.13 rows=113 width=4) (never executed)

95. 0.000 0.000 ↓ 0.0 0

Index Scan using insurance_payment_allocation_remittance_id_index on insurance_payment_allocation insurance_payment_allocation_1 (cost=0.43..413.96 rows=291 width=13) (never executed)

  • Index Cond: (remittance_id = ipu_2.remittance_id)
96. 0.000 0.000 ↓ 0.0 0

Index Only Scan using bill_charge_pkey on bill_charge bc_2 (cost=0.43..0.91 rows=1 width=9) (never executed)

  • Index Cond: (charge_id = (insurance_payment_allocation_1.charge_id)::text)
  • Heap Fetches: 0
97. 0.000 0.000 ↓ 0.0 0

Hash (cost=335.04..335.04 rows=113 width=22) (never executed)

98. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=331.62..335.04 rows=113 width=22) (never executed)

  • Hash Cond: (ipu.remittance_id = ir_1.remittance_id)
99. 0.000 0.000 ↓ 0.0 0

Seq Scan on insurance_payment_unalloc_amount ipu (cost=0.00..3.13 rows=113 width=10) (never executed)

100. 0.000 0.000 ↓ 0.0 0

Hash (cost=232.94..232.94 rows=7,894 width=12) (never executed)

101. 0.000 0.000 ↓ 0.0 0

Seq Scan on insurance_remittance ir_1 (cost=0.00..232.94 rows=7,894 width=12) (never executed)

102. 0.000 0.000 ↓ 0.0 0

Index Scan using bill_charge_pkey on bill_charge bc (cost=0.43..1.37 rows=1 width=23) (never executed)

  • Index Cond: ((charge_id)::text = (ipa.charge_id)::text)
103. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=332.47..25,873.69 rows=25,697 width=40) (never executed)

104. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=332.04..2,476.53 rows=25,697 width=49) (never executed)

  • Join Filter: (ipu_1.remittance_id = ipa_1.remittance_id)
105. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=331.62..335.04 rows=113 width=44) (never executed)

  • Hash Cond: (ipu_1.remittance_id = ir_2.remittance_id)
106. 0.000 0.000 ↓ 0.0 0

Seq Scan on insurance_payment_unalloc_amount ipu_1 (cost=0.00..3.13 rows=113 width=32) (never executed)

107. 0.000 0.000 ↓ 0.0 0

Hash (cost=232.94..232.94 rows=7,894 width=12) (never executed)

108. 0.000 0.000 ↓ 0.0 0

Seq Scan on insurance_remittance ir_2 (cost=0.00..232.94 rows=7,894 width=12) (never executed)

109. 0.000 0.000 ↓ 0.0 0

Index Scan using insurance_payment_allocation_remittance_id_index on insurance_payment_allocation ipa_1 (cost=0.43..15.31 rows=291 width=13) (never executed)

  • Index Cond: (remittance_id = ir_2.remittance_id)
110. 0.000 0.000 ↓ 0.0 0

Index Only Scan using bill_charge_pkey on bill_charge bc_1 (cost=0.43..0.91 rows=1 width=9) (never executed)

  • Index Cond: (charge_id = (ipa_1.charge_id)::text)
  • Heap Fetches: 0
111. 0.000 0.000 ↓ 0.0 0

Index Scan using insurance_submission_batch_pkey on insurance_submission_batch resub (cost=0.29..0.35 rows=1 width=17) (never executed)

  • Index Cond: ((submission_batch_id)::text = (max((insurance_claim_resubmission.resubmission_batch_id)::text)))
Planning time : 32.665 ms
Execution time : 131.065 ms