explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3G2Y

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

Append (cost=1,332,170.85..1,336,271.41 rows=136,769 width=76) (actual rows= loops=)

2.          

CTE non_nof5_sources

3. 0.000 0.000 ↓ 0.0

Append (cost=20.75..24,413.21 rows=403 width=65) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=20.75..86.82 rows=178 width=72) (actual rows= loops=)

  • Hash Cond: (cm.organization_id = c.id)
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=10.52..75.23 rows=178 width=22) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.56..18.21 rows=1 width=18) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.29..9.91 rows=1 width=4) (actual rows= loops=)

  • Join Filter: (msps.license_type_id = lt.id)
8. 0.000 0.000 ↓ 0.0

Seq Scan on license_type lt (cost=0.00..1.04 rows=1 width=4) (actual rows= loops=)

  • Filter: ((id IS NOT NULL) AND (name = 'MSP'::text))
9. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on account_license msps (cost=4.29..8.85 rows=2 width=8) (actual rows= loops=)

  • Recheck Cond: (account_id = 453)
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on account_license_account_id_license_type_id_key (cost=0.00..4.29 rows=2 width=0) (actual rows= loops=)

  • Index Cond: (account_id = 453)
11. 0.000 0.000 ↓ 0.0

Index Scan using pk_practitioner on account a (cost=0.27..8.29 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (id = 453)
12. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on organization_member cm (cost=5.96..55.23 rows=178 width=12) (actual rows= loops=)

  • Recheck Cond: (account_id = 453)
  • Filter: ((deleted IS NOT TRUE) AND (member_status_id = 'A'::bpchar))
13. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_clinic_member_account_id (cost=0.00..5.92 rows=218 width=0) (actual rows= loops=)

  • Index Cond: (account_id = 453)
14. 0.000 0.000 ↓ 0.0

Hash (cost=7.88..7.88 rows=188 width=27) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on organization c (cost=0.00..7.88 rows=188 width=27) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Hash Join (cost=17.25..68.13 rows=119 width=63) (actual rows= loops=)

  • Hash Cond: (c_1.organization_type_id = ot.id)
17. 0.000 0.000 ↓ 0.0

Hash Join (cost=16.19..65.94 rows=178 width=31) (actual rows= loops=)

  • Hash Cond: (cm_1.organization_id = c_1.id)
18. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on organization_member cm_1 (cost=5.96..55.23 rows=178 width=4) (actual rows= loops=)

  • Recheck Cond: (account_id = 453)
  • Filter: ((deleted IS NOT TRUE) AND (member_status_id = 'A'::bpchar))
19. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_clinic_member_account_id (cost=0.00..5.92 rows=218 width=0) (actual rows= loops=)

  • Index Cond: (account_id = 453)
20. 0.000 0.000 ↓ 0.0

Hash (cost=7.88..7.88 rows=188 width=31) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Seq Scan on organization c_1 (cost=0.00..7.88 rows=188 width=31) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Hash (cost=1.04..1.04 rows=2 width=4) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Seq Scan on organization_type ot (cost=0.00..1.04 rows=2 width=4) (actual rows= loops=)

  • Filter: (name <> 'partner'::text)
24. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.07..12,043.80 rows=1 width=63) (actual rows= loops=)

  • Join Filter: (c_2.organization_type_id = ot_1.id)
25.          

Initplan (for Nested Loop)

26. 0.000 0.000 ↓ 0.0

Seq Scan on share_status ss (cost=0.00..1.07 rows=1 width=4) (actual rows= loops=)

  • Filter: (lower(name) = 'active'::text)
27. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..12,041.66 rows=1 width=31) (actual rows= loops=)

  • Join Filter: (c_2.id = cs.initiator_id)
28. 0.000 0.000 ↓ 0.0

Seq Scan on share_data cs (cost=0.00..12,031.43 rows=1 width=4) (actual rows= loops=)

  • Filter: ((share_status_id = $3) AND (lower(initiator_type) = 'organization'::text) AND (((recipient_id = 949) AND (lower(recipient_type) = 'member'::text)) OR (SubPlan 1)))
29.          

SubPlan (for Seq Scan)

30. 0.000 0.000 ↓ 0.0

Result (cost=10.64..14.66 rows=1 width=4) (actual rows= loops=)

  • One-Time Filter: (lower(cs.recipient_type) = 'organization'::text)
31. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on organization_member om_1 (cost=10.64..14.66 rows=1 width=4) (actual rows= loops=)

  • Recheck Cond: ((organization_id = cs.recipient_id) AND (453 = account_id))
  • Filter: ((deleted IS NOT TRUE) AND (member_status_id = 'A'::bpchar))
32. 0.000 0.000 ↓ 0.0

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

33. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_clinic_member_clinic_id (cost=0.00..4.47 rows=25 width=0) (actual rows= loops=)

  • Index Cond: (organization_id = cs.recipient_id)
34. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_clinic_member_account_id (cost=0.00..5.92 rows=218 width=0) (actual rows= loops=)

  • Index Cond: (453 = account_id)
35. 0.000 0.000 ↓ 0.0

