explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mG7

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Unique (cost=0..0 rows=0 width=0) (never executed)

2. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: cvri.rel_info_id, cvri.tsn_id, b.info_type_id, c.description, (((b.filer_name)::text || CASE WHEN (b.filer_tan IS NULL) THEN ''::text ELSE CASE WHEN (length(regexp_replace5("substring"((b.filer_tan)::text, 5, 1), '[^0-9]'::text, ''::text, NULL::text, true)) = 0) THEN ((' (Filer PAN: '::text || (b.filer_tan)::text) || ')'::text) ELSE ((' (Filer TAN: '::text || (b.filer_tan)::text) || ')'::text) END END)), b.trans_amount, ris.status_id, ris.description, cvid.verif_id, cvid.verif_seq_id, vic.description, c.info_group, cvri.info_aware_flag, ivtl.verif_type_id, cvri.case_seq_id, ci.case_id, b.parent_tsn_id, e.revision_type, riraw.aprvl_seq_id, riraw.submitted_for_aprvl, riraw.approved_flag, riraw.approver_reverif_flag, riraw.info_result_code_id, riraw.reviewer_remarks, riraw.approver_remarks, b.info_flag, svs.sys_status_id, svs.description, b.info_pan, (CASE WHEN ((b.info_pan_type)::text = 'I'::text) THEN 'Yes'::text ELSE 'No'::text END), b.src_mstr_id, b.src_sub_mstr_id, b.src_business_id, info_sft_acnt_trans_dtls.acnt_nmbr, x.info_aware_flag, b_1.tot_civ_amount, c_1.remarks, b.filer_name, b.trans_amount, b.key_identifier, b.run_seq_num, b.disseminated_flag
3. 0.000 0.000 ↓ 0.0

Append (cost=0..0 rows=0 width=0) (never executed)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

6. 0.000 0.000 ↓ 0.0

Seq Scan on sys_rel_info_status_lkp svs (cost=0..0 rows=0 width=0) (never executed)

7. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

9. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0..0 rows=0 width=0) (never executed)

  • Group Key: x.rel_info_resp_id, x.rel_info_id, x.info_aware_flag, b_1.tot_civ_amount, c_1.remarks, x.create_date
10. 0.000 0.000 ↓ 0.0

Append (cost=0..0 rows=0 width=0) (never executed)

11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

13. 0.000 0.000 ↓ 0.0

