explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l6VV : Dockey_b

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

Nested Loop (cost=50,910.30..3,218,763.29 rows=1,075 width=2,691) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on doc d (cost=50,909.74..1,956,089.61 rows=12,271 width=165) (actual rows= loops=)

  • Recheck Cond: ((is_active = 'Y'::bpchar) AND (substr((src_rcrd_id)::text, 3, 2) = ANY ('{OA,OB,OC,OD,OE,OF,OK,OL,ON}'::text[])))
  • Filter: (CASE WHEN ((mot_cd)::text = 'OCEAN'::text) THEN 'O'::text WHEN ((mot_cd)::text = 'AIR'::text) THEN 'A'::text WHEN ((mot_cd)::text = 'GROUND'::text) THEN 'G'::text ELSE 'Unknown'::text END = 'O'::text)
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on doc_idx_dockey_b (cost=0.00..50,906.67 rows=2,454,275 width=0) (actual rows= loops=)

  • Index Cond: ((is_active = 'Y'::bpchar) AND (substr((src_rcrd_id)::text, 3, 2) = ANY ('{OA,OB,OC,OD,OE,OF,OK,OL,ON}'::text[])))
4. 0.000 0.000 ↓ 0.0

Index Scan using doc_dockey on doc_event de (cost=0.56..8.35 rows=1 width=77) (actual rows= loops=)

  • Index Cond: (doc_key = (d.doc_key)::numeric)
  • Filter: ((etl_upd_dt >= to_timestamp('2019-06-30 00:00:00'::text, 'YYYY-MM-DD HH24:MI:SS'::text)) AND (etl_upd_dt <= to_timestamp('2019-07-07 00:00:00'::text, 'YYYY-MM-DD HH24:MI:SS'::text)))
5.          

SubPlan (forNested Loop)

6. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.81 rows=1 width=21) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.81 rows=1 width=21) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
9. 0.000 0.000 ↓ 0.0

Index Scan using doc_prty_idx11 on doc_prty dp1 (cost=0.56..8.58 rows=1 width=29) (actual rows= loops=)

  • Index Cond: (doc_key = (d1.doc_key)::numeric)
10. 0.000 0.000 ↓ 0.0

Limit (cost=0.56..10.23 rows=1 width=32) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_1 (cost=0.56..10.23 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
12. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.81 rows=1 width=15) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.81 rows=1 width=15) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_2 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
15. 0.000 0.000 ↓ 0.0

Index Scan using doc_event_idx_doc_key_and_etl_upd_dt_dt on doc_event de1 (cost=0.56..8.58 rows=1 width=23) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_2.doc_key)::numeric)
16. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..15.89 rows=1 width=5) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.21 rows=2 width=5) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_3 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
20. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_3.doc_key)::numeric)
21. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr (cost=0.43..5.68 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (route_key = drl.route_key)
22. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..15.89 rows=1 width=23) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.21 rows=2 width=23) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_4 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
26. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl_1 (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_4.doc_key)::numeric)
27. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr_1 (cost=0.43..5.68 rows=1 width=31) (actual rows= loops=)

  • Index Cond: (route_key = drl_1.route_key)
28. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.81 rows=1 width=22) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.81 rows=1 width=22) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_5 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
31. 0.000 0.000 ↓ 0.0

Index Scan using doc_prty_idx11 on doc_prty dp1_1 (cost=0.56..8.58 rows=1 width=30) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_5.doc_key)::numeric)
32. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.81 rows=1 width=21) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.81 rows=1 width=21) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_6 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
35. 0.000 0.000 ↓ 0.0

Index Scan using doc_prty_idx11 on doc_prty dp1_2 (cost=0.56..8.58 rows=1 width=29) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_6.doc_key)::numeric)
36. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.81 rows=1 width=13) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.81 rows=1 width=13) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_7 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
39. 0.000 0.000 ↓ 0.0