Seq Scan on organization c_2 (cost=0.00..7.88 rows=188 width=31) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Seq Scan on organization_type ot_1 (cost=0.00..1.04 rows=2 width=4) (actual rows= loops=)

  • Filter: (name <> 'partner'::text)
37. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.07..12,043.80 rows=1 width=63) (actual rows= loops=)

  • Join Filter: (c_3.organization_type_id = ot_2.id)
38.          

Initplan (for Nested Loop)

39. 0.000 0.000 ↓ 0.0

Seq Scan on share_status ss_1 (cost=0.00..1.07 rows=1 width=4) (actual rows= loops=)

  • Filter: (lower(name) = 'active'::text)
40. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..12,041.66 rows=1 width=31) (actual rows= loops=)

  • Join Filter: (c_3.id = cs_1.recipient_id)
41. 0.000 0.000 ↓ 0.0

Seq Scan on share_data cs_1 (cost=0.00..12,031.43 rows=1 width=4) (actual rows= loops=)

  • Filter: ((share_status_id = $7) AND (lower(recipient_type) = 'organization'::text) AND (((initiator_id = 949) AND (lower(initiator_type) = 'member'::text)) OR (SubPlan 3)))
42.          

SubPlan (for Seq Scan)

43. 0.000 0.000 ↓ 0.0

Result (cost=10.64..14.66 rows=1 width=4) (actual rows= loops=)

  • One-Time Filter: (lower(cs_1.initiator_type) = 'organization'::text)
44. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on organization_member om_2 (cost=10.64..14.66 rows=1 width=4) (actual rows= loops=)

  • Recheck Cond: ((organization_id = cs_1.initiator_id) AND (453 = account_id))
  • Filter: ((deleted IS NOT TRUE) AND (member_status_id = 'A'::bpchar))
45. 0.000 0.000 ↓ 0.0

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

46. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_clinic_member_clinic_id (cost=0.00..4.47 rows=25 width=0) (actual rows= loops=)

  • Index Cond: (organization_id = cs_1.initiator_id)
47. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_clinic_member_account_id (cost=0.00..5.92 rows=218 width=0) (actual rows= loops=)

  • Index Cond: (453 = account_id)
48. 0.000 0.000 ↓ 0.0

Seq Scan on organization c_3 (cost=0.00..7.88 rows=188 width=31) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

Seq Scan on organization_type ot_2 (cost=0.00..1.04 rows=2 width=4) (actual rows= loops=)

  • Filter: (name <> 'partner'::text)
50. 0.000 0.000 ↓ 0.0

Nested Loop (cost=7.88..59.00 rows=1 width=72) (actual rows= loops=)

  • Join Filter: (pgm.organization_member_group_id = pg.id)
51. 0.000 0.000 ↓ 0.0

Hash Join (cost=7.88..57.71 rows=1 width=4) (actual rows= loops=)

  • Hash Cond: (om_3.id = pgm.organization_member_id)
52. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on organization_member om_3 (cost=5.97..54.70 rows=218 width=4) (actual rows= loops=)

  • Recheck Cond: (account_id = 453)
53. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_clinic_member_account_id (cost=0.00..5.92 rows=218 width=0) (actual rows= loops=)

  • Index Cond: (account_id = 453)
54. 0.000 0.000 ↓ 0.0

Hash (cost=1.66..1.66 rows=20 width=8) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Seq Scan on organization_member_group_member pgm (cost=0.00..1.66 rows=20 width=8) (actual rows= loops=)

  • Filter: ((deleted IS NOT TRUE) AND (member_status_id = 'A'::bpchar))
56. 0.000 0.000 ↓ 0.0

Seq Scan on organization_member_group pg (cost=0.00..1.13 rows=13 width=36) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Hash Join (cost=54.47..105.61 rows=103 width=56) (actual rows= loops=)

  • Hash Cond: (cm_2.organization_id = c_4.id)
58. 0.000 0.000 ↓ 0.0

Hash Join (cost=44.24..95.13 rows=94 width=28) (actual rows= loops=)

  • Hash Cond: (cm_2.organization_id = cgm.organization_id)
59. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on organization_member cm_2 (cost=5.96..55.23 rows=178 width=4) (actual rows= loops=)

  • Recheck Cond: (account_id = 453)
  • Filter: ((deleted IS NOT TRUE) AND (member_status_id = 'A'::bpchar))
60. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_clinic_member_account_id (cost=0.00..5.92 rows=218 width=0) (actual rows= loops=)

  • Index Cond: (account_id = 453)
61. 0.000 0.000 ↓ 0.0

Hash (cost=36.92..36.92 rows=109 width=24) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Hash Join (cost=3.82..36.92 rows=109 width=24) (actual rows= loops=)

  • Hash Cond: (cgm.organization_group_id = cg.id)
63. 0.000 0.000 ↓ 0.0

Seq Scan on organization_group_member cgm (cost=0.00..29.03 rows=1,514 width=8) (actual rows= loops=)

  • Filter: ((deleted IS NOT TRUE) AND (member_status_id = 'A'::bpchar))
64. 0.000 0.000 ↓ 0.0

Hash (cost=3.67..3.67 rows=12 width=20) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Seq Scan on organization_group cg (cost=0.00..3.67 rows=12 width=20) (actual rows= loops=)

  • Filter: (system_group IS NOT TRUE)
