explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oYqY : 1

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

HashAggregate (cost=395,938.05..395,939.09 rows=19 width=190) (actual rows= loops=)

2.          

CTE purpose_dtls

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=124,228.93..124,296.85 rows=1,698 width=579) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=77.12..124,118.56 rows=1,698 width=579) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=77.12..123,562.39 rows=1,698 width=579) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=77.12..117,002.67 rows=1,708 width=562) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=77.12..66,580.98 rows=20,449 width=544) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=77.12..52,122.46 rows=32,869 width=554) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Append (cost=2.28..340.75 rows=6 width=115) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst bs (cost=2.28..9.35 rows=1 width=57) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = 9,999::numeric)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
11. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.28 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..60.45 rows=1 width=82) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l1 (cost=0.00..9.79 rows=4 width=25) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
14. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst bs (cost=2.30..12.57 rows=3 width=62) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = l1.location_id)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
15. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.30 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = l1.location_id)
16. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..63.84 rows=1 width=107) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..60.76 rows=4 width=50) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l1 (cost=0.00..9.79 rows=4 width=25) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
19. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst l2 (cost=2.30..12.53 rows=7 width=30) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = l1.location_id)
20. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.30 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = l1.location_id)
21. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst bs (cost=0.00..0.68 rows=3 width=62) (actual rows= loops=)

  • Index Cond: (parent_location_id = l2.location_id)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
22. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..66.45 rows=1 width=132) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..64.14 rows=3 width=75) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..60.76 rows=4 width=50) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l1 (cost=0.00..9.79 rows=4 width=25) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
26. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst l2 (cost=2.30..12.53 rows=7 width=30) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = l1.location_id)
27. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.30 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = l1.location_id)
28. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l3 (cost=0.00..0.63 rows=7 width=30) (actual rows= loops=)

  • Index Cond: (parent_location_id = l2.location_id)
29. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst bs (cost=0.00..0.68 rows=3 width=62) (actual rows= loops=)

  • Index Cond: (parent_location_id = l3.location_id)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
30. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 5 (cost=2.30..69.01 rows=1 width=157) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..68.98 rows=1 width=157) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..66.67 rows=3 width=100) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..64.14 rows=3 width=75) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..60.76 rows=4 width=50) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l1 (cost=0.00..9.79 rows=4 width=25) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
36. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst l2 (cost=2.30..12.53 rows=7 width=30) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = l1.location_id)
37. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.30 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = l1.location_id)
38. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l3 (cost=0.00..0.63 rows=7 width=30) (actual rows= loops=)

  • Index Cond: (parent_location_id = l2.location_id)
39. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l4 (cost=0.00..0.63 rows=7 width=30) (actual rows= loops=)

  • Index Cond: (parent_location_id = l3.location_id)
40. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst bs (cost=0.00..0.68 rows=3 width=62) (actual rows= loops=)

  • Index Cond: (parent_location_id = l4.location_id)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
41. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 6 (cost=2.30..71.54 rows=1 width=157) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..71.51 rows=1 width=157) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..69.21 rows=3 width=106) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..66.67 rows=3 width=100) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..64.14 rows=3 width=75) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..60.76 rows=4 width=50) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l1 (cost=0.00..9.79 rows=4 width=25) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
48. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst l2 (cost=2.30..12.53 rows=7 width=30) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = l1.location_id)
49. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.30 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = l1.location_id)
50. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l3 (cost=0.00..0.63 rows=7 width=30) (actual rows= loops=)

  • Index Cond: (parent_location_id = l2.location_id)
51. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l4 (cost=0.00..0.63 rows=7 width=30) (actual rows= loops=)

  • Index Cond: (parent_location_id = l3.location_id)
52. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l5 (cost=0.00..0.63 rows=7 width=11) (actual rows= loops=)

  • Index Cond: (parent_location_id = l4.location_id)
53. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst bs (cost=0.00..0.68 rows=3 width=62) (actual rows= loops=)

  • Index Cond: (parent_location_id = l5.location_id)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
54. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on reg_dealer_master reg (cost=74.84..8,465.91 rows=5,478 width=26) (actual rows= loops=)

  • Recheck Cond: (location_cd = bs.location_id)
55. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_reg_dealer_master_loc_cd (cost=0.00..73.47 rows=5,478 width=0) (actual rows= loops=)

  • Index Cond: (location_cd = bs.location_id)
56. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_reg_dealer_master_mapping_ack_no on reg_dealer_master_mapping map (cost=0.00..0.41 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (ack_no = reg.ack_no)
57. 0.000 0.000 ↓ 0.0

Index Scan using idx_web_challan_details_wcd_dealer_id on web_challan_details wc (cost=0.00..2.44 rows=1 width=42) (actual rows= loops=)

  • Index Cond: ((wcd_dealer_id)::text = (reg.dealer_id)::text)
  • Filter: ((((wcd_dealer_id)::text <> '777777777777'::text) OR (wcd_dealer_id IS NULL)) AND ((formno)::text <> 'VAT FORM R'::text) AND ((wcd_tax_type_cd)::text = ANY ('{VAT,GOVT}'::text[])) AND ((mig_yn)::text = 'Y'::text) AND (trunc(mig_date) >= '01-APR-18 00:00:00'::timestamp without time zone) AND (trunc(mig_date) <= '31-OCT-19 00:00:00'::timestamp without time zone))
58. 0.000 0.000 ↓ 0.0

Index Scan using idx_web_purpose_details_wpd_challan_id on web_purpose_details wp (cost=0.00..3.81 rows=1 width=45) (actual rows= loops=)

  • Index Cond: ((wpd_challan_id)::text = (wc.wcd_challan_id)::text)
  • Filter: ((wpd_purpose_code)::text <> ALL ('{TAXCSIB,TAXCSPG,TOBACO,TXCSNVG,TAXCPSC}'::text[]))
59. 0.000 0.000 ↓ 0.0

Index Scan using idx_pmt_head_master_purpose_code on pmt_head_master pmt (cost=0.00..0.30 rows=1 width=18) (actual rows= loops=)

  • Index Cond: ((payment_purpose_code)::text = (wp.payment_purpose_code)::text)
  • Filter: ((hm_major_head)::text = ANY ('{Tax,Penalty,Fees,Comp_Fee,Others,Interest}'::text[]))
60. 0.000 0.000 ↓ 0.0

Append (cost=114.64..271,640.53 rows=19 width=190) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1 (cost=114.64..114.70 rows=1 width=284) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

HashAggregate (cost=114.64..114.67 rows=1 width=818) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

CTE Scan on purpose_dtls (cost=0.00..114.62 rows=1 width=818) (actual rows= loops=)

  • Filter: (((act)::text = ANY ('{VAT,GOVT}'::text[])) AND ((wpc)::text = ANY ('{TAXCSA,VATSEC12,TAXNTC,ADVTAX}'::text[])))
64. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=127.37..127.43 rows=1 width=278) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

HashAggregate (cost=127.37..127.40 rows=1 width=780) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

CTE Scan on purpose_dtls (cost=0.00..127.35 rows=1 width=780) (actual rows= loops=)

  • Filter: (((act)::text = 'VAT'::text) AND ((wpc)::text = ANY ('{VATINT,OREVA,REXVA,LICFEE,PNLT,APFEATA,REGFEE,RCPT,APLFESA,APPLAC}'::text[])))
67. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 3 (cost=122,129.30..122,129.48 rows=3 width=179) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