Index Scan using doc_event_idx_doc_key_and_etl_upd_dt_dt on doc_event de1_1 (cost=0.56..8.58 rows=1 width=21) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_7.doc_key)::numeric)
40. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_8 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
44. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl_2 (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_8.doc_key)::numeric)
45. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr1 (cost=0.43..5.68 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((route_key = drl_2.route_key) AND (primary_record = 'Y'::bpchar))
46. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_9 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
50. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl_3 (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_9.doc_key)::numeric)
51. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr1_1 (cost=0.43..5.68 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((route_key = drl_3.route_key) AND (primary_record = 'N'::bpchar))
52. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_10 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
56. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl_4 (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_10.doc_key)::numeric)
57. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr1_2 (cost=0.43..5.68 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((route_key = drl_4.route_key) AND (primary_record = 'N'::bpchar))
58. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_11 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
62. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl_5 (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_11.doc_key)::numeric)
63. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr1_3 (cost=0.43..5.68 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((route_key = drl_5.route_key) AND (primary_record = 'Y'::bpchar))
64. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.81 rows=1 width=8) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.81 rows=1 width=8) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_12 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
67. 0.000 0.000 ↓ 0.0

Index Scan using doc_event_idx_doc_key_and_etl_upd_dt_dt on doc_event de1_2 (cost=0.56..8.58 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_12.doc_key)::numeric)
68. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.81 rows=1 width=8) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.81 rows=1 width=8) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_13 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
71. 0.000 0.000 ↓ 0.0

Index Scan using doc_event_idx_doc_key_and_etl_upd_dt_dt on doc_event de1_3 (cost=0.56..8.58 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_13.doc_key)::numeric)
72. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.81 rows=1 width=8) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.81 rows=1 width=8) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_14 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
75. 0.000 0.000 ↓ 0.0

Index Scan using doc_event_idx_doc_key_and_etl_upd_dt_dt on doc_event de1_4 (cost=0.56..8.58 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_14.doc_key)::numeric)
76. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.81 rows=1 width=8) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.81 rows=1 width=8) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_15 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
79. 0.000 0.000 ↓ 0.0

Index Scan using doc_event_idx_doc_key_and_etl_upd_dt_dt on doc_event de1_5 (cost=0.56..8.58 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_15.doc_key)::numeric)
80. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.81 rows=1 width=8) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.81 rows=1 width=8) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_16 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
83. 0.000 0.000 ↓ 0.0

Index Scan using doc_event_idx_doc_key_and_etl_upd_dt_dt on doc_event de1_6 (cost=0.56..8.58 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_16.doc_key)::numeric)
84. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.81 rows=1 width=8) (actual rows= loops=)

85. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.81 rows=1 width=8) (actual rows= loops=)

86. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_17 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
87. 0.000 0.000 ↓ 0.0

Index Scan using doc_event_idx_doc_key_and_etl_upd_dt_dt on doc_event de1_7 (cost=0.56..8.58 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_17.doc_key)::numeric)
88. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_18 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
92. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl_6 (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_18.doc_key)::numeric)
93. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr1_4 (cost=0.43..5.68 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((route_key = drl_6.route_key) AND (primary_record = 'Y'::bpchar))
94. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

96. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_19 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
98. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl_7 (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_19.doc_key)::numeric)
99. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr1_5 (cost=0.43..5.68 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((route_key = drl_7.route_key) AND (primary_record = 'N'::bpchar))
100. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

102. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

103. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_20 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
104. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl_8 (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_20.doc_key)::numeric)
105. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr1_6 (cost=0.43..5.68 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((route_key = drl_8.route_key) AND (primary_record = 'Y'::bpchar))
106. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

107. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

108. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_21 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
110. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl_9 (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_21.doc_key)::numeric)
111. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr1_7 (cost=0.43..5.68 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((route_key = drl_9.route_key) AND (primary_record = 'Y'::bpchar))
112. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.82 rows=1 width=8) (actual rows= loops=)

113. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.82 rows=1 width=8) (actual rows= loops=)

114. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_22 (cost=0.56..10.23 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (substr((src_rcrd_id)::text, 3, 2) = ANY ('{OD,OE,OF}'::text[]))
115. 0.000 0.000 ↓ 0.0

Index Scan using doc_event_idx_doc_key_and_etl_upd_dt_dt on doc_event de1_8 (cost=0.56..8.58 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_22.doc_key)::numeric)
116. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.82 rows=1 width=8) (actual rows= loops=)

117. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.82 rows=1 width=8) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_23 (cost=0.56..10.23 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (substr((src_rcrd_id)::text, 3, 2) = ANY ('{OD,OE,OF}'::text[]))
119. 0.000 0.000 ↓ 0.0

Index Scan using doc_event_idx_doc_key_and_etl_upd_dt_dt on doc_event de1_9 (cost=0.56..8.58 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_23.doc_key)::numeric)
120. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.82 rows=1 width=2) (actual rows= loops=)

121. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.82 rows=1 width=2) (actual rows= loops=)

122. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_24 (cost=0.56..10.23 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (substr((src_rcrd_id)::text, 3, 2) = ANY ('{OD,OE,OF}'::text[]))
123. 0.000 0.000 ↓ 0.0

Index Scan using doc_event_idx_doc_key_and_etl_upd_dt_dt on doc_event de1_10 (cost=0.56..8.58 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_24.doc_key)::numeric)
124. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.82 rows=1 width=8) (actual rows= loops=)

125. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.82 rows=1 width=8) (actual rows= loops=)

126. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_25 (cost=0.56..10.23 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (substr((src_rcrd_id)::text, 3, 2) = ANY ('{OD,OE,OF}'::text[]))
127. 0.000 0.000 ↓ 0.0

Index Scan using doc_event_idx_doc_key_and_etl_upd_dt_dt on doc_event de1_11 (cost=0.56..8.58 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_25.doc_key)::numeric)
128. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.82 rows=1 width=8) (actual rows= loops=)

129. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.82 rows=1 width=8) (actual rows= loops=)

130. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_26 (cost=0.56..10.23 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (substr((src_rcrd_id)::text, 3, 2) = ANY ('{OD,OE,OF}'::text[]))
131. 0.000 0.000 ↓ 0.0

Index Scan using doc_event_idx_doc_key_and_etl_upd_dt_dt on doc_event de1_12 (cost=0.56..8.58 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_26.doc_key)::numeric)
132. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.81 rows=1 width=6) (actual rows= loops=)

133. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.81 rows=1 width=6) (actual rows= loops=)

134. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_27 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
135. 0.000 0.000 ↓ 0.0

Index Scan using doc_prty_idx11 on doc_prty dp1_3 (cost=0.56..8.58 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_27.doc_key)::numeric)
136. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

137. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

138. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

139. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_28 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
140. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl_10 (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_28.doc_key)::numeric)
141. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr1_8 (cost=0.43..5.68 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((route_key = drl_10.route_key) AND (primary_record = 'Y'::bpchar))
142. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

143. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

144. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

145. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_29 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
146. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl_11 (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_29.doc_key)::numeric)
147. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr1_9 (cost=0.43..5.68 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((route_key = drl_11.route_key) AND (primary_record = 'N'::bpchar))
148. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..30.22 rows=1 width=4) (actual rows= loops=)

149. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.22 rows=1 width=4) (actual rows= loops=)

150. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

151. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_30 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
152. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl_12 (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_30.doc_key)::numeric)
153. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr1_10 (cost=0.43..5.68 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((route_key = drl_12.route_key) AND (primary_record = 'Y'::bpchar))
154. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..30.22 rows=1 width=4) (actual rows= loops=)

155. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.22 rows=1 width=4) (actual rows= loops=)

156. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

157. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_31 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
158. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl_13 (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_31.doc_key)::numeric)
159. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr1_11 (cost=0.43..5.68 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((route_key = drl_13.route_key) AND (primary_record = 'Y'::bpchar))
160. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..30.22 rows=1 width=3) (actual rows= loops=)

161. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.22 rows=1 width=3) (actual rows= loops=)

162. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

163. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_32 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
164. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl_14 (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_32.doc_key)::numeric)
165. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr1_12 (cost=0.43..5.68 rows=1 width=11) (actual rows= loops=)

  • Index Cond: ((route_key = drl_14.route_key) AND (primary_record = 'Y'::bpchar))
166. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

167. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

168. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

169. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_33 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
170. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl_15 (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_33.doc_key)::numeric)
171. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr1_13 (cost=0.43..5.68 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((route_key = drl_15.route_key) AND (primary_record = 'Y'::bpchar))
172. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

173. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

174. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

175. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_34 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
176. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl_16 (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_34.doc_key)::numeric)
177. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr1_14 (cost=0.43..5.68 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((route_key = drl_16.route_key) AND (primary_record = 'Y'::bpchar))
178. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

179. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

180. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

181. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_35 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
182. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl_17 (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_35.doc_key)::numeric)
183. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr1_15 (cost=0.43..5.68 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((route_key = drl_17.route_key) AND (primary_record = 'N'::bpchar))
184. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

185. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

186. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

187. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_36 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
188. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl_18 (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_36.doc_key)::numeric)
189. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr1_16 (cost=0.43..5.68 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((route_key = drl_18.route_key) AND (primary_record = 'Y'::bpchar))
190. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..30.22 rows=1 width=3) (actual rows= loops=)

191. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.22 rows=1 width=3) (actual rows= loops=)

192. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

193. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_37 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
194. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl_19 (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_37.doc_key)::numeric)
195. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr1_17 (cost=0.43..5.68 rows=1 width=11) (actual rows= loops=)

  • Index Cond: ((route_key = drl_19.route_key) AND (primary_record = 'Y'::bpchar))
196. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

197. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

198. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

199. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_38 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
200. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl_20 (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_38.doc_key)::numeric)
201. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr1_18 (cost=0.43..5.68 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((route_key = drl_20.route_key) AND (primary_record = 'Y'::bpchar))
202. 0.000 0.000 ↓ 0.0

Limit (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

203. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..30.22 rows=1 width=8) (actual rows= loops=)

204. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..18.84 rows=2 width=8) (actual rows= loops=)

205. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_39 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
206. 0.000 0.000 ↓ 0.0

Index Only Scan using doc_route_link_idx4 on doc_route_link drl_21 (cost=0.56..8.60 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_39.doc_key)::numeric)
207. 0.000 0.000 ↓ 0.0

Index Scan using doc_route_idx22 on doc_route dr1_19 (cost=0.43..5.68 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((route_key = drl_21.route_key) AND (primary_record = 'N'::bpchar))
208. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.81 rows=1 width=8) (actual rows= loops=)

209. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.81 rows=1 width=8) (actual rows= loops=)

210. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_40 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
211. 0.000 0.000 ↓ 0.0

Index Scan using doc_event_idx_doc_key_and_etl_upd_dt_dt on doc_event de1_13 (cost=0.56..8.58 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_40.doc_key)::numeric)
212. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.81 rows=1 width=8) (actual rows= loops=)

213. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.81 rows=1 width=8) (actual rows= loops=)

214. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_41 (cost=0.56..10.22 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (primary_record = 'Y'::bpchar)
215. 0.000 0.000 ↓ 0.0

Index Scan using doc_event_idx_doc_key_and_etl_upd_dt_dt on doc_event de1_14 (cost=0.56..8.58 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_41.doc_key)::numeric)
216. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.82 rows=1 width=8) (actual rows= loops=)

217. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.82 rows=1 width=8) (actual rows= loops=)

218. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_42 (cost=0.56..10.23 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (substr((src_rcrd_id)::text, 3, 2) = ANY ('{OD,OE,OF}'::text[]))
219. 0.000 0.000 ↓ 0.0

Index Scan using doc_event_idx_doc_key_and_etl_upd_dt_dt on doc_event de1_15 (cost=0.56..8.58 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_42.doc_key)::numeric)
220. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.82 rows=1 width=8) (actual rows= loops=)

221. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.82 rows=1 width=8) (actual rows= loops=)

222. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_43 (cost=0.56..10.23 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (substr((src_rcrd_id)::text, 3, 2) = ANY ('{OD,OE,OF}'::text[]))
223. 0.000 0.000 ↓ 0.0

Index Scan using doc_event_idx_doc_key_and_etl_upd_dt_dt on doc_event de1_16 (cost=0.56..8.58 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_43.doc_key)::numeric)
224. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.82 rows=1 width=8) (actual rows= loops=)

225. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.82 rows=1 width=8) (actual rows= loops=)

226. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_44 (cost=0.56..10.23 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (substr((src_rcrd_id)::text, 3, 2) = ANY ('{OD,OE,OF}'::text[]))
227. 0.000 0.000 ↓ 0.0

Index Scan using doc_event_idx_doc_key_and_etl_upd_dt_dt on doc_event de1_17 (cost=0.56..8.58 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_44.doc_key)::numeric)
228. 0.000 0.000 ↓ 0.0

Limit (cost=1.13..18.82 rows=1 width=8) (actual rows= loops=)

229. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..18.82 rows=1 width=8) (actual rows= loops=)

230. 0.000 0.000 ↓ 0.0

Index Scan using doc_idx25 on doc d1_45 (cost=0.56..10.23 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((doc_sid)::text = (d.doc_sid)::text)
  • Filter: (substr((src_rcrd_id)::text, 3, 2) = ANY ('{OD,OE,OF}'::text[]))
231. 0.000 0.000 ↓ 0.0

Index Scan using doc_event_idx_doc_key_and_etl_upd_dt_dt on doc_event de1_18 (cost=0.56..8.58 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (doc_key = (d1_45.doc_key)::numeric)