66. 0.000 0.000 ↓ 0.0

Hash (cost=7.88..7.88 rows=188 width=4) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Seq Scan on organization c_4 (cost=0.00..7.88 rows=188 width=4) (actual rows= loops=)

68.          

CTE nof5_orgs

69. 0.000 0.000 ↓ 0.0

Unique (cost=64,410.98..64,421.20 rows=584 width=64) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Sort (cost=64,410.98..64,412.44 rows=584 width=64) (actual rows= loops=)

  • Sort Key: gt.name, og.id, og.name, tp_1.id, i_1.id, o_1.id
71. 0.000 0.000 ↓ 0.0

Hash Join (cost=58,353.05..64,384.15 rows=584 width=64) (actual rows= loops=)

  • Hash Cond: ((o_1.id = u.data_source_id) AND (i_1.id = u.indicator_id) AND (tp_1.id = u.report_period_id))
72. 0.000 0.000 ↓ 0.0

Hash Join (cost=38.76..3,619.97 rows=14,336 width=72) (actual rows= loops=)

  • Hash Cond: (id_1.domain_id = d_1.id)
  • Join Filter: ((id_1.domain_id = 3) OR (d_1.parent_domain_id = 3))
73. 0.000 0.000 ↓ 0.0

Hash Join (cost=36.52..3,091.38 rows=198,912 width=76) (actual rows= loops=)

  • Hash Cond: (id_1.indicator_id = i_1.id)
74. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.60..2,529.29 rows=198,912 width=72) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.60..34.34 rows=448 width=64) (actual rows= loops=)

  • Join Filter: (tp_1.start_date <= s_2.data_aggregation_cutoff_date)
76. 0.000 0.000 ↓ 0.0

Seq Scan on time_period tp_1 (cost=0.00..1.64 rows=64 width=12) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Materialize (cost=1.60..12.60 rows=21 width=64) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.60..12.49 rows=21 width=64) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Seq Scan on setting s_2 (cost=0.00..1.01 rows=1 width=4) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.60..11.27 rows=21 width=60) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.46..7.42 rows=21 width=56) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.18..5.26 rows=2 width=52) (actual rows= loops=)

  • Hash Cond: (og.group_type_id = gt.id)
  • Join Filter: ((((og.system_group IS TRUE) AND (gt.name <> 'Division Area'::text)) OR (gt.name = 'User Defined Organization Group'::text)) AND (((gt.name || ':'::text) || (og.id)::text) = ANY ('{Division:128,Division:144,All:1,"Local Health Area (LHA):60"}'::text[])))
83. 0.000 0.000 ↓ 0.0

Seq Scan on organization_group og (cost=0.00..3.67 rows=156 width=25) (actual rows= loops=)

  • Filter: (private IS FALSE)
84. 0.000 0.000 ↓ 0.0

Hash (cost=1.10..1.10 rows=6 width=36) (actual rows= loops=)

85. 0.000 0.000 ↓ 0.0

Seq Scan on group_type gt (cost=0.00..1.10 rows=6 width=36) (actual rows= loops=)

  • Filter: ((name <> 'Division Area'::text) OR (name = 'User Defined Organization Group'::text))
86. 0.000 0.000 ↓ 0.0

Index Scan using idx_clinic_group_member_clinic_group_id on organization_group_member ogm (cost=0.28..0.95 rows=13 width=8) (actual rows= loops=)

  • Index Cond: (organization_group_id = og.id)
  • Filter: ((deleted IS NOT TRUE) AND (member_status_id = 'A'::bpchar))
87. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_organization on organization o_1 (cost=0.14..0.18 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = ogm.organization_id)
88. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..9.66 rows=444 width=8) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

Seq Scan on indicator_domain id_1 (cost=0.00..7.44 rows=444 width=8) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Hash (cost=29.41..29.41 rows=441 width=4) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Seq Scan on indicator i_1 (cost=0.00..29.41 rows=441 width=4) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Hash (cost=1.55..1.55 rows=55 width=8) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Seq Scan on domain d_1 (cost=0.00..1.55 rows=55 width=8) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Hash (cost=49,143.22..49,143.22 rows=409,718 width=12) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on aggregate_data u (cost=13,183.74..49,143.22 rows=409,718 width=12) (actual rows= loops=)

  • Recheck Cond: (data_source_type = 'Organization'::text)
96. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mat_aggregate_data_data_source_type_data_source_id_report_p_idx (cost=0.00..13,081.32 rows=409,718 width=0) (actual rows= loops=)

  • Index Cond: (data_source_type = 'Organization'::text)
97.          

CTE nof5_sources

98. 0.000 0.000 ↓ 0.0

Append (cost=37,589.77..37,630.97 rows=259 width=76) (actual rows= loops=)

99. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=37,589.77..37,604.14 rows=192 width=76) (actual rows= loops=)

  • Group Key: cmg.id, i_2.id, tp_2.id
  • Filter: (count(DISTINCT cmgm.id) >= 5)
100. 0.000 0.000 ↓ 0.0

Sort (cost=37,589.77..37,591.20 rows=575 width=48) (actual rows= loops=)

  • Sort Key: cmg.id, i_2.id, tp_2.id