Subquery Scan on x (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (((x.info_aware_flag)::text = 'Y'::text) AND (x.top1 = 1))
14. 0.000 0.000 ↓ 0.0

WindowAgg (cost=0..0 rows=0 width=0) (never executed)

15. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: case_verif_rel_info_resp.rel_info_id, case_verif_rel_info_resp.create_date DESC
16. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on case_verif_rel_info_resp case_verif_rel_info_resp (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((trans_status)::text = 'S'::text)
17. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on case_verif_rel_info_resp_verif_type_id_idx (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((verif_type_id)::text = ANY ('{SF,SFTI}'::text[]))
18. 0.000 0.000 ↓ 0.0

Index Scan using info_resp_sf_comp_val_rel_info_resp_id_idx on info_resp_sf_comp_val b_1 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (rel_info_resp_id = x.rel_info_resp_id)
  • Filter: ((trans_status)::text = 'S'::text)
19. 0.000 0.000 ↓ 0.0

Index Scan using info_resp_sf_civ_grp_trans_id_idx on info_resp_sf_civ c_1 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (grp_trans_id = b_1.trans_id)
20. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

21. 0.000 0.000 ↓ 0.0

Seq Scan on info_resp_tt_rcpt c_1_1 (cost=0..0 rows=0 width=0) (never executed)

22. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

23. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

24. 0.000 0.000 ↓ 0.0

Seq Scan on info_resp_tt_comp_val b_1_1 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((trans_status)::text = 'S'::text)
25. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

26. 0.000 0.000 ↓ 0.0

Subquery Scan on y (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (((y.info_aware_flag)::text = 'Y'::text) AND (y.top1 = 1))
27. 0.000 0.000 ↓ 0.0

WindowAgg (cost=0..0 rows=0 width=0) (never executed)

28. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: case_verif_rel_info_resp_1.rel_info_id, case_verif_rel_info_resp_1.create_date DESC
29. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on case_verif_rel_info_resp case_verif_rel_info_resp_1 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((trans_status)::text = 'S'::text)
30. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on case_verif_rel_info_resp_verif_type_id_idx (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((verif_type_id)::text = ANY ('{TT,TTSP}'::text[]))
31. 0.000 0.000 ↓ 0.0

Subquery Scan on x_1 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (((x_1.info_aware_flag)::text = 'N'::text) AND (x_1.top1 = 1))
32. 0.000 0.000 ↓ 0.0

WindowAgg (cost=0..0 rows=0 width=0) (never executed)

33. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: case_verif_rel_info_resp_2.rel_info_id, case_verif_rel_info_resp_2.create_date DESC
34. 0.000 0.000 ↓ 0.0

Seq Scan on case_verif_rel_info_resp case_verif_rel_info_resp_2 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((trans_status)::text = 'S'::text)
35. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

36. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

37. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

38. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

39. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

40. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

41. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

42. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

43. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

44. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

45. 0.000 0.000 ↓ 0.0

Index Scan using case_verif_rel_info_tsn_id_idx on case_verif_rel_info cvri (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (tsn_id = '1119003802678'::bigint)
46. 0.000 0.000 ↓ 0.0

Index Scan using xpkcase_verif_issue_detail on case_verif_issue_detail cvid (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (verif_seq_id = cvri.verif_seq_id)
47. 0.000 0.000 ↓ 0.0

Index Scan using xpkcase_info on case_info ci (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (case_seq_id = cvid.case_seq_id)
48. 0.000 0.000 ↓ 0.0

Index Scan using xpkcase_verif_issue_code on verif_issue_code vic (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((issue_id)::text = (cvid.issue_id)::text)
49. 0.000 0.000 ↓ 0.0

Seq Scan on rel_info_status ris (cost=0..0 rows=0 width=0) (never executed)

50. 0.000 0.000 ↓ 0.0

Index Scan using xpkinfo_dtls on info_dtls b (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (tsn_id = '1119003802678'::bigint)
51. 0.000 0.000 ↓ 0.0

Index Scan using xpkcase_verif_rel_info_type on info_type c (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((info_type_id)::text = (b.info_type_id)::text)
52. 0.000 0.000 ↓ 0.0

Seq Scan on info_revision_type_lkp e (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((revision_type)::text = 'NEW'::text)
53. 0.000 0.000 ↓ 0.0

Seq Scan on rel_info_resp_aprvl_wf riraw (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((current_flag)::text = 'Y'::text)
54. 0.000 0.000 ↓ 0.0

Index Scan using issue_verif_type_lkp_issue_id_info_type_id_case_type_id_key on issue_verif_type_lkp ivtl (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (((issue_id)::text = (cvid.issue_id)::text) AND ((case_type_id)::text = (ci.type_id)::text))
55. 0.000 0.000 ↓ 0.0

Append (cost=0..0 rows=0 width=0) (never executed)

56. 0.000 0.000 ↓ 0.0

Index Scan using info_sft_acnt_trans_dtls_pkey on info_sft_acnt_trans_dtls info_sft_acnt_trans_dtls (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (tsn_id = '1119003802678'::bigint)
57. 0.000 0.000 ↓ 0.0

Index Scan using info_sft_fin_trans_dtls_pkey on info_sft_fin_trans_dtls info_sft_fin_trans_dtls (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (tsn_id = '1119003802678'::bigint)
58. 0.000 0.000 ↓ 0.0

Index Scan using info_sft_prprty_trans_dtls_pkey on info_sft_prprty_trans_dtls info_sft_prprty_trans_dtls (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (tsn_id = '1119003802678'::bigint)
59. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

60. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

61. 0.000 0.000 ↓ 0.0

Seq Scan on sys_rel_info_status_lkp svs_1 (cost=0..0 rows=0 width=0) (never executed)

62. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

63. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

64. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0..0 rows=0 width=0) (never executed)

  • Group Key: x_2.rel_info_resp_id, x_2.rel_info_id, x_2.info_aware_flag, b_1_2.tot_civ_amount, c_1_2.remarks, x_2.create_date
65. 0.000 0.000 ↓ 0.0

Append (cost=0..0 rows=0 width=0) (never executed)

66. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

67. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

68. 0.000 0.000 ↓ 0.0

Subquery Scan on x_2 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (((x_2.info_aware_flag)::text = 'Y'::text) AND (x_2.top1 = 1))
69. 0.000 0.000 ↓ 0.0

WindowAgg (cost=0..0 rows=0 width=0) (never executed)

70. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: case_verif_rel_info_resp_3.rel_info_id, case_verif_rel_info_resp_3.create_date DESC
71. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on case_verif_rel_info_resp case_verif_rel_info_resp_3 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((trans_status)::text = 'S'::text)
72. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on case_verif_rel_info_resp_verif_type_id_idx (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((verif_type_id)::text = ANY ('{SF,SFTI}'::text[]))
73. 0.000 0.000 ↓ 0.0

Index Scan using info_resp_sf_comp_val_rel_info_resp_id_idx on info_resp_sf_comp_val b_1_2 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (rel_info_resp_id = x_2.rel_info_resp_id)
  • Filter: ((trans_status)::text = 'S'::text)
74. 0.000 0.000 ↓ 0.0

Index Scan using info_resp_sf_civ_grp_trans_id_idx on info_resp_sf_civ c_1_2 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (grp_trans_id = b_1_2.trans_id)
75. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

76. 0.000 0.000 ↓ 0.0

Seq Scan on info_resp_tt_rcpt c_1_3 (cost=0..0 rows=0 width=0) (never executed)

77. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

78. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

79. 0.000 0.000 ↓ 0.0

Seq Scan on info_resp_tt_comp_val b_1_3 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((trans_status)::text = 'S'::text)
80. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

81. 0.000 0.000 ↓ 0.0

Subquery Scan on y_1 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (((y_1.info_aware_flag)::text = 'Y'::text) AND (y_1.top1 = 1))
82. 0.000 0.000 ↓ 0.0

WindowAgg (cost=0..0 rows=0 width=0) (never executed)

83. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: case_verif_rel_info_resp_4.rel_info_id, case_verif_rel_info_resp_4.create_date DESC
84. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on case_verif_rel_info_resp case_verif_rel_info_resp_4 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((trans_status)::text = 'S'::text)
85. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on case_verif_rel_info_resp_verif_type_id_idx (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((verif_type_id)::text = ANY ('{TT,TTSP}'::text[]))
86. 0.000 0.000 ↓ 0.0

Subquery Scan on x_3 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (((x_3.info_aware_flag)::text = 'N'::text) AND (x_3.top1 = 1))
87. 0.000 0.000 ↓ 0.0

WindowAgg (cost=0..0 rows=0 width=0) (never executed)

88. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: case_verif_rel_info_resp_5.rel_info_id, case_verif_rel_info_resp_5.create_date DESC
89. 0.000 0.000 ↓ 0.0

Seq Scan on case_verif_rel_info_resp case_verif_rel_info_resp_5 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((trans_status)::text = 'S'::text)
90. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

91. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

92. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

93. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

94. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

95. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

96. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

97. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

98. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

99. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

100. 0.000 0.000 ↓ 0.0

Index Scan using case_verif_rel_info_tsn_id_idx on case_verif_rel_info cvri_1 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (tsn_id = '1119003802678'::bigint)
101. 0.000 0.000 ↓ 0.0

Index Scan using xpkcase_verif_issue_detail on case_verif_issue_detail cvid_1 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (verif_seq_id = cvri_1.verif_seq_id)
102. 0.000 0.000 ↓ 0.0

Index Scan using xpkcase_info on case_info ci_1 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (case_seq_id = cvid_1.case_seq_id)
103. 0.000 0.000 ↓ 0.0

Index Scan using xpkcase_verif_issue_code on verif_issue_code vic_1 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((issue_id)::text = (cvid_1.issue_id)::text)
104. 0.000 0.000 ↓ 0.0

Seq Scan on rel_info_status ris_1 (cost=0..0 rows=0 width=0) (never executed)

105. 0.000 0.000 ↓ 0.0

Index Scan using xpkinfo_dtls on info_dtls b_2 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (tsn_id = '1119003802678'::bigint)
  • Filter: (NOT (hashed SubPlan 2))
106.          

SubPlan (for Index Scan)

107. 0.000 0.000 ↓ 0.0

Index Only Scan using info_dtls_parent_tsn_id_idx on info_dtls a_1 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (parent_tsn_id IS NOT NULL)
108. 0.000 0.000 ↓ 0.0

Index Scan using xpkcase_verif_rel_info_type on info_type c_2 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((info_type_id)::text = (b_2.info_type_id)::text)
109. 0.000 0.000 ↓ 0.0

Seq Scan on info_revision_type_lkp e_1 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((revision_type)::text = 'UPDATED'::text)
110. 0.000 0.000 ↓ 0.0

Seq Scan on rel_info_resp_aprvl_wf riraw_1 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((current_flag)::text = 'Y'::text)
111. 0.000 0.000 ↓ 0.0

Index Scan using issue_verif_type_lkp_issue_id_info_type_id_case_type_id_key on issue_verif_type_lkp ivtl_1 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (((issue_id)::text = (cvid_1.issue_id)::text) AND ((case_type_id)::text = (ci_1.type_id)::text))
112. 0.000 0.000 ↓ 0.0

Append (cost=0..0 rows=0 width=0) (never executed)

113. 0.000 0.000 ↓ 0.0

Index Scan using info_sft_acnt_trans_dtls_pkey on info_sft_acnt_trans_dtls info_sft_acnt_trans_dtls_1 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (tsn_id = '1119003802678'::bigint)
114. 0.000 0.000 ↓ 0.0

Index Scan using info_sft_fin_trans_dtls_pkey on info_sft_fin_trans_dtls info_sft_fin_trans_dtls_1 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (tsn_id = '1119003802678'::bigint)
115. 0.000 0.000 ↓ 0.0

Index Scan using info_sft_prprty_trans_dtls_pkey on info_sft_prprty_trans_dtls info_sft_prprty_trans_dtls_1 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (tsn_id = '1119003802678'::bigint)
116. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

117. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

118. 0.000 0.000 ↓ 0.0

Seq Scan on sys_rel_info_status_lkp svs_2 (cost=0..0 rows=0 width=0) (never executed)

119. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

120. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

121. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0..0 rows=0 width=0) (never executed)

  • Group Key: x_4.rel_info_resp_id, x_4.rel_info_id, x_4.info_aware_flag, b_1_4.tot_civ_amount, c_1_4.remarks, x_4.create_date
122. 0.000 0.000 ↓ 0.0

Append (cost=0..0 rows=0 width=0) (never executed)

123. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

124. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

125. 0.000 0.000 ↓ 0.0

Subquery Scan on x_4 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (((x_4.info_aware_flag)::text = 'Y'::text) AND (x_4.top1 = 1))
126. 0.000 0.000 ↓ 0.0

WindowAgg (cost=0..0 rows=0 width=0) (never executed)

127. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: case_verif_rel_info_resp_6.rel_info_id, case_verif_rel_info_resp_6.create_date DESC
128. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on case_verif_rel_info_resp case_verif_rel_info_resp_6 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((trans_status)::text = 'S'::text)
129. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on case_verif_rel_info_resp_verif_type_id_idx (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((verif_type_id)::text = ANY ('{SF,SFTI}'::text[]))
130. 0.000 0.000 ↓ 0.0

Index Scan using info_resp_sf_comp_val_rel_info_resp_id_idx on info_resp_sf_comp_val b_1_4 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (rel_info_resp_id = x_4.rel_info_resp_id)
  • Filter: ((trans_status)::text = 'S'::text)
131. 0.000 0.000 ↓ 0.0

Index Scan using info_resp_sf_civ_grp_trans_id_idx on info_resp_sf_civ c_1_4 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (grp_trans_id = b_1_4.trans_id)
132. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

133. 0.000 0.000 ↓ 0.0

Seq Scan on info_resp_tt_rcpt c_1_5 (cost=0..0 rows=0 width=0) (never executed)

134. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

135. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

136. 0.000 0.000 ↓ 0.0

Seq Scan on info_resp_tt_comp_val b_1_5 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((trans_status)::text = 'S'::text)
137. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

138. 0.000 0.000 ↓ 0.0

Subquery Scan on y_2 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (((y_2.info_aware_flag)::text = 'Y'::text) AND (y_2.top1 = 1))
139. 0.000 0.000 ↓ 0.0

WindowAgg (cost=0..0 rows=0 width=0) (never executed)

140. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: case_verif_rel_info_resp_7.rel_info_id, case_verif_rel_info_resp_7.create_date DESC
141. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on case_verif_rel_info_resp case_verif_rel_info_resp_7 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((trans_status)::text = 'S'::text)
142. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on case_verif_rel_info_resp_verif_type_id_idx (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((verif_type_id)::text = ANY ('{TT,TTSP}'::text[]))
143. 0.000 0.000 ↓ 0.0

Subquery Scan on x_5 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (((x_5.info_aware_flag)::text = 'N'::text) AND (x_5.top1 = 1))
144. 0.000 0.000 ↓ 0.0

WindowAgg (cost=0..0 rows=0 width=0) (never executed)

145. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: case_verif_rel_info_resp_8.rel_info_id, case_verif_rel_info_resp_8.create_date DESC
146. 0.000 0.000 ↓ 0.0

Seq Scan on case_verif_rel_info_resp case_verif_rel_info_resp_8 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((trans_status)::text = 'S'::text)
147. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

148. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

149. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

150. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

151. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

152. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

153. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

154. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

155. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

156. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

157. 0.000 0.000 ↓ 0.0

Index Scan using case_verif_rel_info_tsn_id_idx on case_verif_rel_info cvri_2 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (tsn_id = '1119003802678'::bigint)
158. 0.000 0.000 ↓ 0.0

Index Scan using xpkcase_verif_issue_detail on case_verif_issue_detail cvid_2 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (verif_seq_id = cvri_2.verif_seq_id)
159. 0.000 0.000 ↓ 0.0

Index Scan using xpkcase_info on case_info ci_2 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (case_seq_id = cvid_2.case_seq_id)
160. 0.000 0.000 ↓ 0.0

Index Scan using xpkcase_verif_issue_code on verif_issue_code vic_2 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((issue_id)::text = (cvid_2.issue_id)::text)
161. 0.000 0.000 ↓ 0.0

Seq Scan on rel_info_status ris_2 (cost=0..0 rows=0 width=0) (never executed)

162. 0.000 0.000 ↓ 0.0

Index Scan using xpkinfo_dtls on info_dtls b_3 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (tsn_id = '1119003802678'::bigint)
  • Filter: (revision_type_id IS NULL)
163. 0.000 0.000 ↓ 0.0

Index Only Scan using xpkinfo_dtls on info_dtls a (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (tsn_id = '1119003802678'::bigint)
  • Filter: (NOT (hashed SubPlan 1))
164.          

SubPlan (for Index Only Scan)

165. 0.000 0.000 ↓ 0.0

Index Only Scan using info_dtls_parent_tsn_id_idx on info_dtls info_dtls (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (parent_tsn_id IS NOT NULL)
166. 0.000 0.000 ↓ 0.0

Index Scan using xpkcase_verif_rel_info_type on info_type c_3 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((info_type_id)::text = (b_3.info_type_id)::text)
167. 0.000 0.000 ↓ 0.0

Seq Scan on rel_info_resp_aprvl_wf riraw_2 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((current_flag)::text = 'Y'::text)
168. 0.000 0.000 ↓ 0.0

Index Scan using issue_verif_type_lkp_issue_id_info_type_id_case_type_id_key on issue_verif_type_lkp ivtl_2 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (((issue_id)::text = (cvid_2.issue_id)::text) AND ((case_type_id)::text = (ci_2.type_id)::text))
169. 0.000 0.000 ↓ 0.0

Append (cost=0..0 rows=0 width=0) (never executed)

170. 0.000 0.000 ↓ 0.0

Index Scan using info_sft_acnt_trans_dtls_pkey on info_sft_acnt_trans_dtls info_sft_acnt_trans_dtls_2 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (tsn_id = '1119003802678'::bigint)
171. 0.000 0.000 ↓ 0.0

Index Scan using info_sft_fin_trans_dtls_pkey on info_sft_fin_trans_dtls info_sft_fin_trans_dtls_2 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (tsn_id = '1119003802678'::bigint)
172. 0.000 0.000 ↓ 0.0

Index Scan using info_sft_prprty_trans_dtls_pkey on info_sft_prprty_trans_dtls info_sft_prprty_trans_dtls_2 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (tsn_id = '1119003802678'::bigint)