explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Yjo6 : Tasklist

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 20.963 ↓ 0.0 0 1

HashAggregate (cost=55,529.50..55,529.54 rows=4 width=128) (actual time=20.963..20.963 rows=0 loops=1)

  • Group Key: b.parent_txn_id, (edb_ora_timestamp_tochar_immutable(a.challan_date, 'dd/mm/yyyy'::character varying)), d.deposite_type_desc, (sum(a.amount))
2. 0.001 20.961 ↓ 0.0 0 1

Append (cost=13,917.43..55,529.46 rows=4 width=128) (actual time=20.961..20.961 rows=0 loops=1)

3. 0.002 6.225 ↓ 0.0 0 1

GroupAggregate (cost=13,917.43..13,917.46 rows=1 width=99) (actual time=6.225..6.225 rows=0 loops=1)

  • Group Key: b.parent_txn_id, (edb_ora_timestamp_tochar_immutable(a.challan_date, 'dd/mm/yyyy'::character varying)), d.deposite_type_desc
4. 0.017 6.223 ↓ 0.0 0 1

Sort (cost=13,917.43..13,917.43 rows=1 width=73) (actual time=6.223..6.223 rows=0 loops=1)

  • Sort Key: b.parent_txn_id, (edb_ora_timestamp_tochar_immutable(a.challan_date, 'dd/mm/yyyy'::character varying)), d.deposite_type_desc
  • Sort Method: quicksort Memory: 25kB
5. 0.001 6.206 ↓ 0.0 0 1