101. 0.000 0.000 ↓ 0.0

Hash Join (cost=6.03..37,563.41 rows=575 width=48) (actual rows= loops=)

  • Hash Cond: (ad.report_period_id = tp_2.id)
102. 0.000 0.000 ↓ 0.0

Merge Join (cost=2.32..37,547.57 rows=1,725 width=48) (actual rows= loops=)

  • Merge Cond: (id_2.indicator_id = i_2.id)
103. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.05..37,403.62 rows=1,820 width=52) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.41..118.11 rows=32 width=4) (actual rows= loops=)

105. 0.000 0.000 ↓ 0.0

Index Scan using idx_indicator_domain_indicator_id on indicator_domain id_2 (cost=0.27..29.58 rows=444 width=8) (actual rows= loops=)

106. 0.000 0.000 ↓ 0.0

Index Scan using pk_domain on domain d_2 (cost=0.14..0.19 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = id_2.domain_id)
  • Filter: ((id_2.domain_id = 3) OR (parent_domain_id = 3))
107. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.63..1,164.54 rows=63 width=48) (actual rows= loops=)

108. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.20..2.94 rows=9 width=44) (actual rows= loops=)

  • Hash Cond: (cmgm.organization_member_group_id = cmg.id)
109. 0.000 0.000 ↓ 0.0

Seq Scan on organization_member_group_member cmgm (cost=0.00..1.66 rows=20 width=12) (actual rows= loops=)

  • Filter: ((deleted IS NOT TRUE) AND (member_status_id = 'A'::bpchar))
110. 0.000 0.000 ↓ 0.0

Hash (cost=1.13..1.13 rows=6 width=36) (actual rows= loops=)

111. 0.000 0.000 ↓ 0.0

Seq Scan on organization_member_group cmg (cost=0.00..1.13 rows=6 width=36) (actual rows= loops=)

  • Filter: (NOT private)
112. 0.000 0.000 ↓ 0.0

Index Only Scan using mat_aggregate_data_data_source_type_data_source_id_report_p_idx on aggregate_data ad (cost=0.43..129.00 rows=7 width=12) (actual rows= loops=)

  • Index Cond: ((data_source_type = 'Member'::text) AND (data_source_id = cmgm.organization_member_id) AND (indicator_id = id_2.indicator_id))
113. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_indicator on indicator i_2 (cost=0.27..120.09 rows=441 width=4) (actual rows= loops=)

114. 0.000 0.000 ↓ 0.0

Hash (cost=3.45..3.45 rows=21 width=4) (actual rows= loops=)

115. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..3.45 rows=21 width=4) (actual rows= loops=)

  • Join Filter: (tp_2.start_date <= s_3.data_aggregation_cutoff_date)
116. 0.000 0.000 ↓ 0.0

Seq Scan on setting s_3 (cost=0.00..1.01 rows=1 width=4) (actual rows= loops=)

117. 0.000 0.000 ↓ 0.0

Seq Scan on time_period tp_2 (cost=0.00..1.64 rows=64 width=12) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

HashAggregate (cost=20.44..22.94 rows=67 width=76) (actual rows= loops=)

  • Group Key: n.data_source_type, n.data_source_id, n.org_group, n.report_period_id, n.indicator_id
  • Filter: (count(*) >= 5)
119. 0.000 0.000 ↓ 0.0

CTE Scan on nof5_orgs n (cost=0.00..11.68 rows=584 width=76) (actual rows= loops=)

120.          

CTE shares

121. 0.000 0.000 ↓ 0.0

Append (cost=12.51..396.81 rows=244 width=76) (actual rows= loops=)

122. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12.51..90.64 rows=6 width=76) (actual rows= loops=)

  • Join Filter: (cms.indicator_security_level_id = i_3.indicator_security_level_id)
123. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12.24..84.41 rows=11 width=57) (actual rows= loops=)

  • Join Filter: (ic_1.channel_id = cms.channel_id)
124. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.98..64.13 rows=1 width=53) (actual rows= loops=)

125. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..63.96 rows=1 width=34) (actual rows= loops=)

126. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..63.64 rows=1 width=24) (actual rows= loops=)

127. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..55.33 rows=1 width=16) (actual rows= loops=)

  • Join Filter: (cms.share_status_id = ss_2.id)
128. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..50.33 rows=1 width=16) (actual rows= loops=)

129. 0.000 0.000 ↓ 0.0

Seq Scan on share_data cms (cost=0.00..41.94 rows=1 width=20) (actual rows= loops=)

  • Filter: ((lower(initiator_type) = 'member'::text) AND (lower(recipient_type) = 'member'::text))
130. 0.000 0.000 ↓ 0.0

Index Scan using pk_organization_member on organization_member cm_3 (cost=0.28..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = cms.initiator_id)
  • Filter: ((deleted IS NOT TRUE) AND (account_id = 453) AND (member_status_id = 'A'::bpchar))
131. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..4.74 rows=21 width=8) (actual rows= loops=)

132. 0.000 0.000 ↓ 0.0

Seq Scan on share_status ss_2 (cost=0.00..1.07 rows=1 width=4) (actual rows= loops=)

  • Filter: (lower(name) = 'active'::text)
133. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..3.45 rows=21 width=4) (actual rows= loops=)

  • Join Filter: (tp_3.start_date <= s_4.data_aggregation_cutoff_date)
134. 0.000 0.000 ↓ 0.0

Seq Scan on setting s_4 (cost=0.00..1.01 rows=1 width=4) (actual rows= loops=)

135. 0.000 0.000 ↓ 0.0

Seq Scan on time_period tp_3 (cost=0.00..1.64 rows=64 width=12) (actual rows= loops=)

136. 0.000 0.000 ↓ 0.0

Index Scan using pk_organization_member on organization_member cm_other (cost=0.28..8.30 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (id = cms.recipient_id)
  • Filter: ((deleted IS NOT TRUE) AND (member_status_id = 'A'::bpchar))
137. 0.000 0.000 ↓ 0.0

Index Scan using pk_practitioner on account a_other (cost=0.27..0.32 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (id = cm_other.account_id)
138. 0.000 0.000 ↓ 0.0

Index Scan using pk_organization on organization c_other (cost=0.14..0.17 rows=1 width=27) (actual rows= loops=)

  • Index Cond: (id = cm_other.organization_id)
139. 0.000 0.000 ↓ 0.0

Hash Join (cost=11.26..19.91 rows=30 width=12) (actual rows= loops=)

  • Hash Cond: (ic_1.indicator_id = id_3.indicator_id)
140. 0.000 0.000 ↓ 0.0

Seq Scan on indicator_channel ic_1 (cost=0.00..6.89 rows=389 width=8) (actual rows= loops=)

141. 0.000 0.000 ↓ 0.0

Hash (cost=10.86..10.86 rows=32 width=4) (actual rows= loops=)

142. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.24..10.86 rows=32 width=4) (actual rows= loops=)

  • Hash Cond: (id_3.domain_id = d_3.id)
  • Join Filter: ((id_3.domain_id = 3) OR (d_3.parent_domain_id = 3))
143. 0.000 0.000 ↓ 0.0

Seq Scan on indicator_domain id_3 (cost=0.00..7.44 rows=444 width=8) (actual rows= loops=)

144. 0.000 0.000 ↓ 0.0

Hash (cost=1.55..1.55 rows=55 width=8) (actual rows= loops=)

145. 0.000 0.000 ↓ 0.0

Seq Scan on domain d_3 (cost=0.00..1.55 rows=55 width=8) (actual rows= loops=)

146. 0.000 0.000 ↓ 0.0

Index Scan using pk_indicator on indicator i_3 (cost=0.27..0.55 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = id_3.indicator_id)
147. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12.51..90.64 rows=6 width=76) (actual rows= loops=)

  • Join Filter: (cms_1.indicator_security_level_id = i_4.indicator_security_level_id)
148. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12.24..84.41 rows=11 width=57) (actual rows= loops=)

  • Join Filter: (ic_2.channel_id = cms_1.channel_id)
149. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.98..64.13 rows=1 width=53) (actual rows= loops=)

150. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..63.96 rows=1 width=34) (actual rows= loops=)

151. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..63.64 rows=1 width=24) (actual rows= loops=)

152. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..55.33 rows=1 width=16) (actual rows= loops=)

  • Join Filter: (cms_1.share_status_id = ss_3.id)
153. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..50.33 rows=1 width=16) (actual rows= loops=)

154. 0.000 0.000 ↓ 0.0

Seq Scan on share_data cms_1 (cost=0.00..41.94 rows=1 width=20) (actual rows= loops=)

  • Filter: ((lower(recipient_type) = 'member'::text) AND (lower(initiator_type) = 'member'::text))
155. 0.000 0.000 ↓ 0.0

Index Scan using pk_organization_member on organization_member cm_4 (cost=0.28..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = cms_1.recipient_id)
  • Filter: ((deleted IS NOT TRUE) AND (account_id = 453) AND (member_status_id = 'A'::bpchar))
156. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..4.74 rows=21 width=8) (actual rows= loops=)

157. 0.000 0.000 ↓ 0.0

Seq Scan on share_status ss_3 (cost=0.00..1.07 rows=1 width=4) (actual rows= loops=)

  • Filter: (lower(name) = 'active'::text)
158. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..3.45 rows=21 width=4) (actual rows= loops=)

  • Join Filter: (tp_4.start_date <= s_5.data_aggregation_cutoff_date)
159. 0.000 0.000 ↓ 0.0

Seq Scan on setting s_5 (cost=0.00..1.01 rows=1 width=4) (actual rows= loops=)

160. 0.000 0.000 ↓ 0.0

Seq Scan on time_period tp_4 (cost=0.00..1.64 rows=64 width=12) (actual rows= loops=)

161. 0.000 0.000 ↓ 0.0

