explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cst5

Settings
# exclusive inclusive rows x rows loops node
1. 54.997 23,389.591 ↓ 7,456.0 14,912 1

Sort (cost=3,172,963.42..3,172,963.43 rows=2 width=349) (actual time=23,387.763..23,389.591 rows=14,912 loops=1)

  • Sort Key: b.bill_no
  • Sort Method: quicksort Memory: 8243kB
2. 1.397 23,334.594 ↓ 7,456.0 14,912 1

Append (cost=324,806.98..3,172,963.41 rows=2 width=349) (actual time=2,862.943..23,334.594 rows=14,912 loops=1)

3. 20.921 11,661.947 ↓ 14,876.0 14,876 1

Nested Loop Left Join (cost=324,806.98..2,294,822.79 rows=1 width=311) (actual time=2,862.942..11,661.947 rows=14,876 loops=1)

4. 6.793 11,507.142 ↓ 14,876.0 14,876 1

Nested Loop Left Join (cost=324,806.42..2,294,796.21 rows=1 width=293) (actual time=2,862.907..11,507.142 rows=14,876 loops=1)

5. 6.336 11,470.597 ↓ 14,876.0 14,876 1

Nested Loop (cost=324,806.14..2,294,792.93 rows=1 width=267) (actual time=2,862.896..11,470.597 rows=14,876 loops=1)

6. 38.172 11,418.980 ↓ 45,281.0 45,281 1

Nested Loop Left Join (cost=324,806.01..2,294,791.76 rows=1 width=259) (actual time=2,862.799..11,418.980 rows=45,281 loops=1)

7. 37.660 11,290.246 ↓ 45,281.0 45,281 1

Nested Loop Left Join (cost=324,805.73..2,294,788.52 rows=1 width=243) (actual time=2,862.788..11,290.246 rows=45,281 loops=1)

8. 0.706 11,162.024 ↓ 45,281.0 45,281 1

Nested Loop Left Join (cost=324,805.46..2,294,785.77 rows=1 width=230) (actual time=2,862.781..11,162.024 rows=45,281 loops=1)

9. 0.000 11,025.475 ↓ 45,281.0 45,281 1

Nested Loop Left Join (cost=324,805.18..2,294,782.34 rows=1 width=216) (actual time=2,862.775..11,025.475 rows=45,281 loops=1)

10. 17.069 10,935.348 ↓ 45,281.0 45,281 1

Nested Loop Left Join (cost=324,805.04..2,294,782.17 rows=1 width=212) (actual time=2,862.765..10,935.348 rows=45,281 loops=1)

11. 12.530 10,193.783 ↓ 45,281.0 45,281 1

Nested Loop Left Join (cost=324,803.90..2,294,773.37 rows=1 width=204) (actual time=2,862.723..10,193.783 rows=45,281 loops=1)

12. 33.793 9,864.286 ↓ 45,281.0 45,281 1

Nested Loop (cost=324,803.47..2,294,771.28 rows=1 width=204) (actual time=2,862.706..9,864.286 rows=45,281 loops=1)

13. 24.845 9,513.526 ↓ 45,281.0 45,281 1

Nested Loop Left Join (cost=324,803.04..2,294,766.24 rows=1 width=158) (actual time=2,862.687..9,513.526 rows=45,281 loops=1)

14. 28.102 9,398.119 ↓ 45,281.0 45,281 1

Nested Loop (cost=324,802.76..2,294,762.81 rows=1 width=143) (actual time=2,862.676..9,398.119 rows=45,281 loops=1)

  • Join Filter: ((b.bill_no)::text = (bcc.bill_no)::text)
  • Rows Removed by Join Filter: 201
15. 3,639.021 9,006.161 ↑ 5.5 45,482 1

Hash Join (cost=324,802.20..1,224,400.11 rows=250,388 width=87) (actual time=2,862.638..9,006.161 rows=45,482 loops=1)

  • Hash Cond: ((pbcc.claim_id)::text = (pbcl.claim_id)::text)
16. 2,504.853 2,504.853 ↑ 1.0 6,852,221 1

Seq Scan on bill_charge_claim pbcc (cost=0.00..639,278.00 rows=6,875,094 width=27) (actual time=0.030..2,504.853 rows=6,852,221 loops=1)

  • Filter: (denial_code IS NOT NULL)
  • Rows Removed by Filter: 14306775
