explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 43ju

Settings
# exclusive inclusive rows x rows loops node
1. 0.397 14,883.573 ↓ 569.0 569 1

Sort (cost=27,149.48..27,149.49 rows=1 width=445) (actual time=14,883.463..14,883.573 rows=569 loops=1)

  • Sort Key: ((SubPlan 3)), refrqst_t.refl_rqst_uid
  • Sort Method: quicksort Memory: 330kB
2. 1.995 14,883.176 ↓ 569.0 569 1

Sort (cost=27,149.46..27,149.46 rows=1 width=445) (actual time=14,883.054..14,883.176 rows=569 loops=1)

  • Sort Key: refrqst_t.refl_rqst_uid
  • Sort Method: quicksort Memory: 330kB
3.          

Initplan (for Sort)

4. 0.002 0.018 ↑ 1.0 1 1

Limit (cost=0.56..16.60 rows=1 width=4) (actual time=0.016..0.018 rows=1 loops=1)

5. 0.002 0.016 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.56..16.60 rows=1 width=4) (actual time=0.015..0.016 rows=1 loops=1)

6. 0.006 0.006 ↑ 1.0 1 1

Index Scan using ixpk_userorganization_t on userorganization_t userorganization_t_4 (cost=0.28..8.30 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (user_org_uid = 225)
7. 0.008 0.008 ↑ 1.0 1 1

Index Scan using ixpk_organization_t on organization_t organization_t_3 (cost=0.28..8.30 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (org_uid = userorganization_t_4.org_uid)
8. 10.715 14,881.163 ↓ 569.0 569 1

Nested Loop (cost=10,549.84..27,132.84 rows=1 width=445) (actual time=137.439..14,881.163 rows=569 loops=1)

  • Join Filter: (NOT (SubPlan 8))
9. 0.003 0.019 ↑ 1.0 1 1

Nested Loop (cost=0.56..16.60 rows=1 width=6) (actual time=0.018..0.019 rows=1 loops=1)

10. 0.010 0.010 ↑ 1.0 1 1

Index Scan using ixpk_userorganization_t on userorganization_t userorganization_t_2 (cost=0.28..8.30 rows=1 width=4) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: (user_org_uid = 225)
11. 0.006 0.006 ↑ 1.0 1 1

Index Scan using ixpk_dcpsuser_t on dcpsuser_t dcpsuser_t_1 (cost=0.28..8.30 rows=1 width=10) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (user_uid = userorganization_t_2.user_uid)
12. 1.712 155.520 ↓ 569.0 569 1

Hash Join (cost=10,549.28..23,265.48 rows=1 width=292) (actual time=107.384..155.520 rows=569 loops=1)

  • Hash Cond: (dcpscase_t.dcps_case_uid = "pendingCases".dcps_case_uid)
13. 23.050 53.275 ↓ 284.5 569 1

Nested Loop (cost=1,179.74..13,895.26 rows=2 width=292) (actual time=6.826..53.275 rows=569 loops=1)

  • Join Filter: (userorganization_t_1.org_uid = organization_t.org_uid)
  • Rows Removed by Join Filter: 91286
14. 2.877 11.220 ↓ 3.7 2,715 1

Nested Loop (cost=1,179.74..13,721.34 rows=736 width=296) (actual time=6.054..11.220 rows=2,715 loops=1)

15. 0.011 0.011 ↑ 1.0 1 1

Seq Scan on prcstuscd_t (cost=0.00..1.40 rows=1 width=24) (actual time=0.007..0.011 rows=1 loops=1)

  • Filter: ((prc_stus_cd)::text = 'INIT'::text)
  • Rows Removed by Filter: 31
16. 0.000 8.332 ↓ 3.7 2,715 1

Gather (cost=1,179.74..13,712.58 rows=736 width=277) (actual time=6.044..8.332 rows=2,715 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
17. 1.511 24.525 ↓ 3.1 1,358 2

Hash Join (cost=179.74..12,638.98 rows=433 width=277) (actual time=2.432..24.525 rows=1,358 loops=2)

  • Hash Cond: (userorganization_t.user_uid = dcpsuser_t.user_uid)
18. 3.372 21.108 ↓ 3.1 1,358 2

Nested Loop (cost=79.71..12,537.82 rows=433 width=262) (actual time=0.485..21.108 rows=1,358 loops=2)

19. 1.085 17.735 ↓ 3.1 1,358 2

Hash Join (cost=79.43..12,354.23 rows=433 width=258) (actual time=0.476..17.735 rows=1,358 loops=2)

  • Hash Cond: ((refrqst_t.refl_evaln_cd)::text = (refevlcd_t.refl_evaln_cd)::text)
20. 1.106 16.633 ↓ 3.1 1,358 2

Hash Join (cost=78.25..12,351.41 rows=433 width=242) (actual time=0.436..16.633 rows=1,358 loops=2)

  • Hash Cond: ((refrqst_t.refl_rqst_cd)::text = (refrqstcd_t.refl_rqst_cd)::text)
21. 4.466 15.494 ↓ 3.1 1,358 2

Nested Loop (cost=76.37..12,348.27 rows=433 width=226) (actual time=0.390..15.494 rows=1,358 loops=2)

  • -> Index Scan using ixpk_userorganization_t on userorganization_t userorganization_t_1 (cost=0.28..0.31 rows=1 width=8) (actual time=0.002..0.002
22. 9.434 11.028 ↓ 3.1 1,358 2

Nested Loop (cost=76.09..12,213.71 rows=434 width=222) (actual time=0.378..11.028 rows=1,358 loops=2)

  • Index Cond: (user_org_uid = dcpscase_t.asgnd_user_org_uid)
23. 1.017 1.589 ↑ 1.3 1,358 2

Parallel Bitmap Heap Scan on refrqst_t (cost=75.67..4,370.05 rows=1,765 width=178) (actual time=0.356..1.589 rows=1,358 loops=2)

  • Recheck Cond: ((refl_stus_cd)::text = 'INIT'::text)
  • Heap Blocks: exact=8
24. 0.572 0.572 ↓ 1.4 4,282 1

Bitmap Index Scan on ixn01_refrqst_t (cost=0.00..74.92 rows=3,000 width=0) (actual time=0.571..0.572 rows=4,282 loops=1)

  • Index Cond: ((refl_stus_cd)::text = 'INIT'::text)
25. 0.005 0.005 ↑ 1.0 1 2,716

Index Scan using ixpk_dcpscase_t on dcpscase_t (cost=0.42..4.44 rows=1 width=44) (actual time=0.005..0.005 rows=1 loops=2,716)

  • Index Cond: (dcps_case_uid = refrqst_t.dcps_case_uid)
  • Filter: ((case_stus_cd)::text <> '4'::text)
  • Rows Removed by Filter: 0
26. 0.017 0.033 ↑ 1.0 39 2

Hash (cost=1.39..1.39 rows=39 width=20) (actual time=0.033..0.033 rows=39 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
27. 0.016 0.016 ↑ 1.0 39 2

Seq Scan on refrqstcd_t (cost=0.00..1.39 rows=39 width=20) (actual time=0.005..0.016 rows=39 loops=2)

28. 0.009 0.017 ↑ 1.0 8 2

Hash (cost=1.08..1.08 rows=8 width=21) (actual time=0.016..0.017 rows=8 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
29. 0.008 0.008 ↑ 1.0 8 2

Seq Scan on refevlcd_t (cost=0.00..1.08 rows=8 width=21) (actual time=0.006..0.008 rows=8 loops=2)

30. 0.001 0.001 ↑ 1.0 1 2,715

Index Scan using ixpk_userorganization_t on userorganization_t (cost=0.28..0.42 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=2,715)

  • Index Cond: (user_org_uid = refrqst_t.rqstd_by_user_org_uid)
31. 1.025 1.906 ↓ 1.0 2,406 2

Hash (cost=70.01..70.01 rows=2,401 width=19) (actual time=1.906..1.906 rows=2,406 loops=2)

  • Buckets: 4096 Batches: 1 Memory Usage: 153kB
32. 0.881 0.881 ↓ 1.0 2,406 2

Seq Scan on dcpsuser_t (cost=0.00..70.01 rows=2,401 width=19) (actual time=0.010..0.881 rows=2,406 loops=2)

33. 18.446 19.005 ↓ 4.9 34 2,715

Materialize (cost=0.00..96.66 rows=7 width=4) (actual time=0.000..0.007 rows=34 loops=2,715)

34. 0.559 0.559 ↓ 5.0 35 1

Seq Scan on organization_t (cost=0.00..96.62 rows=7 width=4) (actual time=0.070..0.559 rows=35 loops=1)

  • Filter: (site_org_uid = $11)
  • Rows Removed by Filter: 2655
35. 1.521 100.533 ↓ 1.7 4,476 1

Hash (cost=9,336.49..9,336.49 rows=2,644 width=4) (actual time=100.533..100.533 rows=4,476 loops=1)

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 222kB
36. 1.949 99.012 ↓ 1.7 4,476 1

Subquery Scan on pendingCases (cost=9,283.61..9,336.49 rows=2,644 width=4) (actual time=95.611..99.012 rows=4,476 loops=1)

37. 4.361 97.063 ↓ 1.7 4,476 1

HashAggregate (cost=9,283.61..9,310.05 rows=2,644 width=8) (actual time=95.610..97.063 rows=4,476 loops=1)

  • Group Key: dcpscase_t_1.dcps_case_uid, caseclm_t.juris_ocd
38. 48.754 92.702 ↓ 2.3 5,950 1

Hash Join (cost=2,661.93..9,270.39 rows=2,644 width=8) (actual time=23.422..92.702 rows=5,950 loops=1)

  • Hash Cond: (dcpscase_t_1.dcps_case_uid = caseclm_t.dcps_case_uid)
39. 20.635 20.635 ↓ 1.0 37,126 1

Index Scan using ixf02_case on dcpscase_t dcpscase_t_1 (cost=0.42..6,443.67 rows=37,004 width=4) (actual time=0.022..20.635 rows=37,126 loops=1)

  • Index Cond: ((case_stus_cd)::text = '5'::text)
40. 2.075 23.313 ↑ 1.8 5,950 1

Hash (cost=2,527.05..2,527.05 rows=10,757 width=8) (actual time=23.312..23.313 rows=5,950 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 361kB
41. 5.080 21.238 ↑ 1.8 5,950 1

Nested Loop (cost=18.42..2,527.05 rows=10,757 width=8) (actual time=0.073..21.238 rows=5,950 loops=1)

42. 0.004 0.049 ↑ 8.0 1 1

HashAggregate (cost=18.00..18.08 rows=8 width=3) (actual time=0.048..0.049 rows=1 loops=1)

  • Group Key: (organization_t_2.ofc_cd)::text
43. 0.025 0.045 ↑ 8.0 1 1

Nested Loop (cost=0.84..17.98 rows=8 width=3) (actual time=0.042..0.045 rows=1 loops=1)

  • -> Index Scan using ixb01_orgainzation_t on organization_t organization_t_2 (cost=0.28..1.35 rows=3 width=6) (actual time=0.021..0.022 rows=1 loop
44. 0.020 0.020 ↑ 1.0 1 1

Nested Loop (cost=0.56..16.60 rows=1 width=3) (actual time=0.019..0.020 rows=1 loops=1)

  • -> Index Scan using ixpk_userorganization_t on userorganization_t userorganization_t_3 (cost=0.28..8.30 rows=1 width=4) (actual time=0.011..
  • Index Cond: (user_org_uid = 225)
  • -> Index Scan using ixpk_organization_t on organization_t organization_t_1 (cost=0.28..8.30 rows=1 width=7) (actual time=0.005..0.006 rows=1
  • Index Cond: (org_uid = userorganization_t_3.org_uid)
  • Index Cond: ((st_cd)::text = (organization_t_1.st_cd)::text)
  • Filter: ((org_typ_cd)::text = 'A'::text)
  • Rows Removed by Filter: 36
45. 16.109 16.109 ↓ 4.7 5,950 1

Index Scan using ixf04_jurisocd on caseclm_t (cost=0.42..301.02 rows=1,260 width=8) (actual time=0.022..16.109 rows=5,950 loops=1)

  • Index Cond: ((juris_ocd)::text = (organization_t_2.ofc_cd)::text)
  • Filter: ((clm_stus_cd)::text = '5'::text)
  • Rows Removed by Filter: 23623
46.          

SubPlan (for Nested Loop)

47. 3.414 14,596.557 ↑ 1.0 1 569

Limit (cost=3,718.02..3,718.03 rows=1 width=8) (actual time=25.648..25.653 rows=1 loops=569)

48. 1.138 14,593.143 ↑ 1.0 1 569

Aggregate (cost=3,718.02..3,718.03 rows=1 width=8) (actual time=25.647..25.647 rows=1 loops=569)

49. 1.928 14,592.005 ↓ 0.0 0 569

Nested Loop (cost=13.50..3,718.02 rows=1 width=0) (actual time=25.598..25.645 rows=0 loops=569)

50. 3,004.320 12,189.687 ↑ 1.0 1 569

Nested Loop (cost=13.08..1,632.61 rows=1 width=4) (actual time=20.802..21.423 rows=1 loops=569)

  • Join Filter: (commrcpnt_t.prc_comm_uid = prccomm_t.prc_comm_uid)
  • Rows Removed by Join Filter: 24773
51. 5.121 5.121 ↑ 1.0 1 569

Index Scan using ixn02_prccomm_t on prccomm_t (cost=0.42..8.44 rows=1 width=4) (actual time=0.007..0.009 rows=1 loops=569)

  • Index Cond: (prnt_prc_id = refrqst_t.refl_rqst_uid)
  • Filter: ((prc_typ_cd)::text = 'REFL'::text)
  • Rows Removed by Filter: 0
52. 8,245.948 9,180.246 ↓ 45.6 24,774 569

Bitmap Heap Scan on commrcpnt_t (cost=12.66..1,617.38 rows=543 width=8) (actual time=2.226..16.134 rows=24,774 loops=569)

  • Recheck Cond: (rcpnt_user_org_uid = refrqst_t.assgnd_to_user_org_uid)
  • Filter: ((comm_rcv_sw)::text = 'Y'::text)
  • Heap Blocks: exact=2644143
53. 934.298 934.298 ↓ 45.4 24,774 569

Bitmap Index Scan on ixn01_commrcpnt_t (cost=0.00..12.52 rows=546 width=0) (actual time=1.642..1.642 rows=24,774 loops=569)

  • Index Cond: (rcpnt_user_org_uid = refrqst_t.assgnd_to_user_org_uid)
54. 2,400.390 2,400.390 ↓ 0.0 0 537

Index Scan using pkey_comrcpatvt_pkey on comrcpatvt_t (cost=0.42..2,085.40 rows=1 width=4) (actual time=4.458..4.470 rows=0 loops=537)

  • Index Cond: (comm_rcpnt_uid = commrcpnt_t.comm_rcpnt_uid)
  • Filter: ((comm_read_sw)::text = 'N'::text)
55. 1.138 15.932 ↑ 1.0 1 569

Aggregate (cost=12.24..12.25 rows=1 width=32) (actual time=0.028..0.028 rows=1 loops=569)

56. 1.138 14.794 ↓ 0.0 0 569

Subquery Scan on t (cost=12.22..12.23 rows=1 width=29) (actual time=0.026..0.026 rows=0 loops=569)

57. 2.845 13.656 ↓ 0.0 0 569

Sort (cost=12.22..12.22 rows=1 width=37) (actual time=0.024..0.024 rows=0 loops=569)

  • Sort Key: splhdgcd_t_1.sort_ord_num
  • Sort Method: quicksort Memory: 25kB
58. 0.569 10.811 ↓ 0.0 0 569

Nested Loop (cost=8.94..12.21 rows=1 width=37) (actual time=0.019..0.019 rows=0 loops=569)

59. 1.707 10.242 ↓ 0.0 0 569

Nested Loop Left Join (cost=8.80..11.74 rows=1 width=27) (actual time=0.018..0.018 rows=0 loops=569)

60. 3.407 8.535 ↓ 0.0 0 569

Hash Join (cost=8.66..11.35 rows=1 width=19) (actual time=0.015..0.015 rows=0 loops=569)

  • Hash Cond: ((splhdgcd_t.splhdg_cd)::text = (cssplhdg_t.splhdg_cd)::text)
61. 0.007 0.007 ↑ 54.0 1 1

Seq Scan on splhdgcd_t (cost=0.00..2.54 rows=54 width=16) (actual time=0.007..0.007 rows=1 loops=1)

62. 1.138 5.121 ↓ 0.0 0 569

Hash (cost=8.65..8.65 rows=1 width=3) (actual time=0.009..0.009 rows=0 loops=569)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
63. 3.983 3.983 ↓ 0.0 0 569

Index Scan using ix_cssplhdg_t_dcps_case_uid on cssplhdg_t (cost=0.42..8.65 rows=1 width=3) (actual time=0.007..0.007 rows=0 loops=569)

  • Index Cond: (dcps_case_uid = dcpscase_t.dcps_case_uid)
  • Filter: ((splhdg_cd)::text = ANY ('{QD,CL,29,31,38}'::text[]))
  • Rows Removed by Filter: 0
64. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpk_splhdglbl on splhdglbl_t (cost=0.14..0.38 rows=1 width=11) (never executed)

  • Index Cond: ((splhdgcd_t.splhdg_cd)::text = (splhdg_cd)::text)
65. 0.000 0.000 ↓ 0.0 0

Index Scan using splhdgcd_pkey on splhdgcd_t splhdgcd_t_1 (cost=0.14..0.45 rows=1 width=5) (never executed)

  • Index Cond: ((splhdg_cd)::text = (splhdgcd_t.splhdg_cd)::text)
66. 0.569 7.966 ↑ 1.0 1 569

Aggregate (cost=11.85..11.86 rows=1 width=32) (actual time=0.014..0.014 rows=1 loops=569)

67. 0.569 7.397 ↓ 0.0 0 569

Subquery Scan on t_1 (cost=11.83..11.84 rows=1 width=26) (actual time=0.013..0.013 rows=0 loops=569)

68. 1.138 6.828 ↓ 0.0 0 569

Limit (cost=11.83..11.83 rows=1 width=2) (actual time=0.012..0.012 rows=0 loops=569)

69. 0.569 5.690 ↓ 0.0 0 569

Sort (cost=11.83..11.83 rows=1 width=2) (actual time=0.010..0.010 rows=0 loops=569)

  • Sort Key: splhdgcd_t_3.sort_ord_num
  • Sort Method: quicksort Memory: 25kB
70. 1.138 5.121 ↓ 0.0 0 569

Nested Loop (cost=8.80..11.82 rows=1 width=2) (actual time=0.009..0.009 rows=0 loops=569)

71. 2.274 3.983 ↓ 0.0 0 569

Hash Join (cost=8.66..11.35 rows=1 width=6) (actual time=0.007..0.007 rows=0 loops=569)

  • Hash Cond: ((splhdgcd_t_2.splhdg_cd)::text = (cssplhdg_t_1.splhdg_cd)::text)
72. 0.002 0.002 ↑ 54.0 1 1

Seq Scan on splhdgcd_t splhdgcd_t_2 (cost=0.00..2.54 rows=54 width=3) (actual time=0.002..0.002 rows=1 loops=1)

73. 0.569 1.707 ↓ 0.0 0 569

Hash (cost=8.65..8.65 rows=1 width=3) (actual time=0.003..0.003 rows=0 loops=569)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
74. 1.138 1.138 ↓ 0.0 0 569

Index Scan using ix_cssplhdg_t_dcps_case_uid on cssplhdg_t cssplhdg_t_1 (cost=0.42..8.65 rows=1 width=3) (actual time=0.002..0.002 rows=0 loops=569)

  • Index Cond: (dcps_case_uid = dcpscase_t.dcps_case_uid)
  • Filter: ((splhdg_cd)::text = ANY ('{QD,CL,29,31,38}'::text[]))
  • Rows Removed by Filter: 0
75. 0.000 0.000 ↓ 0.0 0

Index Scan using splhdgcd_pkey on splhdgcd_t splhdgcd_t_3 (cost=0.14..0.45 rows=1 width=5) (never executed)

  • Index Cond: ((splhdg_cd)::text = (splhdgcd_t_2.splhdg_cd)::text)
76. 12.518 17.070 ↑ 1.0 1 569

Aggregate (cost=8.44..8.45 rows=1 width=32) (actual time=0.030..0.030 rows=1 loops=569)

77. 4.552 4.552 ↑ 1.0 1 569

Index Scan using ixf01_caseclm on caseclm_t caseclm_t_1 (cost=0.42..8.44 rows=1 width=15) (actual time=0.007..0.008 rows=1 loops=569)

  • Index Cond: (dcps_case_uid = dcpscase_t.dcps_case_uid)
78. 1.707 6.828 ↑ 1.0 1 569

Limit (cost=8.45..8.45 rows=1 width=12) (actual time=0.011..0.012 rows=1 loops=569)

79. 2.276 5.121 ↑ 1.0 1 569

Sort (cost=8.45..8.45 rows=1 width=12) (actual time=0.009..0.009 rows=1 loops=569)

  • Sort Key: caseclm_t_2.clm_sub_stus_ts DESC
  • Sort Method: quicksort Memory: 25kB
80. 2.845 2.845 ↑ 1.0 1 569

Index Scan using ixf01_caseclm on caseclm_t caseclm_t_2 (cost=0.42..8.44 rows=1 width=12) (actual time=0.004..0.005 rows=1 loops=569)

  • Index Cond: (dcps_case_uid = dcpscase_t.dcps_case_uid)
81. 0.000 70.556 ↑ 100.0 1 569

HashAggregate (cost=90.96..92.21 rows=100 width=32) (actual time=0.124..0.124 rows=1 loops=569)

  • Group Key: unnest($22)
82.          

Initplan (for HashAggregate)

83. 1.707 66.004 ↑ 1.0 1 569

Subquery Scan on x (cost=90.15..90.19 rows=1 width=32) (actual time=0.115..0.116 rows=1 loops=569)

84. 5.121 64.297 ↑ 1.0 1 569

Aggregate (cost=90.15..90.16 rows=1 width=64) (actual time=0.113..0.113 rows=1 loops=569)

85. 1.369 59.176 ↑ 3.0 1 569

Nested Loop Left Join (cost=3.09..90.13 rows=3 width=14) (actual time=0.076..0.104 rows=1 loops=569)

  • Filter: (((anlysgnr_t.sgnr_pin IS NOT NULL) AND (anlysgnr_t.sgnr_deld_pin IS NULL) AND (((anlysgnr_t.sgnr_typ_cd)::text = ANY ('{EXNR,OMED}'::text[])) OR (((asmt_t.asmt_typ_c
  • Rows Removed by Filter: 1
86. 2.046 54.624 ↑ 1.5 2 569

Nested Loop Left Join (cost=2.67..88.32 rows=3 width=60) (actual time=0.071..0.096 rows=2 loops=569)

  • Join Filter: (anlysgnr_t_1.case_anl_uid = caseanly_t.case_anl_uid)
87. 1.374 49.503 ↑ 1.5 2 569

Nested Loop Left Join (cost=2.25..86.68 rows=3 width=54) (actual time=0.068..0.087 rows=2 loops=569)

88. 0.934 46.089 ↓ 0.0 0 569

Nested Loop Left Join (cost=1.83..85.82 rows=1 width=27) (actual time=0.065..0.081 rows=0 loops=569)

89. 1.578 44.951 ↓ 0.0 0 569

Nested Loop Left Join (cost=1.54..85.44 rows=1 width=17) (actual time=0.063..0.079 rows=0 loops=569)

  • Join Filter: (asmt_t_1.asmt_uid = cde_t.asmt_uid)
  • Rows Removed by Join Filter: 1
90. 0.913 41.537 ↓ 0.0 0 569

Nested Loop Left Join (cost=1.12..84.31 rows=1 width=12) (actual time=0.059..0.073 rows=0 loops=569)

91. 7.736 9.104 ↓ 0.0 0 569

Nested Loop (cost=0.84..16.89 rows=1 width=4) (actual time=0.015..0.016 rows=0 loops=569)

  • -> Index Scan using ixn01_dcpscase_t on dcpscase_t dcpscase_t_2 (cost=0.42..8.44 rows=1 width=4) (actual time=0.011..0.011 rows=0 loops=
  • Index Cond: (fldr_num = dcpscase_t.fldr_num)
  • Filter: (dcps_case_uid <> dcpscase_t.dcps_case_uid)
  • Rows Removed by Filter: 1
92. 1.368 1.368 ↑ 1.0 1 152

Index Scan using ixn01_caseanly_t on caseanly_t (cost=0.42..8.44 rows=1 width=8) (actual time=0.008..0.009 rows=1 loops=152)

  • Index Cond: (dcps_case_uid = dcpscase_t_2.dcps_case_uid)
  • Filter: ((deld_by_pin IS NULL) AND ((anl_stus_cd)::text = 'CLSD'::text))
  • Rows Removed by Filter: 0
93. 31.520 31.520 ↓ 0.0 0 197

Index Scan using ixf01_cde_t on cde_t (cost=0.29..67.41 rows=1 width=12) (actual time=0.158..0.160 rows=0 loops=197)

  • Index Cond: (case_anl_uid = caseanly_t.case_anl_uid)
94. 1.836 1.836 ↑ 1.0 2 204

Index Scan using ixu01_asmt on asmt_t asmt_t_1 (cost=0.42..1.11 rows=2 width=17) (actual time=0.007..0.009 rows=2 loops=204)

  • Index Cond: (case_anl_uid = caseanly_t.case_anl_uid)
95. 0.204 0.204 ↓ 0.0 0 204

Index Scan using ixf01_cdesgnr_t on cdesgnr_t (cost=0.29..0.37 rows=1 width=18) (actual time=0.001..0.001 rows=0 loops=204)

  • Index Cond: (cde_uid = cde_t.cde_uid)
96. 2.040 2.040 ↑ 1.0 5 204

Index Scan using ixpk_anlysgnr on anlysgnr_t (cost=0.42..0.81 rows=5 width=31) (actual time=0.006..0.010 rows=5 loops=204)

  • Index Cond: (case_anl_uid = caseanly_t.case_anl_uid)
97. 3.075 3.075 ↓ 0.0 0 1,025

Index Scan using ixn01_anlysgnr_t on anlysgnr_t anlysgnr_t_1 (cost=0.42..0.53 rows=1 width=26) (actual time=0.003..0.003 rows=0 loops=1,025)

  • Index Cond: (asmt_uid = anlysgnr_t.asmt_uid)
  • Filter: ((sgnr_pin IS NULL) AND (sgnr_uid <> anlysgnr_t.sgnr_uid))
  • Rows Removed by Filter: 1
98. 3.183 3.183 ↑ 1.0 1 1,061

Index Scan using ixpk_asmt on asmt_t (cost=0.42..0.59 rows=1 width=17) (actual time=0.002..0.003 rows=1 loops=1,061)

  • Index Cond: (asmt_uid = anlysgnr_t.asmt_uid)
99. 68.280 68.849 ↑ 100.0 1 569

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.121..0.121 rows=1 loops=569)

100. 0.569 0.569 ↑ 1.0 1 569

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.001 rows=1 loops=569)

Planning time : 28.141 ms
Execution time : 14,885.425 ms