Index Scan using pk_organization_member on organization_member cm_other_1 (cost=0.28..8.30 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (id = cms_1.initiator_id)
  • Filter: ((deleted IS NOT TRUE) AND (member_status_id = 'A'::bpchar))
162. 0.000 0.000 ↓ 0.0

Index Scan using pk_practitioner on account a_other_1 (cost=0.27..0.32 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (id = cm_other_1.account_id)
163. 0.000 0.000 ↓ 0.0

Index Scan using pk_organization on organization c_other_1 (cost=0.14..0.17 rows=1 width=27) (actual rows= loops=)

  • Index Cond: (id = cm_other_1.organization_id)
164. 0.000 0.000 ↓ 0.0

Hash Join (cost=11.26..19.91 rows=30 width=12) (actual rows= loops=)

  • Hash Cond: (ic_2.indicator_id = id_4.indicator_id)
165. 0.000 0.000 ↓ 0.0

Seq Scan on indicator_channel ic_2 (cost=0.00..6.89 rows=389 width=8) (actual rows= loops=)

166. 0.000 0.000 ↓ 0.0

Hash (cost=10.86..10.86 rows=32 width=4) (actual rows= loops=)

167. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.24..10.86 rows=32 width=4) (actual rows= loops=)

  • Hash Cond: (id_4.domain_id = d_4.id)
  • Join Filter: ((id_4.domain_id = 3) OR (d_4.parent_domain_id = 3))
168. 0.000 0.000 ↓ 0.0

Seq Scan on indicator_domain id_4 (cost=0.00..7.44 rows=444 width=8) (actual rows= loops=)

169. 0.000 0.000 ↓ 0.0

Hash (cost=1.55..1.55 rows=55 width=8) (actual rows= loops=)

170. 0.000 0.000 ↓ 0.0

Seq Scan on domain d_4 (cost=0.00..1.55 rows=55 width=8) (actual rows= loops=)

171. 0.000 0.000 ↓ 0.0

Index Scan using pk_indicator on indicator i_4 (cost=0.27..0.55 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = id_4.indicator_id)
172. 0.000 0.000 ↓ 0.0

Hash Join (cost=37.99..105.93 rows=116 width=76) (actual rows= loops=)

  • Hash Cond: ((cms_2.channel_id = ic_3.channel_id) AND (cms_2.indicator_security_level_id = i_5.indicator_security_level_id))
173. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..66.55 rows=21 width=53) (actual rows= loops=)

  • Join Filter: (tp_5.start_date <= s_6.data_aggregation_cutoff_date)
174. 0.000 0.000 ↓ 0.0

Seq Scan on setting s_6 (cost=0.00..1.01 rows=1 width=4) (actual rows= loops=)

175. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..64.74 rows=64 width=61) (actual rows= loops=)

176. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..62.46 rows=1 width=49) (actual rows= loops=)

177. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.98..62.29 rows=1 width=30) (actual rows= loops=)

178. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.71..61.97 rows=1 width=20) (actual rows= loops=)

  • Join Filter: (cms_2.share_status_id = ss_4.id)
179. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.71..60.88 rows=1 width=24) (actual rows= loops=)

180. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..52.57 rows=1 width=16) (actual rows= loops=)

181. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.14..50.19 rows=1 width=24) (actual rows= loops=)

182. 0.000 0.000 ↓ 0.0

Seq Scan on share_data cms_2 (cost=0.00..41.94 rows=1 width=20) (actual rows= loops=)

  • Filter: ((lower(initiator_type) = 'organization'::text) AND (lower(recipient_type) = 'member'::text))
183. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_organization on organization o_2 (cost=0.14..8.16 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = cms_2.initiator_id)
184. 0.000 0.000 ↓ 0.0

Index Scan using idx_clinic_member_clinic_id on organization_member cm_5 (cost=0.28..2.38 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (organization_id = o_2.id)
  • Filter: ((deleted IS NOT TRUE) AND (account_id = 453) AND (member_status_id = 'A'::bpchar))
185. 0.000 0.000 ↓ 0.0

Index Scan using pk_organization_member on organization_member cm_other_2 (cost=0.28..8.30 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (id = cms_2.recipient_id)
  • Filter: ((deleted IS NOT TRUE) AND (member_status_id = 'A'::bpchar))
186. 0.000 0.000 ↓ 0.0

Seq Scan on share_status ss_4 (cost=0.00..1.07 rows=1 width=4) (actual rows= loops=)

  • Filter: (lower(name) = 'active'::text)
187. 0.000 0.000 ↓ 0.0

Index Scan using pk_practitioner on account a_other_2 (cost=0.27..0.32 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (id = cm_other_2.account_id)
188. 0.000 0.000 ↓ 0.0

Index Scan using pk_organization on organization c_other_2 (cost=0.14..0.17 rows=1 width=27) (actual rows= loops=)

  • Index Cond: (id = cm_other_2.organization_id)
189. 0.000 0.000 ↓ 0.0

Seq Scan on time_period tp_5 (cost=0.00..1.64 rows=64 width=12) (actual rows= loops=)

190. 0.000 0.000 ↓ 0.0

Hash (cost=36.45..36.45 rows=28 width=12) (actual rows= loops=)

191. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11.53..36.45 rows=28 width=12) (actual rows= loops=)

192. 0.000 0.000 ↓ 0.0

Hash Join (cost=11.26..19.91 rows=30 width=12) (actual rows= loops=)

  • Hash Cond: (ic_3.indicator_id = id_5.indicator_id)
193. 0.000 0.000 ↓ 0.0

Seq Scan on indicator_channel ic_3 (cost=0.00..6.89 rows=389 width=8) (actual rows= loops=)

194. 0.000 0.000 ↓ 0.0

Hash (cost=10.86..10.86 rows=32 width=4) (actual rows= loops=)

195. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.24..10.86 rows=32 width=4) (actual rows= loops=)

  • Hash Cond: (id_5.domain_id = d_5.id)
  • Join Filter: ((id_5.domain_id = 3) OR (d_5.parent_domain_id = 3))
196. 0.000 0.000 ↓ 0.0

Seq Scan on indicator_domain id_5 (cost=0.00..7.44 rows=444 width=8) (actual rows= loops=)

197. 0.000 0.000 ↓ 0.0

Hash (cost=1.55..1.55 rows=55 width=8) (actual rows= loops=)

198. 0.000 0.000 ↓ 0.0

Seq Scan on domain d_5 (cost=0.00..1.55 rows=55 width=8) (actual rows= loops=)

199. 0.000 0.000 ↓ 0.0

Index Scan using pk_indicator on indicator i_5 (cost=0.27..0.55 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = id_5.indicator_id)
200. 0.000 0.000 ↓ 0.0

Hash Join (cost=37.99..105.93 rows=116 width=76) (actual rows= loops=)

  • Hash Cond: ((cms_3.channel_id = ic_4.channel_id) AND (cms_3.indicator_security_level_id = i_6.indicator_security_level_id))
201. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..66.55 rows=21 width=53) (actual rows= loops=)

  • Join Filter: (tp_6.start_date <= s_7.data_aggregation_cutoff_date)