17. 72.863 2,862.287 ↓ 1.3 183,620 1

Hash (cost=323,077.31..323,077.31 rows=137,991 width=74) (actual time=2,862.287..2,862.287 rows=183,620 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 19700kB
18. 1,794.953 2,789.424 ↓ 1.3 183,620 1

Hash Join (cost=190,508.75..323,077.31 rows=137,991 width=74) (actual time=305.856..2,789.424 rows=183,620 loops=1)

  • Hash Cond: ((pbcl.bill_no)::text = (b.bill_no)::text)
19. 690.865 690.865 ↓ 1.0 3,838,300 1

Seq Scan on bill_claim pbcl (cost=0.00..97,627.30 rows=3,835,583 width=28) (actual time=0.007..690.865 rows=3,838,300 loops=1)

  • Filter: (priority = 1)
  • Rows Removed by Filter: 44558
20. 45.456 303.606 ↓ 1.0 183,620 1

Hash (cost=188,277.92..188,277.92 rows=178,467 width=46) (actual time=303.606..303.606 rows=183,620 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 14346kB
21. 258.150 258.150 ↓ 1.0 183,620 1

Index Scan using bill_finalized_date_idx on bill b (cost=0.44..188,277.92 rows=178,467 width=46) (actual time=0.016..258.150 rows=183,620 loops=1)

  • Index Cond: ((date(finalized_date) >= '2018-09-01'::date) AND (date(finalized_date) <= '2018-09-30'::date))
  • Filter: (is_tpa AND (status <> 'X'::bpchar))
  • Rows Removed by Filter: 61392
22. 363.856 363.856 ↑ 1.0 1 45,482

Index Scan using bill_charge_pkey on bill_charge bcc (cost=0.56..4.26 rows=1 width=104) (actual time=0.008..0.008 rows=1 loops=45,482)

  • Index Cond: ((charge_id)::text = (pbcc.charge_id)::text)
  • Filter: ((claim_status <> 'C'::bpchar) AND (status = 'A'::bpchar) AND ((charge_head)::text <> ALL ('{PHMED,PHCMED,PHRET,PHCRET}'::text[])))
23. 90.562 90.562 ↑ 1.0 1 45,281

Index Scan using doctors_pkey on doctors predoc (cost=0.28..3.42 rows=1 width=30) (actual time=0.002..0.002 rows=1 loops=45,281)

  • Index Cond: ((doctor_id)::text = (bcc.prescribing_dr_id)::text)
24. 316.967 316.967 ↑ 1.0 1 45,281

Index Scan using patient_registration_pkey on patient_registration pr (cost=0.43..5.03 rows=1 width=61) (actual time=0.007..0.007 rows=1 loops=45,281)

  • Index Cond: ((patient_id)::text = (b.visit_id)::text)
25. 316.967 316.967 ↑ 1.0 1 45,281

Index Only Scan using patient_details_pkey on patient_details pd (cost=0.43..2.08 rows=1 width=15) (actual time=0.007..0.007 rows=1 loops=45,281)

  • Index Cond: (mr_no = (pr.mr_no)::text)
  • Heap Fetches: 4345
26. 0.054 724.496 ↑ 1.0 1 45,281

Nested Loop Left Join (cost=1.14..8.80 rows=1 width=24) (actual time=0.016..0.016 rows=1 loops=45,281)

27. 45.299 452.810 ↑ 1.0 1 45,281

Nested Loop (cost=0.71..5.04 rows=1 width=24) (actual time=0.010..0.010 rows=1 loops=45,281)

28. 316.967 316.967 ↑ 1.0 1 45,281

Index Scan using patient_insurance_plans_patient_id on patient_insurance_plans pri_plan (cost=0.43..3.74 rows=1 width=38) (actual time=0.007..0.007 rows=1 loops=45,281)

  • Index Cond: ((patient_id)::text = (pr.patient_id)::text)
  • Filter: (priority = 1)
  • Rows Removed by Filter: 0
29. 90.544 90.544 ↑ 1.0 1 45,272

Index Only Scan using tpa_master_pkey on tpa_master pri_tm (cost=0.28..1.30 rows=1 width=10) (actual time=0.002..0.002 rows=1 loops=45,272)

  • Index Cond: (tpa_id = (pri_plan.sponsor_id)::text)
  • Heap Fetches: 0
30. 271.632 271.632 ↓ 0.0 0 45,272

Index Scan using patient_insurance_plans_patient_id on patient_insurance_plans sec_plan (cost=0.43..3.74 rows=1 width=38) (actual time=0.006..0.006 rows=0 loops=45,272)

  • Index Cond: ((pri_plan.patient_id)::text = (patient_id)::text)
  • Filter: (priority = 2)
  • Rows Removed by Filter: 1
31. 90.562 90.562 ↑ 1.0 1 45,281

Index Scan using department_pkey on department admdep (cost=0.14..0.16 rows=1 width=20) (actual time=0.001..0.002 rows=1 loops=45,281)

  • Index Cond: ((pr.admitted_dept)::text = (dept_id)::text)
32. 135.843 135.843 ↑ 1.0 1 45,281

Index Scan using doctors_pkey on doctors dr (cost=0.28..3.42 rows=1 width=30) (actual time=0.002..0.003 rows=1 loops=45,281)

  • Index Cond: ((doctor_id)::text = (pr.doctor)::text)
33. 90.562 90.562 ↑ 1.0 1 45,281

Index Scan using tpa_master_pkey on tpa_master ptpa (cost=0.28..2.75 rows=1 width=33) (actual time=0.002..0.002 rows=1 loops=45,281)

  • Index Cond: ((tpa_id)::text = (pr.primary_sponsor_id)::text)
34. 90.562 90.562 ↑ 1.0 1 45,281

Index Scan using insurance_company_master_pkey on insurance_company_master picm (cost=0.28..3.23 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=45,281)

  • Index Cond: ((insurance_co_id)::text = (pri_plan.insurance_co)::text)
35. 45.281 45.281 ↓ 0.0 0 45,281

Index Scan using center_pkey on hospital_center_master hcm (cost=0.14..1.16 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=45,281)

  • Index Cond: (center_id = pr.center_id)
  • Filter: ((center_name)::text = 'NMCAbuDhabi'::text)
  • Rows Removed by Filter: 1
36. 29.752 29.752 ↑ 1.0 1 14,876

Index Scan using insurance_denial_codes_pkey on insurance_denial_codes pidc (cost=0.28..3.27 rows=1 width=36) (actual time=0.002..0.002 rows=1 loops=14,876)

  • Index Cond: ((denial_code)::text = (pbcc.denial_code)::text)
37. 133.884 133.884 ↑ 5.0 1 14,876

Index Scan using mrd_diagnosis_visit_index on mrd_diagnosis pdiag (cost=0.56..26.51 rows=5 width=50) (actual time=0.008..0.009 rows=1 loops=14,876)

  • Index Cond: ((visit_id)::text = (pr.patient_id)::text)
  • Filter: (diag_type = 'P'::bpchar)
  • Rows Removed by Filter: 2
38. 0.075 11,671.250 ↓ 36.0 36 1

Subquery Scan on *SELECT* 2 (cost=336,098.31..878,140.61 rows=1 width=387) (actual time=3,255.078..11,671.250 rows=36 loops=1)

39. 0.339 11,671.175 ↓ 36.0 36 1

Nested Loop Left Join (cost=336,098.31..878,140.60 rows=1 width=387) (actual time=3,255.073..11,671.175 rows=36 loops=1)

40. 0.072 11,669.864 ↓ 36.0 36 1

Nested Loop Left Join (cost=336,097.75..878,101.71 rows=1 width=369) (actual time=3,254.985..11,669.864 rows=36 loops=1)

41. 0.000 11,669.648 ↓ 36.0 36 1

Nested Loop (cost=336,097.48..878,099.18 rows=1 width=343) (actual time=3,254.972..11,669.648 rows=36 loops=1)

42. 0.807 11,668.373 ↓ 642.0 642 1

Nested Loop Left Join (cost=336,097.34..878,098.01 rows=1 width=335) (actual time=3,115.818..11,668.373 rows=642 loops=1)

43. 0.435 11,665.640 ↓ 642.0 642 1

Nested Loop Left Join (cost=336,097.07..878,095.84 rows=1 width=319) (actual time=3,115.808..11,665.640 rows=642 loops=1)

44. 0.378 11,663.279 ↓ 642.0 642 1

Nested Loop Left Join (cost=336,096.79..878,093.45 rows=1 width=306) (actual time=3,115.798..11,663.279 rows=642 loops=1)

45. 0.576 11,660.333 ↓ 642.0 642 1

Nested Loop Left Join (cost=336,096.51..878,090.63 rows=1 width=292) (actual time=3,115.788..11,660.333 rows=642 loops=1)

46. 0.670 11,658.473 ↓ 642.0 642 1

Nested Loop Left Join (cost=336,096.37..878,090.47 rows=1 width=288) (actual time=3,115.780..11,658.473 rows=642 loops=1)

47. 0.813 11,646.247 ↓ 642.0 642 1

Nested Loop Left Join (cost=336,095.24..878,082.88 rows=1 width=280) (actual time=3,115.740..11,646.247 rows=642 loops=1)

48. 0.631 11,640.940 ↓ 642.0 642 1

Nested Loop (cost=336,094.81..878,081.10 rows=1 width=280) (actual time=3,115.718..11,640.940 rows=642 loops=1)

49. 0.594 11,635.173 ↓ 642.0 642 1

Nested Loop Left Join (cost=336,094.38..878,076.28 rows=1 width=234) (actual time=3,115.697..11,635.173 rows=642 loops=1)

50. 0.780 11,634.579 ↓ 642.0 642 1

Nested Loop (cost=336,094.10..878,073.47 rows=1 width=219) (actual time=3,115.694..11,634.579 rows=642 loops=1)

51. 260.754 11,631.873 ↓ 642.0 642 1

Nested Loop (cost=336,093.68..878,071.73 rows=1 width=165) (actual time=3,115.679..11,631.873 rows=642 loops=1)

52. 398.378 8,268.152 ↓ 443,281.0 443,281 1

Nested Loop (cost=336,093.13..878,068.40 rows=1 width=133) (actual time=2,709.667..8,268.152 rows=443,281 loops=1)

53. 561.469 4,766.807 ↓ 443,281.0 443,281 1

Hash Join (cost=336,092.56..878,062.94 rows=1 width=76) (actual time=2,709.637..4,766.807 rows=443,281 loops=1)

  • Hash Cond: (((s.sale_id)::text = (ssm.sale_id)::text) AND ((pbcl_1.bill_no)::text = (ssm.bill_no)::text))
54. 792.749 3,855.215 ↑ 1.0 452,030 1

Hash Join (cost=304,085.86..838,139.77 rows=452,369 width=89) (actual time=2,359.108..3,855.215 rows=452,030 loops=1)

  • Hash Cond: (pscl.sale_item_id = s.sale_item_id)
55. 546.942 2,107.958 ↑ 1.0 452,030 1

Hash Join (cost=171,792.09..674,809.49 rows=452,382 width=49) (actual time=1,404.288..2,107.958 rows=452,030 loops=1)

  • Hash Cond: ((pscl.claim_id)::text = (pbcl_1.claim_id)::text)
56. 157.246 157.246 ↑ 1.0 443,367 1

Seq Scan on sales_claim_details pscl (cost=0.00..35,759.71 rows=446,918 width=21) (actual time=0.005..157.246 rows=443,367 loops=1)

  • Filter: (denial_code IS NOT NULL)
  • Rows Removed by Filter: 953728
57. 747.668 1,403.770 ↓ 1.0 3,838,300 1

Hash (cost=97,627.30..97,627.30 rows=3,835,583 width=28) (actual time=1,403.770..1,403.770 rows=3,838,300 loops=1)

  • Buckets: 131072 Batches: 8 Memory Usage: 29034kB
58. 656.102 656.102 ↓ 1.0 3,838,300 1

Seq Scan on bill_claim pbcl_1 (cost=0.00..97,627.30 rows=3,835,583 width=28) (actual time=0.008..656.102 rows=3,838,300 loops=1)

  • Filter: (priority = 1)
  • Rows Removed by Filter: 44558
59. 364.009 954.508 ↓ 1.0 1,498,322 1

Hash (cost=100,435.15..100,435.15 rows=1,496,450 width=44) (actual time=954.508..954.508 rows=1,498,322 loops=1)

  • Buckets: 65536 Batches: 4 Memory Usage: 28902kB
60. 590.499 590.499 ↓ 1.0 1,498,322 1

Seq Scan on store_sales_details s (cost=0.00..100,435.15 rows=1,496,450 width=44) (actual time=0.008..590.499 rows=1,498,322 loops=1)

  • Filter: (claim_status <> 'C'::bpchar)
  • Rows Removed by Filter: 45
61. 187.995 350.123 ↑ 1.0 678,892 1

Hash (cost=21,820.08..21,820.08 rows=679,108 width=33) (actual time=350.123..350.123 rows=678,892 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 44237kB
62. 162.128 162.128 ↑ 1.0 678,892 1

Seq Scan on store_sales_main ssm (cost=0.00..21,820.08 rows=679,108 width=33) (actual time=0.005..162.128 rows=678,892 loops=1)

63. 3,102.967 3,102.967 ↑ 1.0 1 443,281

Index Scan using bill_charge_pkey on bill_charge bc (cost=0.56..5.45 rows=1 width=77) (actual time=0.007..0.007 rows=1 loops=443,281)

  • Index Cond: ((charge_id)::text = (ssm.charge_id)::text)
  • Filter: (status = 'A'::bpchar)
64. 3,102.967 3,102.967 ↓ 0.0 0 443,281

Index Scan using bill_pkey on bill b_1 (cost=0.56..3.31 rows=1 width=46) (actual time=0.007..0.007 rows=0 loops=443,281)

  • Index Cond: ((bill_no)::text = (bc.bill_no)::text)
  • Filter: (is_tpa AND (status <> 'X'::bpchar) AND (date(finalized_date) >= '2018-09-01'::date) AND (date(finalized_date) <= '2018-09-30'::date))
  • Rows Removed by Filter: 1
65. 1.926 1.926 ↑ 1.0 1 642

Index Only Scan using store_item_mas_indx on store_item_details m (cost=0.41..1.73 rows=1 width=62) (actual time=0.003..0.003 rows=1 loops=642)

  • Index Cond: (medicine_id = s.medicine_id)
  • Heap Fetches: 4
66. 0.000 0.000 ↓ 0.0 0 642

Index Scan using doctors_pkey on doctors predoc_1 (cost=0.28..2.80 rows=1 width=30) (actual time=0.000..0.000 rows=0 loops=642)

  • Index Cond: ((doctor_id)::text = (bc.prescribing_dr_id)::text)
67. 5.136 5.136 ↑ 1.0 1 642

Index Scan using patient_registration_pkey on patient_registration pr_1 (cost=0.43..4.80 rows=1 width=61) (actual time=0.007..0.008 rows=1 loops=642)

  • Index Cond: ((patient_id)::text = (b_1.visit_id)::text)
68. 4.494 4.494 ↑ 1.0 1 642

Index Only Scan using patient_details_pkey on patient_details pd_1 (cost=0.43..1.77 rows=1 width=15) (actual time=0.007..0.007 rows=1 loops=642)

  • Index Cond: (mr_no = (pr_1.mr_no)::text)
  • Heap Fetches: 23
69. 0.000 11.556 ↑ 1.0 1 642

Nested Loop Left Join (cost=1.14..7.58 rows=1 width=24) (actual time=0.018..0.018 rows=1 loops=642)

70. 0.642 7.704 ↑ 1.0 1 642

Nested Loop (cost=0.71..4.44 rows=1 width=24) (actual time=0.011..0.012 rows=1 loops=642)

71. 5.136 5.136 ↑ 1.0 1 642

Index Scan using patient_insurance_plans_patient_id on patient_insurance_plans pri_plan_1 (cost=0.43..3.13 rows=1 width=38) (actual time=0.008..0.008 rows=1 loops=642)

  • Index Cond: ((patient_id)::text = (pr_1.patient_id)::text)
  • Filter: (priority = 1)
72. 1.926 1.926 ↑ 1.0 1 642

Index Only Scan using tpa_master_pkey on tpa_master pri_tm_1 (cost=0.28..1.30 rows=1 width=10) (actual time=0.003..0.003 rows=1 loops=642)

  • Index Cond: (tpa_id = (pri_plan_1.sponsor_id)::text)
  • Heap Fetches: 0
73. 3.852 3.852 ↓ 0.0 0 642

Index Scan using patient_insurance_plans_patient_id on patient_insurance_plans sec_plan_1 (cost=0.43..3.13 rows=1 width=38) (actual time=0.006..0.006 rows=0 loops=642)

  • Index Cond: ((pri_plan_1.patient_id)::text = (patient_id)::text)
  • Filter: (priority = 2)
  • Rows Removed by Filter: 1
74. 1.284 1.284 ↑ 1.0 1 642

Index Scan using department_pkey on department admdep_1 (cost=0.14..0.16 rows=1 width=20) (actual time=0.002..0.002 rows=1 loops=642)

  • Index Cond: ((dept_id)::text = (pr_1.admitted_dept)::text)
75. 2.568 2.568 ↑ 1.0 1 642

Index Scan using doctors_pkey on doctors dr_1 (cost=0.28..2.80 rows=1 width=30) (actual time=0.004..0.004 rows=1 loops=642)

  • Index Cond: ((doctor_id)::text = (pr_1.doctor)::text)
76. 1.926 1.926 ↑ 1.0 1 642

Index Scan using tpa_master_pkey on tpa_master ptpa_1 (cost=0.28..2.38 rows=1 width=33) (actual time=0.003..0.003 rows=1 loops=642)

  • Index Cond: ((tpa_id)::text = (pr_1.primary_sponsor_id)::text)
77. 1.926 1.926 ↑ 1.0 1 642

Index Scan using insurance_company_master_pkey on insurance_company_master picm_1 (cost=0.28..2.16 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=642)

  • Index Cond: ((insurance_co_id)::text = (pri_plan_1.insurance_co)::text)
78. 1.284 1.284 ↓ 0.0 0 642

Index Scan using center_pkey on hospital_center_master hcm_1 (cost=0.14..1.16 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=642)

  • Index Cond: (center_id = pr_1.center_id)
  • Filter: ((center_name)::text = 'NMCAbuDhabi'::text)
  • Rows Removed by Filter: 1
79. 0.144 0.144 ↑ 1.0 1 36

Index Scan using insurance_denial_codes_pkey on insurance_denial_codes pidc_1 (cost=0.28..2.53 rows=1 width=36) (actual time=0.004..0.004 rows=1 loops=36)

  • Index Cond: ((denial_code)::text = (pscl.denial_code)::text)
80. 0.432 0.432 ↑ 5.0 1 36

Index Scan using mrd_diagnosis_visit_index on mrd_diagnosis pdiag_1 (cost=0.56..21.89 rows=5 width=50) (actual time=0.011..0.012 rows=1 loops=36)

  • Index Cond: ((visit_id)::text = (pr_1.patient_id)::text)
  • Filter: (diag_type = 'P'::bpchar)
  • Rows Removed by Filter: 2
81.          

SubPlan (forNested Loop Left Join)

82. 0.144 0.360 ↑ 1.0 1 36

Aggregate (cost=8.46..8.46 rows=1 width=10) (actual time=0.010..0.010 rows=1 loops=36)

83. 0.216 0.216 ↑ 1.0 1 36

Index Scan using sales_claim_sale_item_idx on sales_claim_details scd1 (cost=0.43..8.45 rows=1 width=10) (actual time=0.006..0.006 rows=1 loops=36)

  • Index Cond: (sale_item_id = s.sale_item_id)
  • Filter: ((claim_id)::text = (pbcl_1.claim_id)::text)
84. 0.108 0.180 ↑ 1.0 1 36

Aggregate (cost=8.45..8.46 rows=1 width=7) (actual time=0.005..0.005 rows=1 loops=36)

85. 0.072 0.072 ↑ 1.0 1 36

Index Scan using sales_claim_sale_item_idx on sales_claim_details scd1_1 (cost=0.43..8.45 rows=1 width=7) (actual time=0.002..0.002 rows=1 loops=36)

  • Index Cond: (sale_item_id = s.sale_item_id)
  • Filter: ((claim_id)::text = (pbcl_1.claim_id)::text)