Nested Loop (cost=193.67..13,917.42 rows=1 width=73) (actual time=6.206..6.206 rows=0 loops=1)

  • Join Filter: ((((((((d.major_head)::text || '-'::text) || (d.sub_major_head)::text) || '-'::text) || (d.minor_head)::text) || '-'::text) || (d.sub_head)::text) = (((((((f.major_head)::text || '-'::text) || (f.submajor_head)::text) (...)
6. 0.000 6.205 ↓ 0.0 0 1

Nested Loop (cost=193.37..13,917.06 rows=1 width=72) (actual time=6.205..6.205 rows=0 loops=1)

7. 0.002 6.205 ↓ 0.0 0 1

Nested Loop (cost=193.37..13,860.65 rows=1 width=76) (actual time=6.205..6.205 rows=0 loops=1)

  • Join Filter: ((a.challan_type)::text = (d.deposite_type)::text)
8. 0.000 6.203 ↓ 0.0 0 1

Nested Loop (cost=193.37..13,857.73 rows=1 width=39) (actual time=6.203..6.203 rows=0 loops=1)

9. 0.001 6.203 ↓ 0.0 0 1

Nested Loop (cost=193.37..13,621.27 rows=6 width=50) (actual time=6.203..6.203 rows=0 loops=1)

10. 4.706 6.202 ↓ 0.0 0 1

Bitmap Heap Scan on cfms_wf_workflow_dtl c (cost=192.82..13,575.76 rows=6 width=19) (actual time=6.202..6.202 rows=0 loops=1)

  • Recheck Cond: ((next_post_id = '65567'::numeric) AND (wf_status = 'C'::bpchar))
  • Filter: (((action_id)::text <> '3'::text) AND (next_role_id = '1'::numeric))
  • Rows Removed by Filter: 5775
  • Heap Blocks: exact=1643
11. 1.496 1.496 ↓ 1.4 5,777 1

Bitmap Index Scan on cfms_wf_workflow_dtl_idx1 (cost=0.00..192.81 rows=4,168 width=0) (actual time=1.496..1.496 rows=5,777 loops=1)

  • Index Cond: (next_post_id = '65567'::numeric)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using wef_a1 on cfms_wf_workflow_hdr b (cost=0.56..7.57 rows=1 width=31) (never executed)

  • Index Cond: (txn_id = c.txn_id)
13. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..37.19 rows=222 width=48) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr a (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: ((b.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
15. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2010 a_1 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: ((b.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
16. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2011 a_2 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: ((b.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
17. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2012 a_3 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: ((b.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
18. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2013 a_4 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: ((b.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
19. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2014 a_5 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: ((b.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
20. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2015 a_6 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: ((b.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
21. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2016 a_7 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: ((b.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
22. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2017 a_8 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: ((b.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
23. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2018 a_9 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: ((b.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
24. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2019 a_10 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: ((b.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
25. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2020 a_11 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: ((b.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
26. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2021 a_12 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: ((b.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
27. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2022 a_13 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: ((b.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
28. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2023 a_14 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: ((b.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
29. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2024 a_15 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: ((b.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
30. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2025 a_16 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: ((b.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
31. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_other_yrs a_17 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: ((b.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
32. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201001 on cfms_rct_challan_hdr_month_201001 a_18 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
33. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201002 on cfms_rct_challan_hdr_month_201002 a_19 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
34. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201003 on cfms_rct_challan_hdr_month_201003 a_20 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
35. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201004 on cfms_rct_challan_hdr_month_201004 a_21 (cost=0.12..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
36. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201005 on cfms_rct_challan_hdr_month_201005 a_22 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
37. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201006 on cfms_rct_challan_hdr_month_201006 a_23 (cost=0.12..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
38. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201007 on cfms_rct_challan_hdr_month_201007 a_24 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
39. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201008 on cfms_rct_challan_hdr_month_201008 a_25 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
40. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201009 on cfms_rct_challan_hdr_month_201009 a_26 (cost=0.13..0.15 rows=1 width=56) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
41. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201010 on cfms_rct_challan_hdr_month_201010 a_27 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
42. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201011 on cfms_rct_challan_hdr_month_201011 a_28 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
43. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201012 on cfms_rct_challan_hdr_month_201012 a_29 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
44. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201101 on cfms_rct_challan_hdr_month_201101 a_30 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
45. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201102 on cfms_rct_challan_hdr_month_201102 a_31 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
46. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201103 on cfms_rct_challan_hdr_month_201103 a_32 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
47. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201104 on cfms_rct_challan_hdr_month_201104 a_33 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
48. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201105 on cfms_rct_challan_hdr_month_201105 a_34 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
49. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201106 on cfms_rct_challan_hdr_month_201106 a_35 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
50. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201107 on cfms_rct_challan_hdr_month_201107 a_36 (cost=0.13..0.15 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
51. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201108 on cfms_rct_challan_hdr_month_201108 a_37 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
52. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201109 on cfms_rct_challan_hdr_month_201109 a_38 (cost=0.13..0.15 rows=1 width=54) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
53. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201110 on cfms_rct_challan_hdr_month_201110 a_39 (cost=0.13..0.15 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
54. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201111 on cfms_rct_challan_hdr_month_201111 a_40 (cost=0.13..0.15 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
55. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201112 on cfms_rct_challan_hdr_month_201112 a_41 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
56. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201201 on cfms_rct_challan_hdr_month_201201 a_42 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
57. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201202 on cfms_rct_challan_hdr_month_201202 a_43 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
58. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201203 on cfms_rct_challan_hdr_month_201203 a_44 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
59. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201204 on cfms_rct_challan_hdr_month_201204 a_45 (cost=0.13..0.15 rows=1 width=56) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
60. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201205 on cfms_rct_challan_hdr_month_201205 a_46 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
61. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201206 on cfms_rct_challan_hdr_month_201206 a_47 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
62. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201207 on cfms_rct_challan_hdr_month_201207 a_48 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
63. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201208 on cfms_rct_challan_hdr_month_201208 a_49 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
64. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201209 on cfms_rct_challan_hdr_month_201209 a_50 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
65. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201210 on cfms_rct_challan_hdr_month_201210 a_51 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
66. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201211 on cfms_rct_challan_hdr_month_201211 a_52 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
67. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201212 on cfms_rct_challan_hdr_month_201212 a_53 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
68. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201301 on cfms_rct_challan_hdr_month_201301 a_54 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
69. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201302 on cfms_rct_challan_hdr_month_201302 a_55 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
70. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201303 on cfms_rct_challan_hdr_month_201303 a_56 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
71. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201304 on cfms_rct_challan_hdr_month_201304 a_57 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
72. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201305 on cfms_rct_challan_hdr_month_201305 a_58 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
73. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201306 on cfms_rct_challan_hdr_month_201306 a_59 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
74. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201307 on cfms_rct_challan_hdr_month_201307 a_60 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
75. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201308 on cfms_rct_challan_hdr_month_201308 a_61 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
76. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201309 on cfms_rct_challan_hdr_month_201309 a_62 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
77. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201310 on cfms_rct_challan_hdr_month_201310 a_63 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
78. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201311 on cfms_rct_challan_hdr_month_201311 a_64 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
79. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201312 on cfms_rct_challan_hdr_month_201312 a_65 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
80. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201401 on cfms_rct_challan_hdr_month_201401 a_66 (cost=0.14..0.16 rows=1 width=54) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
81. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201402 on cfms_rct_challan_hdr_month_201402 a_67 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
82. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201403 on cfms_rct_challan_hdr_month_201403 a_68 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
83. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201404 on cfms_rct_challan_hdr_month_201404 a_69 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
84. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201405 on cfms_rct_challan_hdr_month_201405 a_70 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
85. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201406 on cfms_rct_challan_hdr_month_201406 a_71 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
86. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201407 on cfms_rct_challan_hdr_month_201407 a_72 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
87. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201408 on cfms_rct_challan_hdr_month_201408 a_73 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
88. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201409 on cfms_rct_challan_hdr_month_201409 a_74 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
89. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201410 on cfms_rct_challan_hdr_month_201410 a_75 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
90. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201411 on cfms_rct_challan_hdr_month_201411 a_76 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
91. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201412 on cfms_rct_challan_hdr_month_201412 a_77 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
92. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201501 on cfms_rct_challan_hdr_month_201501 a_78 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
93. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201502 on cfms_rct_challan_hdr_month_201502 a_79 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
94. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201503 on cfms_rct_challan_hdr_month_201503 a_80 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
95. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201504 on cfms_rct_challan_hdr_month_201504 a_81 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
96. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201505 on cfms_rct_challan_hdr_month_201505 a_82 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
97. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201506 on cfms_rct_challan_hdr_month_201506 a_83 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
98. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201507 on cfms_rct_challan_hdr_month_201507 a_84 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
99. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201508 on cfms_rct_challan_hdr_month_201508 a_85 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
100. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201509 on cfms_rct_challan_hdr_month_201509 a_86 (cost=0.14..0.16 rows=1 width=54) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
101. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201510 on cfms_rct_challan_hdr_month_201510 a_87 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
102. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201511 on cfms_rct_challan_hdr_month_201511 a_88 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
103. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201512 on cfms_rct_challan_hdr_month_201512 a_89 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
104. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201601 on cfms_rct_challan_hdr_month_201601 a_90 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
105. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201602 on cfms_rct_challan_hdr_month_201602 a_91 (cost=0.14..0.16 rows=1 width=54) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
106. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201603 on cfms_rct_challan_hdr_month_201603 a_92 (cost=0.14..0.17 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
107. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201604 on cfms_rct_challan_hdr_month_201604 a_93 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
108. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201605 on cfms_rct_challan_hdr_month_201605 a_94 (cost=0.14..0.16 rows=1 width=54) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
109. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201606 on cfms_rct_challan_hdr_month_201606 a_95 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
110. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201607 on cfms_rct_challan_hdr_month_201607 a_96 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
111. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201608 on cfms_rct_challan_hdr_month_201608 a_97 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
112. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201609 on cfms_rct_challan_hdr_month_201609 a_98 (cost=0.14..0.16 rows=1 width=54) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
113. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201610 on cfms_rct_challan_hdr_month_201610 a_99 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
114. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201611 on cfms_rct_challan_hdr_month_201611 a_100 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
115. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201612 on cfms_rct_challan_hdr_month_201612 a_101 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
116. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201701 on cfms_rct_challan_hdr_month_201701 a_102 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
117. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201702 on cfms_rct_challan_hdr_month_201702 a_103 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
118. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201703 on cfms_rct_challan_hdr_month_201703 a_104 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
119. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201704 on cfms_rct_challan_hdr_month_201704 a_105 (cost=0.14..0.16 rows=1 width=54) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
120. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201705 on cfms_rct_challan_hdr_month_201705 a_106 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
121. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201706 on cfms_rct_challan_hdr_month_201706 a_107 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
122. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201707 on cfms_rct_challan_hdr_month_201707 a_108 (cost=0.14..0.16 rows=1 width=46) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
123. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201708 on cfms_rct_challan_hdr_month_201708 a_109 (cost=0.14..0.16 rows=1 width=54) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
124. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201709 on cfms_rct_challan_hdr_month_201709 a_110 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
125. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201710 on cfms_rct_challan_hdr_month_201710 a_111 (cost=0.14..0.16 rows=1 width=54) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
126. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201711 on cfms_rct_challan_hdr_month_201711 a_112 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
127. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201712 on cfms_rct_challan_hdr_month_201712 a_113 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
128. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201801 on cfms_rct_challan_hdr_month_201801 a_114 (cost=0.28..0.30 rows=1 width=44) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
129. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201802 on cfms_rct_challan_hdr_month_201802 a_115 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
130. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201803 on cfms_rct_challan_hdr_month_201803 a_116 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
131. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201804 on cfms_rct_challan_hdr_month_201804 a_117 (cost=0.14..0.19 rows=1 width=44) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
132. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201805 on cfms_rct_challan_hdr_month_201805 a_118 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
133. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201806 on cfms_rct_challan_hdr_month_201806 a_119 (cost=0.14..0.16 rows=1 width=54) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
134. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201807 on cfms_rct_challan_hdr_month_201807 a_120 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
135. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201808 on cfms_rct_challan_hdr_month_201808 a_121 (cost=0.14..0.16 rows=1 width=46) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
136. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201809 on cfms_rct_challan_hdr_month_201809 a_122 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
137. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201810 on cfms_rct_challan_hdr_month_201810 a_123 (cost=0.14..0.16 rows=1 width=44) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
138. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201811 on cfms_rct_challan_hdr_month_201811 a_124 (cost=0.14..0.16 rows=1 width=45) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
139. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201812 on cfms_rct_challan_hdr_month_201812 a_125 (cost=0.14..0.16 rows=1 width=45) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
140. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201901 on cfms_rct_challan_hdr_month_201901 a_126 (cost=0.42..0.55 rows=1 width=45) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
141. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201902 on cfms_rct_challan_hdr_month_201902 a_127 (cost=0.41..0.48 rows=1 width=45) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
142. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201903 on cfms_rct_challan_hdr_month_201903 a_128 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
143. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201904 on cfms_rct_challan_hdr_month_201904 a_129 (cost=0.42..0.52 rows=1 width=45) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
144. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201905 on cfms_rct_challan_hdr_month_201905 a_130 (cost=0.43..0.59 rows=1 width=45) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
145. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201906 on cfms_rct_challan_hdr_month_201906 a_131 (cost=0.43..0.60 rows=1 width=45) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
146. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201907 on cfms_rct_challan_hdr_month_201907 a_132 (cost=0.43..0.60 rows=1 width=45) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
147. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201908 on cfms_rct_challan_hdr_month_201908 a_133 (cost=0.43..0.61 rows=1 width=46) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
148. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201909 on cfms_rct_challan_hdr_month_201909 a_134 (cost=0.43..0.66 rows=1 width=45) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
149. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201910 on cfms_rct_challan_hdr_month_201910 a_135 (cost=0.43..0.67 rows=1 width=46) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
150. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201911 on cfms_rct_challan_hdr_month_201911 a_136 (cost=0.43..0.62 rows=1 width=45) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
151. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201912 on cfms_rct_challan_hdr_month_201912 a_137 (cost=0.43..0.59 rows=1 width=46) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
152. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202001 on cfms_rct_challan_hdr_month_202001 a_138 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
153. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202002 on cfms_rct_challan_hdr_month_202002 a_139 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
154. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202003 on cfms_rct_challan_hdr_month_202003 a_140 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
155. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202004 on cfms_rct_challan_hdr_month_202004 a_141 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
156. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202005 on cfms_rct_challan_hdr_month_202005 a_142 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
157. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202006 on cfms_rct_challan_hdr_month_202006 a_143 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
158. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202007 on cfms_rct_challan_hdr_month_202007 a_144 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
159. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202008 on cfms_rct_challan_hdr_month_202008 a_145 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
160. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202009 on cfms_rct_challan_hdr_month_202009 a_146 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
161. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202010 on cfms_rct_challan_hdr_month_202010 a_147 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
162. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202011 on cfms_rct_challan_hdr_month_202011 a_148 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
163. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202012 on cfms_rct_challan_hdr_month_202012 a_149 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
164. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202101 on cfms_rct_challan_hdr_month_202101 a_150 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
165. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202102 on cfms_rct_challan_hdr_month_202102 a_151 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
166. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202103 on cfms_rct_challan_hdr_month_202103 a_152 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
167. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202104 on cfms_rct_challan_hdr_month_202104 a_153 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
168. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202105 on cfms_rct_challan_hdr_month_202105 a_154 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
169. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202106 on cfms_rct_challan_hdr_month_202106 a_155 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
170. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202107 on cfms_rct_challan_hdr_month_202107 a_156 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
171. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202108 on cfms_rct_challan_hdr_month_202108 a_157 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
172. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202109 on cfms_rct_challan_hdr_month_202109 a_158 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
173. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202110 on cfms_rct_challan_hdr_month_202110 a_159 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
174. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202111 on cfms_rct_challan_hdr_month_202111 a_160 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
175. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202112 on cfms_rct_challan_hdr_month_202112 a_161 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
176. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202201 on cfms_rct_challan_hdr_month_202201 a_162 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
177. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202202 on cfms_rct_challan_hdr_month_202202 a_163 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
178. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202203 on cfms_rct_challan_hdr_month_202203 a_164 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
179. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202204 on cfms_rct_challan_hdr_month_202204 a_165 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
180. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202205 on cfms_rct_challan_hdr_month_202205 a_166 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
181. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202206 on cfms_rct_challan_hdr_month_202206 a_167 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
182. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202207 on cfms_rct_challan_hdr_month_202207 a_168 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
183. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202208 on cfms_rct_challan_hdr_month_202208 a_169 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
184. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202209 on cfms_rct_challan_hdr_month_202209 a_170 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
185. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202210 on cfms_rct_challan_hdr_month_202210 a_171 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
186. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202211 on cfms_rct_challan_hdr_month_202211 a_172 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
187. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202212 on cfms_rct_challan_hdr_month_202212 a_173 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
188. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202301 on cfms_rct_challan_hdr_month_202301 a_174 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
189. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202302 on cfms_rct_challan_hdr_month_202302 a_175 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
190. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202303 on cfms_rct_challan_hdr_month_202303 a_176 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
191. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202304 on cfms_rct_challan_hdr_month_202304 a_177 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
192. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202305 on cfms_rct_challan_hdr_month_202305 a_178 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
193. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202306 on cfms_rct_challan_hdr_month_202306 a_179 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
194. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202307 on cfms_rct_challan_hdr_month_202307 a_180 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
195. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202308 on cfms_rct_challan_hdr_month_202308 a_181 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
196. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202309 on cfms_rct_challan_hdr_month_202309 a_182 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
197. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202310 on cfms_rct_challan_hdr_month_202310 a_183 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
198. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202311 on cfms_rct_challan_hdr_month_202311 a_184 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
199. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202312 on cfms_rct_challan_hdr_month_202312 a_185 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
200. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202401 on cfms_rct_challan_hdr_month_202401 a_186 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
201. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202402 on cfms_rct_challan_hdr_month_202402 a_187 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
202. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202403 on cfms_rct_challan_hdr_month_202403 a_188 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
203. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202404 on cfms_rct_challan_hdr_month_202404 a_189 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
204. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202405 on cfms_rct_challan_hdr_month_202405 a_190 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
205. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202406 on cfms_rct_challan_hdr_month_202406 a_191 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
206. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202407 on cfms_rct_challan_hdr_month_202407 a_192 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
207. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202408 on cfms_rct_challan_hdr_month_202408 a_193 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
208. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202409 on cfms_rct_challan_hdr_month_202409 a_194 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
209. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202410 on cfms_rct_challan_hdr_month_202410 a_195 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
210. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202411 on cfms_rct_challan_hdr_month_202411 a_196 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
211. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202412 on cfms_rct_challan_hdr_month_202412 a_197 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
212. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202501 on cfms_rct_challan_hdr_month_202501 a_198 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
213. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202502 on cfms_rct_challan_hdr_month_202502 a_199 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
214. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202503 on cfms_rct_challan_hdr_month_202503 a_200 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
215. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202504 on cfms_rct_challan_hdr_month_202504 a_201 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
216. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202505 on cfms_rct_challan_hdr_month_202505 a_202 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
217. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202506 on cfms_rct_challan_hdr_month_202506 a_203 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
218. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202507 on cfms_rct_challan_hdr_month_202507 a_204 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
219. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202508 on cfms_rct_challan_hdr_month_202508 a_205 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
220. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202509 on cfms_rct_challan_hdr_month_202509 a_206 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
221. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202510 on cfms_rct_challan_hdr_month_202510 a_207 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
222. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202511 on cfms_rct_challan_hdr_month_202511 a_208 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
223. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202512 on cfms_rct_challan_hdr_month_202512 a_209 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
224. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_nth_1q on cfms_rct_challan_hdr_month_1q a_210 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
225. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_nth_2q on cfms_rct_challan_hdr_month_2q a_211 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
226. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_nth_3q on cfms_rct_challan_hdr_month_3q a_212 (cost=0.14..0.16 rows=1 width=45) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
227. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_nth_4q on cfms_rct_challan_hdr_month_4q a_213 (cost=0.12..0.15 rows=1 width=57) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
228. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_nth_5q on cfms_rct_challan_hdr_month_5q a_214 (cost=0.12..0.15 rows=1 width=57) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
229. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_nth_6q on cfms_rct_challan_hdr_month_6q a_215 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
230. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_nth_7q on cfms_rct_challan_hdr_month_7q a_216 (cost=0.13..0.15 rows=1 width=56) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
231. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_nth_8q on cfms_rct_challan_hdr_month_8q a_217 (cost=0.12..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
232. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_nth_9q on cfms_rct_challan_hdr_month_9q a_218 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
233. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_th_10q on cfms_rct_challan_hdr_month_10q a_219 (cost=0.13..0.15 rows=1 width=56) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
234. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_th_11q on cfms_rct_challan_hdr_month_11q a_220 (cost=0.12..0.15 rows=1 width=57) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
235. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_th_12q on cfms_rct_challan_hdr_month_12q a_221 (cost=0.13..0.15 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b.txn_id)
  • Filter: ((processing_flag)::text <> ALL ('{X,A,R}'::text[]))
236. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_deposit_account_master d (cost=0.00..2.78 rows=11 width=44) (never executed)

  • Filter: ((deposite_type)::text <> ALL ('{PLA,PDA,PWD,FOR}'::text[]))
237. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..54.19 rows=222 width=24) (never executed)

238. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_dtl e (cost=0.00..0.00 rows=1 width=52) (never executed)

  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date) AND ((a.treasury_code)::text = (treasury_code)::text))
239. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_dtl_p_2010 e_1 (cost=0.00..0.00 rows=1 width=52) (never executed)

  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date) AND ((a.treasury_code)::text = (treasury_code)::text))
240. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_dtl_p_2011 e_2 (cost=0.00..0.00 rows=1 width=52) (never executed)

  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date) AND ((a.treasury_code)::text = (treasury_code)::text))
241. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_dtl_p_2012 e_3 (cost=0.00..0.00 rows=1 width=52) (never executed)

  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date) AND ((a.treasury_code)::text = (treasury_code)::text))
242. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_dtl_p_2013 e_4 (cost=0.00..0.00 rows=1 width=52) (never executed)

  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date) AND ((a.treasury_code)::text = (treasury_code)::text))
243. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_dtl_p_2014 e_5 (cost=0.00..0.00 rows=1 width=52) (never executed)

  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date) AND ((a.treasury_code)::text = (treasury_code)::text))
244. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_dtl_p_2015 e_6 (cost=0.00..0.00 rows=1 width=52) (never executed)

  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date) AND ((a.treasury_code)::text = (treasury_code)::text))
245. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_dtl_p_2016 e_7 (cost=0.00..0.00 rows=1 width=52) (never executed)

  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date) AND ((a.treasury_code)::text = (treasury_code)::text))
246. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_dtl_p_2017 e_8 (cost=0.00..0.00 rows=1 width=52) (never executed)

  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date) AND ((a.treasury_code)::text = (treasury_code)::text))
247. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_dtl_p_2018 e_9 (cost=0.00..0.00 rows=1 width=52) (never executed)

  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date) AND ((a.treasury_code)::text = (treasury_code)::text))
248. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_dtl_p_2019 e_10 (cost=0.00..0.00 rows=1 width=52) (never executed)

  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date) AND ((a.treasury_code)::text = (treasury_code)::text))
249. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_dtl_p_2020 e_11 (cost=0.00..0.00 rows=1 width=52) (never executed)

  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date) AND ((a.treasury_code)::text = (treasury_code)::text))
250. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_dtl_p_2021 e_12 (cost=0.00..0.00 rows=1 width=52) (never executed)

  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date) AND ((a.treasury_code)::text = (treasury_code)::text))
251. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_dtl_p_2022 e_13 (cost=0.00..0.00 rows=1 width=52) (never executed)

  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date) AND ((a.treasury_code)::text = (treasury_code)::text))
252. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_dtl_p_2023 e_14 (cost=0.00..0.00 rows=1 width=52) (never executed)

  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date) AND ((a.treasury_code)::text = (treasury_code)::text))
253. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_dtl_p_2024 e_15 (cost=0.00..0.00 rows=1 width=52) (never executed)

  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date) AND ((a.treasury_code)::text = (treasury_code)::text))
254. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_dtl_p_2025 e_16 (cost=0.00..0.00 rows=1 width=52) (never executed)

  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date) AND ((a.treasury_code)::text = (treasury_code)::text))
255. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_dtl_p_other_yrs e_17 (cost=0.00..0.00 rows=1 width=52) (never executed)

  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date) AND ((a.treasury_code)::text = (treasury_code)::text))
256. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201001 on cfms_rct_challan_dtl_month_201001 e_18 (cost=0.14..0.16 rows=1 width=25) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
257. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201002 on cfms_rct_challan_dtl_month_201002 e_19 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
258. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201003 on cfms_rct_challan_dtl_month_201003 e_20 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
259. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201004 on cfms_rct_challan_dtl_month_201004 e_21 (cost=0.12..0.15 rows=1 width=26) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
260. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201005 on cfms_rct_challan_dtl_month_201005 e_22 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
261. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201006 on cfms_rct_challan_dtl_month_201006 e_23 (cost=0.13..0.15 rows=1 width=25) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
262. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201007 on cfms_rct_challan_dtl_month_201007 e_24 (cost=0.13..0.16 rows=1 width=25) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
263. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201008 on cfms_rct_challan_dtl_month_201008 e_25 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
264. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201009_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201009 e_26 (cost=0.13..0.15 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
265. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201010_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201010 e_27 (cost=0.13..0.16 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
266. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201011_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201011 e_28 (cost=0.13..0.15 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
267. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201012 on cfms_rct_challan_dtl_month_201012 e_29 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
268. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201101 on cfms_rct_challan_dtl_month_201101 e_30 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
269. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201102 on cfms_rct_challan_dtl_month_201102 e_31 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
270. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201103_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201103 e_32 (cost=0.14..0.16 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
271. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201104 on cfms_rct_challan_dtl_month_201104 e_33 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
272. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201105 on cfms_rct_challan_dtl_month_201105 e_34 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
273. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201106 on cfms_rct_challan_dtl_month_201106 e_35 (cost=0.13..0.15 rows=1 width=24) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
274. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201107 on cfms_rct_challan_dtl_month_201107 e_36 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
275. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201108 on cfms_rct_challan_dtl_month_201108 e_37 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
276. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201109_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201109 e_38 (cost=0.13..0.16 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
277. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201110 on cfms_rct_challan_dtl_month_201110 e_39 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
278. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201111 on cfms_rct_challan_dtl_month_201111 e_40 (cost=0.13..0.16 rows=1 width=25) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
279. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201112 on cfms_rct_challan_dtl_month_201112 e_41 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
280. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201201 on cfms_rct_challan_dtl_month_201201 e_42 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
281. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201202 on cfms_rct_challan_dtl_month_201202 e_43 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
282. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201203_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201203 e_44 (cost=0.14..0.16 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
283. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201204 on cfms_rct_challan_dtl_month_201204 e_45 (cost=0.13..0.15 rows=1 width=25) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
284. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201205 on cfms_rct_challan_dtl_month_201205 e_46 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
285. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201206 on cfms_rct_challan_dtl_month_201206 e_47 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
286. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201207 on cfms_rct_challan_dtl_month_201207 e_48 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
287. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201208 on cfms_rct_challan_dtl_month_201208 e_49 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
288. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201209 on cfms_rct_challan_dtl_month_201209 e_50 (cost=0.14..0.16 rows=1 width=24) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
289. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201210 on cfms_rct_challan_dtl_month_201210 e_51 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
290. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201211 on cfms_rct_challan_dtl_month_201211 e_52 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
291. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201212 on cfms_rct_challan_dtl_month_201212 e_53 (cost=0.14..0.16 rows=1 width=24) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
292. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201301 on cfms_rct_challan_dtl_month_201301 e_54 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
293. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201302 on cfms_rct_challan_dtl_month_201302 e_55 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
294. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201303 on cfms_rct_challan_dtl_month_201303 e_56 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
295. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201304 on cfms_rct_challan_dtl_month_201304 e_57 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
296. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201305 on cfms_rct_challan_dtl_month_201305 e_58 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
297. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201306 on cfms_rct_challan_dtl_month_201306 e_59 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
298. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201307 on cfms_rct_challan_dtl_month_201307 e_60 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
299. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201308 on cfms_rct_challan_dtl_month_201308 e_61 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
300. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201309 on cfms_rct_challan_dtl_month_201309 e_62 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
301. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201310 on cfms_rct_challan_dtl_month_201310 e_63 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
302. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201311 on cfms_rct_challan_dtl_month_201311 e_64 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
303. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201312_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201312 e_65 (cost=0.14..0.16 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
304. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201401_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201401 e_66 (cost=0.14..0.16 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
305. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201402_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201402 e_67 (cost=0.14..0.16 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
306. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201403 on cfms_rct_challan_dtl_month_201403 e_68 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
307. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201404 on cfms_rct_challan_dtl_month_201404 e_69 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
308. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201405_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201405 e_70 (cost=0.14..0.16 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
309. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201406 on cfms_rct_challan_dtl_month_201406 e_71 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
310. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201407_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201407 e_72 (cost=0.14..0.16 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
311. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201408 on cfms_rct_challan_dtl_month_201408 e_73 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
312. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201409 on cfms_rct_challan_dtl_month_201409 e_74 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
313. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201410 on cfms_rct_challan_dtl_month_201410 e_75 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
314. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201411_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201411 e_76 (cost=0.14..0.16 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
315. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201412_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201412 e_77 (cost=0.14..0.16 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
316. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201501 on cfms_rct_challan_dtl_month_201501 e_78 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
317. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201502 on cfms_rct_challan_dtl_month_201502 e_79 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
318. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201503_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201503 e_80 (cost=0.14..0.17 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
319. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201504 on cfms_rct_challan_dtl_month_201504 e_81 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
320. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201505 on cfms_rct_challan_dtl_month_201505 e_82 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
321. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201506_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201506 e_83 (cost=0.14..0.16 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
322. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201507 on cfms_rct_challan_dtl_month_201507 e_84 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
323. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201508_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201508 e_85 (cost=0.14..0.16 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
324. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201509 on cfms_rct_challan_dtl_month_201509 e_86 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
325. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201510_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201510 e_87 (cost=0.14..0.16 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
326. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201511 on cfms_rct_challan_dtl_month_201511 e_88 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
327. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201512 on cfms_rct_challan_dtl_month_201512 e_89 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
328. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201601 on cfms_rct_challan_dtl_month_201601 e_90 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
329. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201602_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201602 e_91 (cost=0.14..0.17 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
330. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201603_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201603 e_92 (cost=0.14..0.17 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
331. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201604_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201604 e_93 (cost=0.14..0.16 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
332. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201605_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201605 e_94 (cost=0.14..0.16 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
333. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201606 on cfms_rct_challan_dtl_month_201606 e_95 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
334. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201607_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201607 e_96 (cost=0.14..0.16 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
335. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201608_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201608 e_97 (cost=0.14..0.17 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
336. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201609_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201609 e_98 (cost=0.14..0.16 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
337. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201610_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201610 e_99 (cost=0.14..0.16 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
338. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201611_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201611 e_100 (cost=0.14..0.16 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
339. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201612 on cfms_rct_challan_dtl_month_201612 e_101 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
340. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201701 on cfms_rct_challan_dtl_month_201701 e_102 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
341. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201702_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201702 e_103 (cost=0.14..0.16 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
342. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201703 on cfms_rct_challan_dtl_month_201703 e_104 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
343. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201704 on cfms_rct_challan_dtl_month_201704 e_105 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
344. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201705 on cfms_rct_challan_dtl_month_201705 e_106 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
345. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201706_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201706 e_107 (cost=0.14..0.16 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
346. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201707 on cfms_rct_challan_dtl_month_201707 e_108 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
347. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201708 on cfms_rct_challan_dtl_month_201708 e_109 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
348. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201709 on cfms_rct_challan_dtl_month_201709 e_110 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
349. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201710 on cfms_rct_challan_dtl_month_201710 e_111 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
350. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201711 on cfms_rct_challan_dtl_month_201711 e_112 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
351. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201712_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201712 e_113 (cost=0.14..0.16 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
352. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201801_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201801 e_114 (cost=0.28..0.30 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
353. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201802_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201802 e_115 (cost=0.14..0.17 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
354. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201803 on cfms_rct_challan_dtl_month_201803 e_116 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
355. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201804 on cfms_rct_challan_dtl_month_201804 e_117 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
356. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201805 on cfms_rct_challan_dtl_month_201805 e_118 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
357. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201806 on cfms_rct_challan_dtl_month_201806 e_119 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
358. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201807 on cfms_rct_challan_dtl_month_201807 e_120 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
359. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201808_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201808 e_121 (cost=0.14..0.17 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
360. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201809 on cfms_rct_challan_dtl_month_201809 e_122 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
361. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201810_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201810 e_123 (cost=0.14..0.17 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
362. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_201811 on cfms_rct_challan_dtl_month_201811 e_124 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
363. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201812_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201812 e_125 (cost=0.14..0.17 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
364. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201901_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201901 e_126 (cost=0.42..1.25 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
365. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201902_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201902 e_127 (cost=0.41..0.49 rows=1 width=23) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
366. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201903_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201903 e_128 (cost=0.14..0.16 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
367. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201904_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201904 e_129 (cost=0.42..1.53 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
368. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201905_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201905 e_130 (cost=0.43..1.75 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
369. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201906_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201906 e_131 (cost=0.43..1.91 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
370. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201907_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201907 e_132 (cost=0.55..2.30 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
371. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201908_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201908 e_133 (cost=0.55..2.41 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
372. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201909_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201909 e_134 (cost=0.55..2.42 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
373. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201910_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201910 e_135 (cost=0.56..2.74 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
374. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201911_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201911 e_136 (cost=0.56..2.78 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
375. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_201912_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_201912 e_137 (cost=0.55..2.51 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
376. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202001 on cfms_rct_challan_dtl_month_202001 e_138 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
377. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202002 on cfms_rct_challan_dtl_month_202002 e_139 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
378. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202003 on cfms_rct_challan_dtl_month_202003 e_140 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
379. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202004 on cfms_rct_challan_dtl_month_202004 e_141 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
380. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202005 on cfms_rct_challan_dtl_month_202005 e_142 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
381. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202006 on cfms_rct_challan_dtl_month_202006 e_143 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
382. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202007 on cfms_rct_challan_dtl_month_202007 e_144 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
383. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202008 on cfms_rct_challan_dtl_month_202008 e_145 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
384. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202009 on cfms_rct_challan_dtl_month_202009 e_146 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
385. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202010 on cfms_rct_challan_dtl_month_202010 e_147 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
386. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202011 on cfms_rct_challan_dtl_month_202011 e_148 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
387. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202012 on cfms_rct_challan_dtl_month_202012 e_149 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
388. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202101 on cfms_rct_challan_dtl_month_202101 e_150 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
389. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202102 on cfms_rct_challan_dtl_month_202102 e_151 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
390. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202103 on cfms_rct_challan_dtl_month_202103 e_152 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
391. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202104 on cfms_rct_challan_dtl_month_202104 e_153 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
392. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202105 on cfms_rct_challan_dtl_month_202105 e_154 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
393. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202106 on cfms_rct_challan_dtl_month_202106 e_155 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
394. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202107 on cfms_rct_challan_dtl_month_202107 e_156 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
395. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202108 on cfms_rct_challan_dtl_month_202108 e_157 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
396. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202109 on cfms_rct_challan_dtl_month_202109 e_158 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
397. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202110 on cfms_rct_challan_dtl_month_202110 e_159 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
398. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202111 on cfms_rct_challan_dtl_month_202111 e_160 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
399. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202112 on cfms_rct_challan_dtl_month_202112 e_161 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
400. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202201 on cfms_rct_challan_dtl_month_202201 e_162 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
401. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202202 on cfms_rct_challan_dtl_month_202202 e_163 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
402. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202203 on cfms_rct_challan_dtl_month_202203 e_164 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
403. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202204 on cfms_rct_challan_dtl_month_202204 e_165 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
404. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202205 on cfms_rct_challan_dtl_month_202205 e_166 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
405. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202206 on cfms_rct_challan_dtl_month_202206 e_167 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
406. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202207 on cfms_rct_challan_dtl_month_202207 e_168 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
407. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202208 on cfms_rct_challan_dtl_month_202208 e_169 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
408. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202209 on cfms_rct_challan_dtl_month_202209 e_170 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
409. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202210 on cfms_rct_challan_dtl_month_202210 e_171 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
410. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202211 on cfms_rct_challan_dtl_month_202211 e_172 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
411. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202212 on cfms_rct_challan_dtl_month_202212 e_173 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
412. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202301 on cfms_rct_challan_dtl_month_202301 e_174 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
413. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202302 on cfms_rct_challan_dtl_month_202302 e_175 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
414. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202303 on cfms_rct_challan_dtl_month_202303 e_176 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
415. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202304 on cfms_rct_challan_dtl_month_202304 e_177 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
416. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202305 on cfms_rct_challan_dtl_month_202305 e_178 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
417. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202306 on cfms_rct_challan_dtl_month_202306 e_179 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
418. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202307 on cfms_rct_challan_dtl_month_202307 e_180 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
419. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202308 on cfms_rct_challan_dtl_month_202308 e_181 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
420. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202309 on cfms_rct_challan_dtl_month_202309 e_182 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
421. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202310 on cfms_rct_challan_dtl_month_202310 e_183 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
422. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202311 on cfms_rct_challan_dtl_month_202311 e_184 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
423. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202312 on cfms_rct_challan_dtl_month_202312 e_185 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
424. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202401 on cfms_rct_challan_dtl_month_202401 e_186 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
425. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202402 on cfms_rct_challan_dtl_month_202402 e_187 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
426. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202403 on cfms_rct_challan_dtl_month_202403 e_188 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
427. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202404 on cfms_rct_challan_dtl_month_202404 e_189 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
428. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202405 on cfms_rct_challan_dtl_month_202405 e_190 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
429. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202406 on cfms_rct_challan_dtl_month_202406 e_191 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
430. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202407 on cfms_rct_challan_dtl_month_202407 e_192 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
431. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202408 on cfms_rct_challan_dtl_month_202408 e_193 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
432. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202409 on cfms_rct_challan_dtl_month_202409 e_194 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
433. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202410 on cfms_rct_challan_dtl_month_202410 e_195 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
434. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202411 on cfms_rct_challan_dtl_month_202411 e_196 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
435. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202412 on cfms_rct_challan_dtl_month_202412 e_197 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
436. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202501 on cfms_rct_challan_dtl_month_202501 e_198 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
437. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202502 on cfms_rct_challan_dtl_month_202502 e_199 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
438. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202503 on cfms_rct_challan_dtl_month_202503 e_200 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
439. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202504 on cfms_rct_challan_dtl_month_202504 e_201 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
440. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202505 on cfms_rct_challan_dtl_month_202505 e_202 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
441. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202506 on cfms_rct_challan_dtl_month_202506 e_203 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
442. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202507 on cfms_rct_challan_dtl_month_202507 e_204 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
443. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202508 on cfms_rct_challan_dtl_month_202508 e_205 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
444. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202509 on cfms_rct_challan_dtl_month_202509 e_206 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
445. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202510 on cfms_rct_challan_dtl_month_202510 e_207 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
446. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202511 on cfms_rct_challan_dtl_month_202511 e_208 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
447. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_202512 on cfms_rct_challan_dtl_month_202512 e_209 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
448. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_nth_1q on cfms_rct_challan_dtl_month_1q e_210 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
449. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_2q_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_2q e_211 (cost=0.14..0.16 rows=1 width=24) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
450. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_nth_3q on cfms_rct_challan_dtl_month_3q e_212 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
451. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_nth_4q on cfms_rct_challan_dtl_month_4q e_213 (cost=0.12..0.15 rows=1 width=26) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
452. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_nth_5q on cfms_rct_challan_dtl_month_5q e_214 (cost=0.12..0.15 rows=1 width=26) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
453. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_nth_6q on cfms_rct_challan_dtl_month_6q e_215 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
454. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_nth_7q on cfms_rct_challan_dtl_month_7q e_216 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
455. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_nth_8q on cfms_rct_challan_dtl_month_8q e_217 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
456. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl_month_9q_cfms_rct_challan_dtl1_pk on cfms_rct_challan_dtl_month_9q e_218 (cost=0.13..0.16 rows=1 width=25) (never executed)

  • Index Cond: (((treasury_code)::text = (a.treasury_code)::text) AND (challan_seq = a.challan_seq) AND (challan_date = a.challan_date))
457. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_th_10q on cfms_rct_challan_dtl_month_10q e_219 (cost=0.13..0.15 rows=1 width=25) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
458. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_th_11q on cfms_rct_challan_dtl_month_11q e_220 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
459. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_dtl1_idx3_th_12q on cfms_rct_challan_dtl_month_12q e_221 (cost=0.14..0.17 rows=1 width=52) (never executed)

  • Index Cond: ((treasury_code)::text = (a.treasury_code)::text)
  • Filter: ((a.challan_seq = challan_seq) AND (a.challan_date = challan_date))
460. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_cfms_mm_gen_hoa on cfms_mm_gen_hoa f (cost=0.29..0.31 rows=1 width=23) (never executed)

  • Index Cond: (hoa_id = e.hoa_id)
461. 0.002 5.001 ↓ 0.0 0 1

GroupAggregate (cost=13,922.46..13,922.49 rows=1 width=93) (actual time=5.001..5.001 rows=0 loops=1)

  • Group Key: b_1.parent_txn_id, (edb_ora_timestamp_tochar_immutable(a_222.challan_date, 'dd/mm/yyyy'::character varying)), d_1.receipt_description
462. 0.017 4.999 ↓ 0.0 0 1

Sort (cost=13,922.46..13,922.46 rows=1 width=67) (actual time=4.999..4.999 rows=0 loops=1)

  • Sort Key: b_1.parent_txn_id, (edb_ora_timestamp_tochar_immutable(a_222.challan_date, 'dd/mm/yyyy'::character varying)), d_1.receipt_description
  • Sort Method: quicksort Memory: 25kB
463. 0.002 4.982 ↓ 0.0 0 1

Nested Loop (cost=193.37..13,922.45 rows=1 width=67) (actual time=4.982..4.982 rows=0 loops=1)

464. 0.000 4.980 ↓ 0.0 0 1

Nested Loop (cost=193.37..13,862.67 rows=1 width=53) (actual time=4.980..4.980 rows=0 loops=1)

  • Join Filter: ((a_222.challan_type)::text = (d_1.receipt_type)::text)
465. 0.001 4.980 ↓ 0.0 0 1

Nested Loop (cost=193.37..13,861.57 rows=1 width=40) (actual time=4.980..4.980 rows=0 loops=1)

466. 0.000 4.979 ↓ 0.0 0 1

Nested Loop (cost=193.37..13,621.27 rows=6 width=50) (actual time=4.979..4.979 rows=0 loops=1)

467. 3.974 4.979 ↓ 0.0 0 1

Bitmap Heap Scan on cfms_wf_workflow_dtl c_1 (cost=192.82..13,575.76 rows=6 width=19) (actual time=4.979..4.979 rows=0 loops=1)

  • Recheck Cond: ((next_post_id = '65567'::numeric) AND (wf_status = 'C'::bpchar))
  • Filter: (((action_id)::text <> '3'::text) AND (next_role_id = '1'::numeric))
  • Rows Removed by Filter: 5775
  • Heap Blocks: exact=1643
468. 1.005 1.005 ↓ 1.4 5,777 1

Bitmap Index Scan on cfms_wf_workflow_dtl_idx1 (cost=0.00..192.81 rows=4,168 width=0) (actual time=1.005..1.005 rows=5,777 loops=1)

  • Index Cond: (next_post_id = '65567'::numeric)
469. 0.000 0.000 ↓ 0.0 0

Index Scan using wef_a1 on cfms_wf_workflow_hdr b_1 (cost=0.56..7.57 rows=1 width=31) (never executed)

  • Index Cond: (txn_id = c_1.txn_id)
470. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..37.83 rows=222 width=48) (never executed)

471. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr a_222 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: (((challan_type)::text <> 'BT'::text) AND (b_1.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
472. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2010 a_223 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: (((challan_type)::text <> 'BT'::text) AND (b_1.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
473. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2011 a_224 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: (((challan_type)::text <> 'BT'::text) AND (b_1.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
474. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2012 a_225 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: (((challan_type)::text <> 'BT'::text) AND (b_1.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
475. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2013 a_226 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: (((challan_type)::text <> 'BT'::text) AND (b_1.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
476. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2014 a_227 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: (((challan_type)::text <> 'BT'::text) AND (b_1.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
477. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2015 a_228 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: (((challan_type)::text <> 'BT'::text) AND (b_1.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
478. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2016 a_229 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: (((challan_type)::text <> 'BT'::text) AND (b_1.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
479. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2017 a_230 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: (((challan_type)::text <> 'BT'::text) AND (b_1.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
480. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2018 a_231 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: (((challan_type)::text <> 'BT'::text) AND (b_1.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
481. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2019 a_232 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: (((challan_type)::text <> 'BT'::text) AND (b_1.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
482. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2020 a_233 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: (((challan_type)::text <> 'BT'::text) AND (b_1.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
483. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2021 a_234 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: (((challan_type)::text <> 'BT'::text) AND (b_1.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
484. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2022 a_235 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: (((challan_type)::text <> 'BT'::text) AND (b_1.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
485. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2023 a_236 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: (((challan_type)::text <> 'BT'::text) AND (b_1.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
486. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2024 a_237 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: (((challan_type)::text <> 'BT'::text) AND (b_1.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
487. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_2025 a_238 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: (((challan_type)::text <> 'BT'::text) AND (b_1.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
488. 0.000 0.000 ↓ 0.0 0

Seq Scan on cfms_rct_challan_hdr_p_other_yrs a_239 (cost=0.00..0.00 rows=1 width=100) (never executed)

  • Filter: (((challan_type)::text <> 'BT'::text) AND (b_1.txn_id = txn_id) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
489. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201001 on cfms_rct_challan_hdr_month_201001 a_240 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
490. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201002 on cfms_rct_challan_hdr_month_201002 a_241 (cost=0.13..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
491. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201003 on cfms_rct_challan_hdr_month_201003 a_242 (cost=0.13..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
492. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201004 on cfms_rct_challan_hdr_month_201004 a_243 (cost=0.12..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
493. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201005 on cfms_rct_challan_hdr_month_201005 a_244 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
494. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201006 on cfms_rct_challan_hdr_month_201006 a_245 (cost=0.12..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
495. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201007 on cfms_rct_challan_hdr_month_201007 a_246 (cost=0.13..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
496. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201008 on cfms_rct_challan_hdr_month_201008 a_247 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
497. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201009 on cfms_rct_challan_hdr_month_201009 a_248 (cost=0.13..0.15 rows=1 width=56) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
498. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201010 on cfms_rct_challan_hdr_month_201010 a_249 (cost=0.13..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
499. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201011 on cfms_rct_challan_hdr_month_201011 a_250 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
500. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201012 on cfms_rct_challan_hdr_month_201012 a_251 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
501. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201101 on cfms_rct_challan_hdr_month_201101 a_252 (cost=0.13..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
502. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201102 on cfms_rct_challan_hdr_month_201102 a_253 (cost=0.13..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
503. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201103 on cfms_rct_challan_hdr_month_201103 a_254 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
504. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201104 on cfms_rct_challan_hdr_month_201104 a_255 (cost=0.13..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
505. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201105 on cfms_rct_challan_hdr_month_201105 a_256 (cost=0.13..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
506. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201106 on cfms_rct_challan_hdr_month_201106 a_257 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
507. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201107 on cfms_rct_challan_hdr_month_201107 a_258 (cost=0.13..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
508. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201108 on cfms_rct_challan_hdr_month_201108 a_259 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
509. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201109 on cfms_rct_challan_hdr_month_201109 a_260 (cost=0.13..0.16 rows=1 width=54) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
510. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201110 on cfms_rct_challan_hdr_month_201110 a_261 (cost=0.13..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
511. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201111 on cfms_rct_challan_hdr_month_201111 a_262 (cost=0.13..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
512. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201112 on cfms_rct_challan_hdr_month_201112 a_263 (cost=0.13..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
513. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201201 on cfms_rct_challan_hdr_month_201201 a_264 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
514. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201202 on cfms_rct_challan_hdr_month_201202 a_265 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
515. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201203 on cfms_rct_challan_hdr_month_201203 a_266 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
516. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201204 on cfms_rct_challan_hdr_month_201204 a_267 (cost=0.13..0.15 rows=1 width=56) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
517. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201205 on cfms_rct_challan_hdr_month_201205 a_268 (cost=0.13..0.15 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
518. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201206 on cfms_rct_challan_hdr_month_201206 a_269 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
519. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201207 on cfms_rct_challan_hdr_month_201207 a_270 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
520. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201208 on cfms_rct_challan_hdr_month_201208 a_271 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
521. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201209 on cfms_rct_challan_hdr_month_201209 a_272 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
522. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201210 on cfms_rct_challan_hdr_month_201210 a_273 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
523. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201211 on cfms_rct_challan_hdr_month_201211 a_274 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
524. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201212 on cfms_rct_challan_hdr_month_201212 a_275 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
525. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201301 on cfms_rct_challan_hdr_month_201301 a_276 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
526. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201302 on cfms_rct_challan_hdr_month_201302 a_277 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
527. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201303 on cfms_rct_challan_hdr_month_201303 a_278 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
528. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201304 on cfms_rct_challan_hdr_month_201304 a_279 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
529. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201305 on cfms_rct_challan_hdr_month_201305 a_280 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
530. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201306 on cfms_rct_challan_hdr_month_201306 a_281 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
531. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201307 on cfms_rct_challan_hdr_month_201307 a_282 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
532. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201308 on cfms_rct_challan_hdr_month_201308 a_283 (cost=0.14..0.17 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
533. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201309 on cfms_rct_challan_hdr_month_201309 a_284 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
534. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201310 on cfms_rct_challan_hdr_month_201310 a_285 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
535. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201311 on cfms_rct_challan_hdr_month_201311 a_286 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
536. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201312 on cfms_rct_challan_hdr_month_201312 a_287 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
537. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201401 on cfms_rct_challan_hdr_month_201401 a_288 (cost=0.14..0.16 rows=1 width=54) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
538. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201402 on cfms_rct_challan_hdr_month_201402 a_289 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
539. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201403 on cfms_rct_challan_hdr_month_201403 a_290 (cost=0.14..0.17 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
540. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201404 on cfms_rct_challan_hdr_month_201404 a_291 (cost=0.14..0.17 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
541. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201405 on cfms_rct_challan_hdr_month_201405 a_292 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
542. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201406 on cfms_rct_challan_hdr_month_201406 a_293 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
543. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201407 on cfms_rct_challan_hdr_month_201407 a_294 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
544. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201408 on cfms_rct_challan_hdr_month_201408 a_295 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
545. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201409 on cfms_rct_challan_hdr_month_201409 a_296 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
546. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201410 on cfms_rct_challan_hdr_month_201410 a_297 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
547. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201411 on cfms_rct_challan_hdr_month_201411 a_298 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
548. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201412 on cfms_rct_challan_hdr_month_201412 a_299 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
549. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201501 on cfms_rct_challan_hdr_month_201501 a_300 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
550. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201502 on cfms_rct_challan_hdr_month_201502 a_301 (cost=0.14..0.17 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
551. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201503 on cfms_rct_challan_hdr_month_201503 a_302 (cost=0.14..0.17 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
552. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201504 on cfms_rct_challan_hdr_month_201504 a_303 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
553. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201505 on cfms_rct_challan_hdr_month_201505 a_304 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
554. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201506 on cfms_rct_challan_hdr_month_201506 a_305 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
555. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201507 on cfms_rct_challan_hdr_month_201507 a_306 (cost=0.14..0.17 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
556. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201508 on cfms_rct_challan_hdr_month_201508 a_307 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
557. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201509 on cfms_rct_challan_hdr_month_201509 a_308 (cost=0.14..0.16 rows=1 width=54) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
558. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201510 on cfms_rct_challan_hdr_month_201510 a_309 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
559. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201511 on cfms_rct_challan_hdr_month_201511 a_310 (cost=0.14..0.17 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
560. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201512 on cfms_rct_challan_hdr_month_201512 a_311 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
561. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201601 on cfms_rct_challan_hdr_month_201601 a_312 (cost=0.14..0.17 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
562. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201602 on cfms_rct_challan_hdr_month_201602 a_313 (cost=0.14..0.17 rows=1 width=54) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
563. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201603 on cfms_rct_challan_hdr_month_201603 a_314 (cost=0.14..0.17 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
564. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201604 on cfms_rct_challan_hdr_month_201604 a_315 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
565. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201605 on cfms_rct_challan_hdr_month_201605 a_316 (cost=0.14..0.16 rows=1 width=54) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
566. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201606 on cfms_rct_challan_hdr_month_201606 a_317 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
567. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201607 on cfms_rct_challan_hdr_month_201607 a_318 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
568. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201608 on cfms_rct_challan_hdr_month_201608 a_319 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
569. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201609 on cfms_rct_challan_hdr_month_201609 a_320 (cost=0.14..0.16 rows=1 width=54) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
570. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201610 on cfms_rct_challan_hdr_month_201610 a_321 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
571. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201611 on cfms_rct_challan_hdr_month_201611 a_322 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
572. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201612 on cfms_rct_challan_hdr_month_201612 a_323 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
573. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201701 on cfms_rct_challan_hdr_month_201701 a_324 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
574. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201702 on cfms_rct_challan_hdr_month_201702 a_325 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
575. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201703 on cfms_rct_challan_hdr_month_201703 a_326 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
576. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201704 on cfms_rct_challan_hdr_month_201704 a_327 (cost=0.14..0.16 rows=1 width=54) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
577. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201705 on cfms_rct_challan_hdr_month_201705 a_328 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
578. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201706 on cfms_rct_challan_hdr_month_201706 a_329 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
579. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201707 on cfms_rct_challan_hdr_month_201707 a_330 (cost=0.14..0.16 rows=1 width=46) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
580. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201708 on cfms_rct_challan_hdr_month_201708 a_331 (cost=0.14..0.16 rows=1 width=54) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
581. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201709 on cfms_rct_challan_hdr_month_201709 a_332 (cost=0.14..0.16 rows=1 width=55) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
582. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201710 on cfms_rct_challan_hdr_month_201710 a_333 (cost=0.14..0.16 rows=1 width=54) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
583. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201711 on cfms_rct_challan_hdr_month_201711 a_334 (cost=0.14..0.17 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
584. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201712 on cfms_rct_challan_hdr_month_201712 a_335 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
585. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201801 on cfms_rct_challan_hdr_month_201801 a_336 (cost=0.28..0.30 rows=1 width=44) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
586. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201802 on cfms_rct_challan_hdr_month_201802 a_337 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
587. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201803 on cfms_rct_challan_hdr_month_201803 a_338 (cost=0.14..0.17 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
588. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201804 on cfms_rct_challan_hdr_month_201804 a_339 (cost=0.14..0.19 rows=1 width=44) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
589. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201805 on cfms_rct_challan_hdr_month_201805 a_340 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
590. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201806 on cfms_rct_challan_hdr_month_201806 a_341 (cost=0.14..0.16 rows=1 width=54) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
591. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201807 on cfms_rct_challan_hdr_month_201807 a_342 (cost=0.14..0.17 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
592. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201808 on cfms_rct_challan_hdr_month_201808 a_343 (cost=0.14..0.17 rows=1 width=46) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
593. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201809 on cfms_rct_challan_hdr_month_201809 a_344 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
594. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201810 on cfms_rct_challan_hdr_month_201810 a_345 (cost=0.14..0.17 rows=1 width=44) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
595. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201811 on cfms_rct_challan_hdr_month_201811 a_346 (cost=0.14..0.17 rows=1 width=45) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
596. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201812 on cfms_rct_challan_hdr_month_201812 a_347 (cost=0.14..0.17 rows=1 width=45) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
597. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201901 on cfms_rct_challan_hdr_month_201901 a_348 (cost=0.42..0.56 rows=1 width=45) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
598. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201902 on cfms_rct_challan_hdr_month_201902 a_349 (cost=0.41..0.49 rows=1 width=45) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
599. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201903 on cfms_rct_challan_hdr_month_201903 a_350 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
600. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201904 on cfms_rct_challan_hdr_month_201904 a_351 (cost=0.42..0.52 rows=1 width=45) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
601. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201905 on cfms_rct_challan_hdr_month_201905 a_352 (cost=0.43..0.60 rows=1 width=45) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
602. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201906 on cfms_rct_challan_hdr_month_201906 a_353 (cost=0.43..0.61 rows=1 width=45) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
603. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201907 on cfms_rct_challan_hdr_month_201907 a_354 (cost=0.43..0.62 rows=1 width=45) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
604. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201908 on cfms_rct_challan_hdr_month_201908 a_355 (cost=0.43..0.62 rows=1 width=46) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
605. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201909 on cfms_rct_challan_hdr_month_201909 a_356 (cost=0.43..0.68 rows=1 width=45) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
606. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201910 on cfms_rct_challan_hdr_month_201910 a_357 (cost=0.43..0.69 rows=1 width=46) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
607. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201911 on cfms_rct_challan_hdr_month_201911 a_358 (cost=0.43..0.63 rows=1 width=45) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
608. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_201912 on cfms_rct_challan_hdr_month_201912 a_359 (cost=0.43..0.60 rows=1 width=46) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
609. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202001 on cfms_rct_challan_hdr_month_202001 a_360 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
610. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202002 on cfms_rct_challan_hdr_month_202002 a_361 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
611. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202003 on cfms_rct_challan_hdr_month_202003 a_362 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
612. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202004 on cfms_rct_challan_hdr_month_202004 a_363 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
613. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202005 on cfms_rct_challan_hdr_month_202005 a_364 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
614. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202006 on cfms_rct_challan_hdr_month_202006 a_365 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
615. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202007 on cfms_rct_challan_hdr_month_202007 a_366 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
616. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202008 on cfms_rct_challan_hdr_month_202008 a_367 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
617. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202009 on cfms_rct_challan_hdr_month_202009 a_368 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
618. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202010 on cfms_rct_challan_hdr_month_202010 a_369 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
619. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202011 on cfms_rct_challan_hdr_month_202011 a_370 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
620. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202012 on cfms_rct_challan_hdr_month_202012 a_371 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
621. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202101 on cfms_rct_challan_hdr_month_202101 a_372 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
622. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202102 on cfms_rct_challan_hdr_month_202102 a_373 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
623. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202103 on cfms_rct_challan_hdr_month_202103 a_374 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
624. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202104 on cfms_rct_challan_hdr_month_202104 a_375 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
625. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202105 on cfms_rct_challan_hdr_month_202105 a_376 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
626. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202106 on cfms_rct_challan_hdr_month_202106 a_377 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
627. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202107 on cfms_rct_challan_hdr_month_202107 a_378 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
628. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202108 on cfms_rct_challan_hdr_month_202108 a_379 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
629. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202109 on cfms_rct_challan_hdr_month_202109 a_380 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
630. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202110 on cfms_rct_challan_hdr_month_202110 a_381 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
631. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202111 on cfms_rct_challan_hdr_month_202111 a_382 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
632. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202112 on cfms_rct_challan_hdr_month_202112 a_383 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
633. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202201 on cfms_rct_challan_hdr_month_202201 a_384 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
634. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202202 on cfms_rct_challan_hdr_month_202202 a_385 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
635. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202203 on cfms_rct_challan_hdr_month_202203 a_386 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
636. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202204 on cfms_rct_challan_hdr_month_202204 a_387 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
637. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202205 on cfms_rct_challan_hdr_month_202205 a_388 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
638. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202206 on cfms_rct_challan_hdr_month_202206 a_389 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
639. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202207 on cfms_rct_challan_hdr_month_202207 a_390 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
640. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202208 on cfms_rct_challan_hdr_month_202208 a_391 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
641. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202209 on cfms_rct_challan_hdr_month_202209 a_392 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
642. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202210 on cfms_rct_challan_hdr_month_202210 a_393 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
643. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202211 on cfms_rct_challan_hdr_month_202211 a_394 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
644. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202212 on cfms_rct_challan_hdr_month_202212 a_395 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
645. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202301 on cfms_rct_challan_hdr_month_202301 a_396 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
646. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202302 on cfms_rct_challan_hdr_month_202302 a_397 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
647. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202303 on cfms_rct_challan_hdr_month_202303 a_398 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
648. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202304 on cfms_rct_challan_hdr_month_202304 a_399 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
649. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202305 on cfms_rct_challan_hdr_month_202305 a_400 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
650. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202306 on cfms_rct_challan_hdr_month_202306 a_401 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
651. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202307 on cfms_rct_challan_hdr_month_202307 a_402 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
652. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202308 on cfms_rct_challan_hdr_month_202308 a_403 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
653. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202309 on cfms_rct_challan_hdr_month_202309 a_404 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
654. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202310 on cfms_rct_challan_hdr_month_202310 a_405 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
655. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202311 on cfms_rct_challan_hdr_month_202311 a_406 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
656. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202312 on cfms_rct_challan_hdr_month_202312 a_407 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
657. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202401 on cfms_rct_challan_hdr_month_202401 a_408 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
658. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202402 on cfms_rct_challan_hdr_month_202402 a_409 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
659. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202403 on cfms_rct_challan_hdr_month_202403 a_410 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
660. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202404 on cfms_rct_challan_hdr_month_202404 a_411 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
661. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202405 on cfms_rct_challan_hdr_month_202405 a_412 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
662. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202406 on cfms_rct_challan_hdr_month_202406 a_413 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
663. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202407 on cfms_rct_challan_hdr_month_202407 a_414 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
664. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202408 on cfms_rct_challan_hdr_month_202408 a_415 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
665. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202409 on cfms_rct_challan_hdr_month_202409 a_416 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
666. 0.000 0.000 ↓ 0.0 0

Index Scan using cfms_rct_challan_hdr_ind5_202410 on cfms_rct_challan_hdr_month_202410 a_417 (cost=0.14..0.16 rows=1 width=100) (never executed)

  • Index Cond: (txn_id = b_1.txn_id)
  • Filter: (((challan_type)::text <> 'BT'::text) AND ((processing_flag)::text <> ALL ('{X,A,R}'::text[])))
667. 0.000 0.000 ↓ 0.0 0