202. 0.000 0.000 ↓ 0.0

Seq Scan on setting s_7 (cost=0.00..1.01 rows=1 width=4) (actual rows= loops=)

203. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..64.74 rows=64 width=61) (actual rows= loops=)

204. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..62.46 rows=1 width=49) (actual rows= loops=)

205. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.98..62.29 rows=1 width=30) (actual rows= loops=)

206. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.71..61.97 rows=1 width=20) (actual rows= loops=)

  • Join Filter: (cms_3.share_status_id = ss_5.id)
207. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.71..60.88 rows=1 width=24) (actual rows= loops=)

208. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..52.57 rows=1 width=16) (actual rows= loops=)

209. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.14..50.19 rows=1 width=24) (actual rows= loops=)

210. 0.000 0.000 ↓ 0.0

Seq Scan on share_data cms_3 (cost=0.00..41.94 rows=1 width=20) (actual rows= loops=)

  • Filter: ((lower(recipient_type) = 'organization'::text) AND (lower(initiator_type) = 'member'::text))
211. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_organization on organization o_3 (cost=0.14..8.16 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = cms_3.recipient_id)
212. 0.000 0.000 ↓ 0.0

Index Scan using idx_clinic_member_clinic_id on organization_member cm_6 (cost=0.28..2.38 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (organization_id = o_3.id)
  • Filter: ((deleted IS NOT TRUE) AND (account_id = 453) AND (member_status_id = 'A'::bpchar))
213. 0.000 0.000 ↓ 0.0

Index Scan using pk_organization_member on organization_member cm_other_3 (cost=0.28..8.30 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (id = cms_3.initiator_id)
  • Filter: ((deleted IS NOT TRUE) AND (member_status_id = 'A'::bpchar))
214. 0.000 0.000 ↓ 0.0

Seq Scan on share_status ss_5 (cost=0.00..1.07 rows=1 width=4) (actual rows= loops=)

  • Filter: (lower(name) = 'active'::text)
215. 0.000 0.000 ↓ 0.0

Index Scan using pk_practitioner on account a_other_3 (cost=0.27..0.32 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (id = cm_other_3.account_id)
216. 0.000 0.000 ↓ 0.0

Index Scan using pk_organization on organization c_other_3 (cost=0.14..0.17 rows=1 width=27) (actual rows= loops=)

  • Index Cond: (id = cm_other_3.organization_id)
217. 0.000 0.000 ↓ 0.0

Seq Scan on time_period tp_6 (cost=0.00..1.64 rows=64 width=12) (actual rows= loops=)

218. 0.000 0.000 ↓ 0.0

Hash (cost=36.45..36.45 rows=28 width=12) (actual rows= loops=)

219. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11.53..36.45 rows=28 width=12) (actual rows= loops=)

220. 0.000 0.000 ↓ 0.0

Hash Join (cost=11.26..19.91 rows=30 width=12) (actual rows= loops=)

  • Hash Cond: (ic_4.indicator_id = id_6.indicator_id)
221. 0.000 0.000 ↓ 0.0

Seq Scan on indicator_channel ic_4 (cost=0.00..6.89 rows=389 width=8) (actual rows= loops=)

222. 0.000 0.000 ↓ 0.0

Hash (cost=10.86..10.86 rows=32 width=4) (actual rows= loops=)

223. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.24..10.86 rows=32 width=4) (actual rows= loops=)

  • Hash Cond: (id_6.domain_id = d_6.id)
  • Join Filter: ((id_6.domain_id = 3) OR (d_6.parent_domain_id = 3))
224. 0.000 0.000 ↓ 0.0

Seq Scan on indicator_domain id_6 (cost=0.00..7.44 rows=444 width=8) (actual rows= loops=)

225. 0.000 0.000 ↓ 0.0

Hash (cost=1.55..1.55 rows=55 width=8) (actual rows= loops=)

226. 0.000 0.000 ↓ 0.0

Seq Scan on domain d_6 (cost=0.00..1.55 rows=55 width=8) (actual rows= loops=)

227. 0.000 0.000 ↓ 0.0

Index Scan using pk_indicator on indicator i_6 (cost=0.27..0.55 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = id_6.indicator_id)
228. 0.000 0.000 ↓ 0.0

Unique (cost=1,205,308.67..1,207,352.66 rows=136,266 width=76) (actual rows= loops=)

229. 0.000 0.000 ↓ 0.0

Sort (cost=1,205,308.67..1,205,649.33 rows=136,266 width=76) (actual rows= loops=)

  • Sort Key: si.type, si.id, si.name, i.id, tp.id
230. 0.000 0.000 ↓ 0.0

Nested Loop (cost=58.23..1,187,632.86 rows=136,266 width=76) (actual rows= loops=)

  • Join Filter: (tp.start_date <= s_1.data_aggregation_cutoff_date)
231. 0.000 0.000 ↓ 0.0

Seq Scan on setting s_1 (cost=0.00..1.01 rows=1 width=4) (actual rows= loops=)

232. 0.000 0.000 ↓ 0.0

Hash Join (cost=58.23..1,182,521.86 rows=408,799 width=84) (actual rows= loops=)

  • Hash Cond: (o.id = om.organization_id)
233. 0.000 0.000 ↓ 0.0

Nested Loop (cost=49.92..976,579.89 rows=76,854,272 width=88) (actual rows= loops=)

234. 0.000 0.000 ↓ 0.0

Hash Join (cost=49.92..15,899.69 rows=1,200,848 width=76) (actual rows= loops=)

  • Hash Cond: (o.electronic_medical_record_id = iemr.electronic_medical_record_id)
235. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..963.46 rows=75,764 width=76) (actual rows= loops=)