HashAggregate (cost=122,129.30..122,129.39 rows=3 width=566) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Nested Loop (cost=77.12..122,128.38 rows=16 width=566) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Nested Loop (cost=77.12..114,446.55 rows=2,063 width=556) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Nested Loop (cost=77.12..66,580.98 rows=20,449 width=544) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Nested Loop (cost=77.12..52,122.46 rows=32,869 width=554) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Append (cost=2.28..340.75 rows=6 width=115) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst bs (cost=2.28..9.35 rows=1 width=57) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = 9,999::numeric)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
75. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.28 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
76. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..60.45 rows=1 width=82) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l1 (cost=0.00..9.79 rows=4 width=25) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
78. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst bs (cost=2.30..12.57 rows=3 width=62) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = l1.location_id)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
79. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.30 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = l1.location_id)
80. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..63.84 rows=1 width=107) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..60.76 rows=4 width=50) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l1 (cost=0.00..9.79 rows=4 width=25) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
83. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst l2 (cost=2.30..12.53 rows=7 width=30) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = l1.location_id)
84. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.30 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = l1.location_id)
85. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst bs (cost=0.00..0.68 rows=3 width=62) (actual rows= loops=)

  • Index Cond: (parent_location_id = l2.location_id)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
86. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..66.45 rows=1 width=132) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..64.14 rows=3 width=75) (actual rows= loops=)

88. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..60.76 rows=4 width=50) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l1 (cost=0.00..9.79 rows=4 width=25) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
90. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst l2 (cost=2.30..12.53 rows=7 width=30) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = l1.location_id)
91. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.30 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = l1.location_id)
92. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l3 (cost=0.00..0.63 rows=7 width=30) (actual rows= loops=)

  • Index Cond: (parent_location_id = l2.location_id)
93. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst bs (cost=0.00..0.68 rows=3 width=62) (actual rows= loops=)

  • Index Cond: (parent_location_id = l3.location_id)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
94. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 5 (cost=2.30..69.01 rows=1 width=157) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..68.98 rows=1 width=157) (actual rows= loops=)

96. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..66.67 rows=3 width=100) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..64.14 rows=3 width=75) (actual rows= loops=)

98. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..60.76 rows=4 width=50) (actual rows= loops=)

99. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l1 (cost=0.00..9.79 rows=4 width=25) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
100. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst l2 (cost=2.30..12.53 rows=7 width=30) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = l1.location_id)
101. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.30 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = l1.location_id)
102. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l3 (cost=0.00..0.63 rows=7 width=30) (actual rows= loops=)

  • Index Cond: (parent_location_id = l2.location_id)
103. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l4 (cost=0.00..0.63 rows=7 width=30) (actual rows= loops=)

  • Index Cond: (parent_location_id = l3.location_id)
104. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst bs (cost=0.00..0.68 rows=3 width=62) (actual rows= loops=)

  • Index Cond: (parent_location_id = l4.location_id)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
105. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 6 (cost=2.30..71.54 rows=1 width=157) (actual rows= loops=)

106. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..71.51 rows=1 width=157) (actual rows= loops=)

107. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..69.21 rows=3 width=106) (actual rows= loops=)

108. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..66.67 rows=3 width=100) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..64.14 rows=3 width=75) (actual rows= loops=)

110. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..60.76 rows=4 width=50) (actual rows= loops=)

111. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l1 (cost=0.00..9.79 rows=4 width=25) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
112. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst l2 (cost=2.30..12.53 rows=7 width=30) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = l1.location_id)
113. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.30 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = l1.location_id)
114. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l3 (cost=0.00..0.63 rows=7 width=30) (actual rows= loops=)

  • Index Cond: (parent_location_id = l2.location_id)
115. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l4 (cost=0.00..0.63 rows=7 width=30) (actual rows= loops=)

  • Index Cond: (parent_location_id = l3.location_id)
116. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l5 (cost=0.00..0.63 rows=7 width=11) (actual rows= loops=)

  • Index Cond: (parent_location_id = l4.location_id)
117. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst bs (cost=0.00..0.68 rows=3 width=62) (actual rows= loops=)

  • Index Cond: (parent_location_id = l5.location_id)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
118. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on reg_dealer_master reg (cost=74.84..8,465.91 rows=5,478 width=26) (actual rows= loops=)

  • Recheck Cond: (location_cd = bs.location_id)
119. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_reg_dealer_master_loc_cd (cost=0.00..73.47 rows=5,478 width=0) (actual rows= loops=)

  • Index Cond: (location_cd = bs.location_id)
120. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_reg_dealer_master_mapping_ack_no on reg_dealer_master_mapping map (cost=0.00..0.41 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (ack_no = reg.ack_no)
121. 0.000 0.000 ↓ 0.0

Index Scan using idx_web_challan_details_wcd_dealer_id on web_challan_details wc (cost=0.00..2.31 rows=1 width=36) (actual rows= loops=)

  • Index Cond: ((wcd_dealer_id)::text = (reg.dealer_id)::text)
  • Filter: ((((wcd_dealer_id)::text <> '777777777777'::text) OR (wcd_dealer_id IS NULL)) AND ((mig_yn)::text = 'Y'::text) AND (trunc(mig_date) >= '01-APR-18 00:00:00'::timestamp without time zone) AND (trunc(mig_date) <= '31-OCT-19 00:00:00'::timestamp without time zone))
122. 0.000 0.000 ↓ 0.0

Index Scan using idx_web_purpose_details_wpd_challan_id on web_purpose_details wpd (cost=0.00..3.69 rows=1 width=38) (actual rows= loops=)

  • Index Cond: ((wpd_challan_id)::text = (wc.wcd_challan_id)::text)
  • Filter: ((wpd_purpose_code)::text = ANY ('{TAXCSIB,TAXCSPG,TOBACO,TXCSNVG,TAXCPSC}'::text[]))
123. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 4 (cost=96,881.31..96,882.09 rows=13 width=179) (actual rows= loops=)

124. 0.000 0.000 ↓ 0.0

HashAggregate (cost=96,881.31..96,881.70 rows=13 width=566) (actual rows= loops=)

125. 0.000 0.000 ↓ 0.0

Nested Loop (cost=53,561.78..96,880.56 rows=13 width=566) (actual rows= loops=)

126. 0.000 0.000 ↓ 0.0

Nested Loop (cost=53,561.78..96,820.37 rows=13 width=556) (actual rows= loops=)

127. 0.000 0.000 ↓ 0.0

Hash Join (cost=53,561.78..96,811.13 rows=21 width=566) (actual rows= loops=)

  • Hash Cond: ((wc.wcd_dealer_id)::text = (reg.dealer_id)::text)
128. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on web_challan_details wc (cost=371.08..42,374.59 rows=101 width=36) (actual rows= loops=)

  • Recheck Cond: ((formno)::text = 'VAT FORM R'::text)
  • Filter: ((((wcd_dealer_id)::text <> '777777777777'::text) OR (wcd_dealer_id IS NULL)) AND ((mig_yn)::text = 'Y'::text) AND (trunc(mig_date) >= '01-APR-18 00:00:00'::timestamp without time zone) AND (trunc(mig_date) <= '31-OCT-19 00:00:00'::timestamp without time zone))
129. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_web_challan_details_formno (cost=0.00..371.05 rows=24,868 width=0) (actual rows= loops=)

  • Index Cond: ((formno)::text = 'VAT FORM R'::text)
130. 0.000 0.000 ↓ 0.0

Hash (cost=52,122.46..52,122.46 rows=32,869 width=554) (actual rows= loops=)

131. 0.000 0.000 ↓ 0.0

Nested Loop (cost=77.12..52,122.46 rows=32,869 width=554) (actual rows= loops=)

132. 0.000 0.000 ↓ 0.0

Append (cost=2.28..340.75 rows=6 width=115) (actual rows= loops=)

133. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst bs (cost=2.28..9.35 rows=1 width=57) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = 9,999::numeric)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
134. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.28 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
135. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..60.45 rows=1 width=82) (actual rows= loops=)

136. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l1 (cost=0.00..9.79 rows=4 width=25) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
137. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst bs (cost=2.30..12.57 rows=3 width=62) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = l1.location_id)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
138. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.30 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = l1.location_id)
139. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..63.84 rows=1 width=107) (actual rows= loops=)

140. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..60.76 rows=4 width=50) (actual rows= loops=)

141. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l1 (cost=0.00..9.79 rows=4 width=25) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
142. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst l2 (cost=2.30..12.53 rows=7 width=30) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = l1.location_id)
143. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.30 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = l1.location_id)
144. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst bs (cost=0.00..0.68 rows=3 width=62) (actual rows= loops=)

  • Index Cond: (parent_location_id = l2.location_id)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
145. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..66.45 rows=1 width=132) (actual rows= loops=)

146. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..64.14 rows=3 width=75) (actual rows= loops=)

147. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..60.76 rows=4 width=50) (actual rows= loops=)

148. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l1 (cost=0.00..9.79 rows=4 width=25) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
149. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst l2 (cost=2.30..12.53 rows=7 width=30) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = l1.location_id)
150. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.30 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = l1.location_id)
151. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l3 (cost=0.00..0.63 rows=7 width=30) (actual rows= loops=)

  • Index Cond: (parent_location_id = l2.location_id)
152. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst bs (cost=0.00..0.68 rows=3 width=62) (actual rows= loops=)

  • Index Cond: (parent_location_id = l3.location_id)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
153. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 5 (cost=2.30..69.01 rows=1 width=157) (actual rows= loops=)

154. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..68.98 rows=1 width=157) (actual rows= loops=)

155. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..66.67 rows=3 width=100) (actual rows= loops=)

156. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..64.14 rows=3 width=75) (actual rows= loops=)

157. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..60.76 rows=4 width=50) (actual rows= loops=)

158. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l1 (cost=0.00..9.79 rows=4 width=25) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
159. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst l2 (cost=2.30..12.53 rows=7 width=30) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = l1.location_id)
160. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.30 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = l1.location_id)
161. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l3 (cost=0.00..0.63 rows=7 width=30) (actual rows= loops=)

  • Index Cond: (parent_location_id = l2.location_id)
162. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l4 (cost=0.00..0.63 rows=7 width=30) (actual rows= loops=)

  • Index Cond: (parent_location_id = l3.location_id)
163. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst bs (cost=0.00..0.68 rows=3 width=62) (actual rows= loops=)

  • Index Cond: (parent_location_id = l4.location_id)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
164. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 6 (cost=2.30..71.54 rows=1 width=157) (actual rows= loops=)

165. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..71.51 rows=1 width=157) (actual rows= loops=)

166. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..69.21 rows=3 width=106) (actual rows= loops=)

167. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..66.67 rows=3 width=100) (actual rows= loops=)

168. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..64.14 rows=3 width=75) (actual rows= loops=)

169. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..60.76 rows=4 width=50) (actual rows= loops=)

170. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l1 (cost=0.00..9.79 rows=4 width=25) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
171. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst l2 (cost=2.30..12.53 rows=7 width=30) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = l1.location_id)
172. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.30 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = l1.location_id)
173. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l3 (cost=0.00..0.63 rows=7 width=30) (actual rows= loops=)

  • Index Cond: (parent_location_id = l2.location_id)
174. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l4 (cost=0.00..0.63 rows=7 width=30) (actual rows= loops=)

  • Index Cond: (parent_location_id = l3.location_id)
175. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l5 (cost=0.00..0.63 rows=7 width=11) (actual rows= loops=)

  • Index Cond: (parent_location_id = l4.location_id)
176. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst bs (cost=0.00..0.68 rows=3 width=62) (actual rows= loops=)

  • Index Cond: (parent_location_id = l5.location_id)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
177. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on reg_dealer_master reg (cost=74.84..8,465.91 rows=5,478 width=26) (actual rows= loops=)

  • Recheck Cond: (location_cd = bs.location_id)
178. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_reg_dealer_master_loc_cd (cost=0.00..73.47 rows=5,478 width=0) (actual rows= loops=)

  • Index Cond: (location_cd = bs.location_id)
179. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_reg_dealer_master_mapping_ack_no on reg_dealer_master_mapping map (cost=0.00..0.41 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (ack_no = reg.ack_no)
180. 0.000 0.000 ↓ 0.0

Index Scan using idx_web_purpose_details_wpd_challan_id on web_purpose_details wpd (cost=0.00..4.60 rows=1 width=38) (actual rows= loops=)

  • Index Cond: ((wpd_challan_id)::text = (wc.wcd_challan_id)::text)
  • Filter: ((wpd_purpose_code)::text <> ALL ('{TAXCSIB,TAXCSPG,TOBACO,TXCSNVG,TAXCPSC}'::text[]))
181. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 5 (cost=52,386.78..52,386.84 rows=1 width=179) (actual rows= loops=)

182. 0.000 0.000 ↓ 0.0

HashAggregate (cost=52,386.78..52,386.81 rows=1 width=566) (actual rows= loops=)

183. 0.000 0.000 ↓ 0.0

Nested Loop (cost=130.85..52,386.72 rows=1 width=566) (actual rows= loops=)

184. 0.000 0.000 ↓ 0.0

Nested Loop (cost=130.85..52,386.28 rows=1 width=576) (actual rows= loops=)

185. 0.000 0.000 ↓ 0.0

Hash Join (cost=130.85..52,381.66 rows=1 width=566) (actual rows= loops=)

  • Hash Cond: ((reg.dealer_id)::text = (wc.wcd_dealer_id)::text)
186. 0.000 0.000 ↓ 0.0

Nested Loop (cost=77.12..52,122.46 rows=32,869 width=554) (actual rows= loops=)

187. 0.000 0.000 ↓ 0.0

Append (cost=2.28..340.75 rows=6 width=115) (actual rows= loops=)

188. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst bs (cost=2.28..9.35 rows=1 width=57) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = 9,999::numeric)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
189. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.28 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
190. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..60.45 rows=1 width=82) (actual rows= loops=)

191. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l1 (cost=0.00..9.79 rows=4 width=25) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
192. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst bs (cost=2.30..12.57 rows=3 width=62) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = l1.location_id)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
193. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.30 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = l1.location_id)
194. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..63.84 rows=1 width=107) (actual rows= loops=)

195. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..60.76 rows=4 width=50) (actual rows= loops=)

196. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l1 (cost=0.00..9.79 rows=4 width=25) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
197. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst l2 (cost=2.30..12.53 rows=7 width=30) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = l1.location_id)
198. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.30 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = l1.location_id)
199. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst bs (cost=0.00..0.68 rows=3 width=62) (actual rows= loops=)

  • Index Cond: (parent_location_id = l2.location_id)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
200. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..66.45 rows=1 width=132) (actual rows= loops=)

201. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..64.14 rows=3 width=75) (actual rows= loops=)

202. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..60.76 rows=4 width=50) (actual rows= loops=)

203. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l1 (cost=0.00..9.79 rows=4 width=25) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
204. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst l2 (cost=2.30..12.53 rows=7 width=30) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = l1.location_id)
205. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.30 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = l1.location_id)
206. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l3 (cost=0.00..0.63 rows=7 width=30) (actual rows= loops=)

  • Index Cond: (parent_location_id = l2.location_id)
207. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst bs (cost=0.00..0.68 rows=3 width=62) (actual rows= loops=)

  • Index Cond: (parent_location_id = l3.location_id)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
208. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 5 (cost=2.30..69.01 rows=1 width=157) (actual rows= loops=)

209. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..68.98 rows=1 width=157) (actual rows= loops=)

210. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..66.67 rows=3 width=100) (actual rows= loops=)

211. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..64.14 rows=3 width=75) (actual rows= loops=)

212. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..60.76 rows=4 width=50) (actual rows= loops=)

213. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l1 (cost=0.00..9.79 rows=4 width=25) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
214. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst l2 (cost=2.30..12.53 rows=7 width=30) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = l1.location_id)
215. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.30 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = l1.location_id)
216. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l3 (cost=0.00..0.63 rows=7 width=30) (actual rows= loops=)

  • Index Cond: (parent_location_id = l2.location_id)
217. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l4 (cost=0.00..0.63 rows=7 width=30) (actual rows= loops=)

  • Index Cond: (parent_location_id = l3.location_id)
218. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst bs (cost=0.00..0.68 rows=3 width=62) (actual rows= loops=)

  • Index Cond: (parent_location_id = l4.location_id)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
219. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 6 (cost=2.30..71.54 rows=1 width=157) (actual rows= loops=)

220. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..71.51 rows=1 width=157) (actual rows= loops=)

221. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..69.21 rows=3 width=106) (actual rows= loops=)

222. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..66.67 rows=3 width=100) (actual rows= loops=)

223. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..64.14 rows=3 width=75) (actual rows= loops=)

224. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.30..60.76 rows=4 width=50) (actual rows= loops=)

225. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l1 (cost=0.00..9.79 rows=4 width=25) (actual rows= loops=)

  • Index Cond: (parent_location_id = 9,999::numeric)
226. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on gen_location_mst l2 (cost=2.30..12.53 rows=7 width=30) (actual rows= loops=)

  • Recheck Cond: (parent_location_id = l1.location_id)
227. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_gen_location_mst_parent_location_id (cost=0.00..2.30 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (parent_location_id = l1.location_id)
228. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l3 (cost=0.00..0.63 rows=7 width=30) (actual rows= loops=)

  • Index Cond: (parent_location_id = l2.location_id)
229. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l4 (cost=0.00..0.63 rows=7 width=30) (actual rows= loops=)

  • Index Cond: (parent_location_id = l3.location_id)
230. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst l5 (cost=0.00..0.63 rows=7 width=11) (actual rows= loops=)

  • Index Cond: (parent_location_id = l4.location_id)
231. 0.000 0.000 ↓ 0.0

Index Scan using idx_gen_location_mst_parent_location_id on gen_location_mst bs (cost=0.00..0.68 rows=3 width=62) (actual rows= loops=)

  • Index Cond: (parent_location_id = l5.location_id)
  • Filter: (((active_flag)::text = ANY ('{Y,P}'::text[])) AND ((group_cd)::text = ANY ('{DIV,ZN,CIR}'::text[])))
232. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on reg_dealer_master reg (cost=74.84..8,465.91 rows=5,478 width=26) (actual rows= loops=)

  • Recheck Cond: (location_cd = bs.location_id)
233. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_reg_dealer_master_loc_cd (cost=0.00..73.47 rows=5,478 width=0) (actual rows= loops=)

  • Index Cond: (location_cd = bs.location_id)
234. 0.000 0.000 ↓ 0.0

Hash (cost=53.70..53.70 rows=1 width=36) (actual rows= loops=)

235. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on web_challan_details wc (cost=51.65..53.70 rows=1 width=36) (actual rows= loops=)

  • Recheck Cond: ((wpd_tax_mode = 'U'::bpchar) AND ((wcd_reg_type)::text = 'U'::text))
  • Filter: ((((wcd_dealer_id)::text <> '777777777777'::text) OR (wcd_dealer_id IS NULL)) AND ((mig_yn)::text = 'Y'::text) AND (trunc(mig_date) >= '01-APR-18 00:00:00'::timestamp without time zone) AND (trunc(mig_date) <= '31-OCT-19 00:00:00'::timestamp without time zone))
236. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=51.65..51.65 rows=1 width=0) (actual rows= loops=)

237. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_web_challan_details_wpd_tax_mode (cost=0.00..18.28 rows=1,309 width=0) (actual rows= loops=)

  • Index Cond: (wpd_tax_mode = 'U'::bpchar)
238. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_web_challan_details_wcd_reg_type (cost=0.00..33.12 rows=2,487 width=0) (actual rows= loops=)

  • Index Cond: ((wcd_reg_type)::text = 'U'::text)
239. 0.000 0.000 ↓ 0.0

Index Scan using idx_web_purpose_details_wpd_challan_id on web_purpose_details wpd (cost=0.00..4.60 rows=1 width=38) (actual rows= loops=)

  • Index Cond: ((wpd_challan_id)::text = (wc.wcd_challan_id)::text)
  • Filter: ((wpd_purpose_code)::text = 'TAXDSA'::text)
240. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_reg_dealer_master_mapping_ack_no on reg_dealer_master_mapping map (cost=0.00..0.41 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (ack_no = reg.ack_no)