236. 0.000 0.000 ↓ 0.0

CTE Scan on non_nof5_sources si (cost=0.00..8.06 rows=403 width=68) (actual rows= loops=)

237. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..8.82 rows=188 width=8) (actual rows= loops=)

238. 0.000 0.000 ↓ 0.0

Seq Scan on organization o (cost=0.00..7.88 rows=188 width=8) (actual rows= loops=)

239. 0.000 0.000 ↓ 0.0

Hash (cost=49.05..49.05 rows=70 width=8) (actual rows= loops=)

240. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11.81..49.05 rows=70 width=8) (actual rows= loops=)

  • Join Filter: (ic.indicator_id = iemr.indicator_id)
241. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11.53..36.82 rows=28 width=12) (actual rows= loops=)

  • Join Filter: (ic.indicator_id = i.id)
242. 0.000 0.000 ↓ 0.0

Hash Join (cost=11.26..19.91 rows=30 width=8) (actual rows= loops=)

  • Hash Cond: (ic.indicator_id = id.indicator_id)
243. 0.000 0.000 ↓ 0.0

Seq Scan on indicator_channel ic (cost=0.00..6.89 rows=389 width=4) (actual rows= loops=)

244. 0.000 0.000 ↓ 0.0

Hash (cost=10.86..10.86 rows=32 width=4) (actual rows= loops=)

245. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.24..10.86 rows=32 width=4) (actual rows= loops=)

  • Hash Cond: (id.domain_id = d.id)
  • Join Filter: ((id.domain_id = 3) OR (d.parent_domain_id = 3))
246. 0.000 0.000 ↓ 0.0

Seq Scan on indicator_domain id (cost=0.00..7.44 rows=444 width=8) (actual rows= loops=)

247. 0.000 0.000 ↓ 0.0

Hash (cost=1.55..1.55 rows=55 width=8) (actual rows= loops=)

248. 0.000 0.000 ↓ 0.0

Seq Scan on domain d (cost=0.00..1.55 rows=55 width=8) (actual rows= loops=)

249. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_indicator on indicator i (cost=0.27..0.55 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = id.indicator_id)
250. 0.000 0.000 ↓ 0.0

Index Scan using idx_indicator_emr_indicator_id on indicator_electronic_medical_record iemr (cost=0.28..0.41 rows=2 width=8) (actual rows= loops=)

  • Index Cond: (indicator_id = id.indicator_id)
251. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.96 rows=64 width=12) (actual rows= loops=)

252. 0.000 0.000 ↓ 0.0

Seq Scan on time_period tp (cost=0.00..1.64 rows=64 width=12) (actual rows= loops=)

253. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=4) (actual rows= loops=)

254. 0.000 0.000 ↓ 0.0

Index Scan using pk_organization_member on organization_member om (cost=0.28..8.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = 949)
255. 0.000 0.000 ↓ 0.0

CTE Scan on nof5_sources s (cost=0.00..5.18 rows=259 width=76) (actual rows= loops=)

256. 0.000 0.000 ↓ 0.0

CTE Scan on shares sh (cost=0.00..4.88 rows=244 width=76) (actual rows= loops=)