explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2b2G

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

Unique (cost=4,639.39..4,639.41 rows=1 width=118) (actual time=0.465..0.465 rows=0 loops=1)

2. 0.212 0.465 ↓ 0.0 0 1

Sort (cost=4,639.39..4,639.40 rows=1 width=118) (actual time=0.465..0.465 rows=0 loops=1)

  • Sort Key: shiftoccurrence.start_date, shiftoccurrence.end_date, s.shift_uuid, (lower(s.valid_range)) DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.001 0.253 ↓ 0.0 0 1

Nested Loop (cost=437.59..4,639.38 rows=1 width=118) (actual time=0.253..0.253 rows=0 loops=1)

4. 0.001 0.252 ↓ 0.0 0 1

Nested Loop (cost=437.16..4,635.94 rows=1 width=70) (actual time=0.252..0.252 rows=0 loops=1)

5. 0.002 0.251 ↓ 0.0 0 1

Bitmap Heap Scan on groups_org_part_default g (cost=2.64..142.50 rows=1 width=73) (actual time=0.251..0.251 rows=0 loops=1)

  • Recheck Cond: (organization_uuid = '2b0ef8fd-4c00-4dc3-836e-793721bb9b97'::uuid)
  • Filter: ((is_visible IS TRUE) AND (lower((target_name)::text) = 'enterprise bigdata support'::text))
6. 0.249 0.249 ↓ 0.0 0 1

Bitmap Index Scan on groups_org_part_default_organization_uuid_group_uuid_sequen_idx (cost=0.00..2.64 rows=96 width=0) (actual time=0.248..0.249 rows=0 loops=1)

  • Index Cond: (organization_uuid = '2b0ef8fd-4c00-4dc3-836e-793721bb9b97'::uuid)
7. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on shift_occurrence_org_part_default shiftoccurrence (cost=434.52..4,493.43 rows=1 width=48) (never executed)

  • Recheck Cond: ((group_uuid = g.group_uuid) AND (organization_uuid = '2b0ef8fd-4c00-4dc3-836e-793721bb9b97'::uuid))
  • Filter: (((tstzrange((start_date)::timestamp with time zone, (end_date)::timestamp with time zone, '[)'::text) @> '2019-12-31 16:00:00-08'::timestamp with time zone) OR (tstzrange((start_date)::timestamp with time zone, (end_date)::timestamp with time zone, '[)'::text) @> '2020-02-11 15:59:59-08'::timestamp with time zone) OR (tstzrange((start_date)::timestamp with time zone, (end_date)::timestamp with time zone, '[)'::text) <@ '["2019-12-31 16:00:00-08","2020-02-11 15:59:59-08"]'::tstzrange)) AND ((g.valid_range @> (end_date)::timestamp with time zone) OR ((NOT (SubPlan 1)) AND (g.revision_uuid = (SubPlan 2)))))
8. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=434.52..434.52 rows=1 width=0) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on shift_occurrence_org_part_default_group_uuid_idx (cost=0.00..32.49 rows=2,057 width=0) (never executed)

  • Index Cond: (group_uuid = g.group_uuid)
10. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on shift_occurrence_org_part_def_organization_uuid_start_date__idx (cost=0.00..401.69 rows=22,284 width=0) (never executed)

  • Index Cond: (organization_uuid = '2b0ef8fd-4c00-4dc3-836e-793721bb9b97'::uuid)
11.          

SubPlan (for Bitmap Heap Scan)

12. 0.000 0.000 ↓ 0.0 0

Append (cost=1.80..1,050.23 rows=106 width=0) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_61 (cost=1.80..4.68 rows=1 width=0) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
14. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_61_group_uuid_idx (cost=0.00..1.79 rows=2 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
15. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_22 (cost=4.99..6.51 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
16. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=4.99..4.99 rows=1 width=0) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_22_group_uuid_idx (cost=0.00..2.26 rows=63 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
18. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_22_valid_range_idx (cost=0.00..2.48 rows=94 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
19. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_8 (cost=12.52..14.04 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
20. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=12.52..12.52 rows=1 width=0) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_8_group_uuid_idx (cost=0.00..3.15 rows=165 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
22. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_8_valid_range_idx (cost=0.00..9.12 rows=378 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
23. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_49 (cost=4.28..5.80 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
24. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=4.28..4.28 rows=1 width=0) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_49_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
26. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_49_valid_range_idx (cost=0.00..2.21 rows=58 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
27. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_53 (cost=3.89..5.40 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
28. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.89..3.89 rows=1 width=0) (never executed)

29. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_53_valid_range_idx (cost=0.00..1.81 rows=22 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
30. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_53_group_uuid_idx (cost=0.00..1.82 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
31. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_12 (cost=1.83..9.28 rows=1 width=0) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
32. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_12_group_uuid_idx (cost=0.00..1.83 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
33. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_54 (cost=3.95..5.47 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
34. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.95..3.95 rows=1 width=0) (never executed)

35. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_54_group_uuid_idx (cost=0.00..1.83 rows=6 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
36. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_54_valid_range_idx (cost=0.00..1.88 rows=30 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
37. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_3 (cost=59.54..67.07 rows=5 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
38. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=59.54..59.54 rows=5 width=0) (never executed)

39. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_3_group_uuid_idx (cost=0.00..13.28 rows=914 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
40. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_3_valid_range_idx (cost=0.00..46.01 rows=2,097 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
41. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_96_group_uuid_idx on groups_org_part_96 (cost=0.28..3.30 rows=1 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
42. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_11 (cost=8.76..10.28 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
43. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=8.76..8.76 rows=1 width=0) (never executed)

44. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_11_group_uuid_idx (cost=0.00..2.04 rows=33 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
45. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_11_valid_range_idx (cost=0.00..6.47 rows=226 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
46. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_26_group_uuid_idx on groups_org_part_26 (cost=0.29..3.31 rows=1 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
47. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_45 (cost=1.80..4.71 rows=1 width=0) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
48. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_45_group_uuid_idx (cost=0.00..1.80 rows=2 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
49. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_86 (cost=3.86..5.38 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
50. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.86..3.86 rows=1 width=0) (never executed)

51. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_86_valid_range_idx (cost=0.00..1.80 rows=20 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
52. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_86_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
53. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_39 (cost=1.80..4.74 rows=1 width=0) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
54. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_39_group_uuid_idx (cost=0.00..1.80 rows=2 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
55. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_48 (cost=3.96..5.48 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
56. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.96..3.96 rows=1 width=0) (never executed)

57. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_48_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
58. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_48_valid_range_idx (cost=0.00..1.90 rows=33 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
59. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_1_group_uuid_idx on groups_org_part_1 (cost=0.43..272.89 rows=1 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
60. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_55 (cost=4.01..5.52 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
61. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=4.01..4.01 rows=1 width=0) (never executed)

62. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_55_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
63. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_55_valid_range_idx (cost=0.00..1.94 rows=39 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
64. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_30 (cost=1.82..7.74 rows=1 width=0) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
65. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_30_group_uuid_idx (cost=0.00..1.82 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
66. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_14 (cost=6.63..8.14 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
67. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=6.63..6.63 rows=1 width=0) (never executed)

68. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_14_group_uuid_idx (cost=0.00..1.84 rows=7 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
69. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_14_valid_range_idx (cost=0.00..4.53 rows=167 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
70. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_98_group_uuid_idx on groups_org_part_98 (cost=0.28..3.30 rows=1 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
71. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_46 (cost=1.80..4.74 rows=1 width=0) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
72. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_46_group_uuid_idx (cost=0.00..1.80 rows=2 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
73. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_65 (cost=3.91..5.42 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
74. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.91..3.91 rows=1 width=0) (never executed)

75. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_65_valid_range_idx (cost=0.00..1.78 rows=18 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
76. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_65_group_uuid_idx (cost=0.00..1.87 rows=12 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
77. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_6 (cost=30.15..31.67 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
78. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=30.15..30.15 rows=1 width=0) (never executed)

79. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_6_group_uuid_idx (cost=0.00..2.77 rows=114 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
80. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_6_valid_range_idx (cost=0.00..27.13 rows=1,179 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
81. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_71 (cost=3.88..5.40 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
82. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.88..3.88 rows=1 width=0) (never executed)

83. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_71_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
84. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_71_valid_range_idx (cost=0.00..1.81 rows=22 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
85. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_47 (cost=4.05..5.57 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
86. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=4.05..4.05 rows=1 width=0) (never executed)

87. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_47_group_uuid_idx (cost=0.00..1.89 rows=14 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
88. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_47_valid_range_idx (cost=0.00..1.91 rows=35 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
89. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_4 (cost=34.30..37.32 rows=2 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
90. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=34.30..34.30 rows=2 width=0) (never executed)

91. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_4_group_uuid_idx (cost=0.00..6.70 rows=437 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
92. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_4_valid_range_idx (cost=0.00..27.35 rows=1,209 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
93. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_73_group_uuid_idx on groups_org_part_73 (cost=0.28..3.30 rows=1 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
94. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_78 (cost=3.88..5.40 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
95. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.88..3.88 rows=1 width=0) (never executed)

96. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_78_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
97. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_78_valid_range_idx (cost=0.00..1.81 rows=22 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
98. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_19 (cost=4.60..6.11 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
99. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=4.60..4.60 rows=1 width=0) (never executed)

100. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_19_group_uuid_idx (cost=0.00..1.82 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
101. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_19_valid_range_idx (cost=0.00..2.53 rows=100 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
102. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_32 (cost=4.43..5.95 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
103. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=4.43..4.43 rows=1 width=0) (never executed)

104. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_32_group_uuid_idx (cost=0.00..1.85 rows=9 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
105. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_32_valid_range_idx (cost=0.00..2.32 rows=73 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
106. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_2_group_uuid_idx on groups_org_part_2 (cost=0.42..52.17 rows=1 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
107. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_97 (cost=3.85..5.36 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
108. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.85..3.85 rows=1 width=0) (never executed)

109. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_97_valid_range_idx (cost=0.00..1.78 rows=18 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
110. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_97_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
111. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_27 (cost=4.52..6.04 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
112. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=4.52..4.52 rows=1 width=0) (never executed)

113. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_27_group_uuid_idx (cost=0.00..1.83 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
114. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_27_valid_range_idx (cost=0.00..2.44 rows=89 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
115. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_16 (cost=6.41..7.93 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
116. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=6.41..6.41 rows=1 width=0) (never executed)

117. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_16_group_uuid_idx (cost=0.00..2.00 rows=29 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
118. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_16_valid_range_idx (cost=0.00..4.16 rows=117 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
119. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_63 (cost=3.96..5.48 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
120. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.96..3.96 rows=1 width=0) (never executed)

121. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_63_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
122. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_63_valid_range_idx (cost=0.00..1.90 rows=33 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
123. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_28 (cost=1.82..7.73 rows=1 width=0) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
124. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_28_group_uuid_idx (cost=0.00..1.82 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
125. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_15 (cost=1.80..4.78 rows=1 width=0) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
126. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_15_group_uuid_idx (cost=0.00..1.80 rows=2 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
127. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_20 (cost=6.52..8.04 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
128. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=6.52..6.52 rows=1 width=0) (never executed)

129. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_20_group_uuid_idx (cost=0.00..1.83 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
130. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_20_valid_range_idx (cost=0.00..4.44 rows=155 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
131. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_66 (cost=4.98..6.50 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
132. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=4.98..4.98 rows=1 width=0) (never executed)

133. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_66_valid_range_idx (cost=0.00..1.76 rows=15 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
134. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_66_group_uuid_idx (cost=0.00..2.96 rows=158 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
135. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_89 (cost=3.83..5.35 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
136. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.83..3.83 rows=1 width=0) (never executed)

137. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_89_valid_range_idx (cost=0.00..1.75 rows=14 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
138. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_89_group_uuid_idx (cost=0.00..1.82 rows=6 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
139. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_24 (cost=4.52..6.04 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
140. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=4.52..4.52 rows=1 width=0) (never executed)

141. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_24_group_uuid_idx (cost=0.00..1.86 rows=10 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
142. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_24_valid_range_idx (cost=0.00..2.41 rows=84 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
143. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_85 (cost=3.85..5.36 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
144. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.85..3.85 rows=1 width=0) (never executed)

145. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_85_valid_range_idx (cost=0.00..1.78 rows=17 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
146. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_85_group_uuid_idx (cost=0.00..1.82 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
147. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_43 (cost=4.01..5.52 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
148. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=4.01..4.01 rows=1 width=0) (never executed)

149. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_43_group_uuid_idx (cost=0.00..1.80 rows=3 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
150. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_43_valid_range_idx (cost=0.00..1.95 rows=40 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
151. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_7 (cost=28.27..29.79 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
152. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=28.27..28.27 rows=1 width=0) (never executed)

153. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_7_group_uuid_idx (cost=0.00..2.50 rows=78 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
154. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_7_valid_range_idx (cost=0.00..25.52 rows=1,164 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
155. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_58 (cost=3.98..5.50 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
156. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.98..3.98 rows=1 width=0) (never executed)

157. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_58_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
158. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_58_valid_range_idx (cost=0.00..1.92 rows=36 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
159. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_93_valid_range_idx on groups_org_part_93 (cost=0.14..3.16 rows=1 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
  • Filter: ((is_visible IS TRUE) AND (shiftoccurrence.group_uuid = group_uuid))
160. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_64 (cost=3.92..5.44 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
161. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.92..3.92 rows=1 width=0) (never executed)

162. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_64_group_uuid_idx (cost=0.00..1.82 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
163. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_64_valid_range_idx (cost=0.00..1.85 rows=27 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
164. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_37 (cost=4.22..5.74 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
165. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=4.22..4.22 rows=1 width=0) (never executed)

166. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_37_group_uuid_idx (cost=0.00..1.96 rows=24 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
167. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_37_valid_range_idx (cost=0.00..2.00 rows=47 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
168. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_90 (cost=3.83..5.35 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
169. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.83..3.83 rows=1 width=0) (never executed)

170. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_90_valid_range_idx (cost=0.00..1.78 rows=17 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
171. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_90_group_uuid_idx (cost=0.00..1.80 rows=3 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
172. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_60_group_uuid_idx on groups_org_part_60 (cost=0.28..3.30 rows=1 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
173. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_81_group_uuid_idx on groups_org_part_81 (cost=0.28..3.30 rows=1 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
174. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_38 (cost=6.23..7.74 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
175. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=6.23..6.23 rows=1 width=0) (never executed)

176. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_38_group_uuid_idx (cost=0.00..1.83 rows=6 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
177. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_38_valid_range_idx (cost=0.00..4.14 rows=115 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
178. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_76 (cost=3.89..5.40 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
179. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.89..3.89 rows=1 width=0) (never executed)

180. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_76_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
181. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_76_valid_range_idx (cost=0.00..1.82 rows=23 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
182. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_100_group_uuid_idx on groups_org_part_100 (cost=0.28..3.30 rows=1 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
183. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_41 (cost=1.81..6.28 rows=1 width=0) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
184. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_41_group_uuid_idx (cost=0.00..1.81 rows=3 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
185. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_25 (cost=6.16..7.68 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
186. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=6.16..6.16 rows=1 width=0) (never executed)

187. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_25_group_uuid_idx (cost=0.00..1.83 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
188. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_25_valid_range_idx (cost=0.00..4.09 rows=108 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
189. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_59 (cost=3.94..5.46 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
190. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.94..3.94 rows=1 width=0) (never executed)

191. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_59_group_uuid_idx (cost=0.00..1.82 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
192. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_59_valid_range_idx (cost=0.00..1.87 rows=29 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
193. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_50_group_uuid_idx on groups_org_part_50 (cost=0.28..3.31 rows=1 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
194. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_72 (cost=3.97..5.49 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
195. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.97..3.97 rows=1 width=0) (never executed)

196. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_72_group_uuid_idx (cost=0.00..1.80 rows=3 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
197. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_72_valid_range_idx (cost=0.00..1.91 rows=35 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
198. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_84 (cost=3.86..5.38 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
199. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.86..3.86 rows=1 width=0) (never executed)

200. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_84_valid_range_idx (cost=0.00..1.80 rows=20 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
201. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_84_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
202. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_91 (cost=3.85..5.36 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
203. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.85..3.85 rows=1 width=0) (never executed)

204. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_91_valid_range_idx (cost=0.00..1.78 rows=17 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
205. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_91_group_uuid_idx (cost=0.00..1.82 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
206. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_29 (cost=1.81..6.29 rows=1 width=0) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
207. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_29_group_uuid_idx (cost=0.00..1.81 rows=3 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
208. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_70 (cost=3.88..5.40 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
209. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.88..3.88 rows=1 width=0) (never executed)

210. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_70_valid_range_idx (cost=0.00..1.78 rows=17 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
211. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_70_group_uuid_idx (cost=0.00..1.85 rows=10 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
212. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_92 (cost=3.85..5.37 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
213. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.85..3.85 rows=1 width=0) (never executed)

214. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_92_valid_range_idx (cost=0.00..1.79 rows=19 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
215. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_92_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
216. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_34_group_uuid_idx on groups_org_part_34 (cost=0.29..3.31 rows=1 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
217. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_88_group_uuid_idx on groups_org_part_88 (cost=0.28..3.30 rows=1 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
218. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_95 (cost=3.84..5.36 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
219. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.84..3.84 rows=1 width=0) (never executed)

220. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_95_valid_range_idx (cost=0.00..1.77 rows=16 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
221. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_95_group_uuid_idx (cost=0.00..1.82 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
222. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_9_group_uuid_idx on groups_org_part_9 (cost=0.29..3.31 rows=1 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
223. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_44 (cost=1.80..4.72 rows=1 width=0) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
224. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_44_group_uuid_idx (cost=0.00..1.80 rows=2 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
225. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_80_valid_range_idx on groups_org_part_80 (cost=0.14..3.16 rows=1 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
  • Filter: ((is_visible IS TRUE) AND (shiftoccurrence.group_uuid = group_uuid))
226. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_35 (cost=4.21..5.72 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
227. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=4.21..4.21 rows=1 width=0) (never executed)

228. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_35_group_uuid_idx (cost=0.00..1.91 rows=17 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
229. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_35_valid_range_idx (cost=0.00..2.04 rows=52 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
230. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_79 (cost=3.97..5.49 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
231. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.97..3.97 rows=1 width=0) (never executed)

232. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_79_valid_range_idx (cost=0.00..1.74 rows=13 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
233. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_79_group_uuid_idx (cost=0.00..1.98 rows=26 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
234. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_87 (cost=3.87..5.39 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
235. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.87..3.87 rows=1 width=0) (never executed)

236. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_87_valid_range_idx (cost=0.00..1.79 rows=19 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
237. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_87_group_uuid_idx (cost=0.00..1.82 rows=6 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
238. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_82 (cost=3.87..5.39 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
239. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.87..3.87 rows=1 width=0) (never executed)

240. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_82_valid_range_idx (cost=0.00..1.81 rows=21 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
241. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_82_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
242. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_83 (cost=1.66..4.25 rows=1 width=0) (never executed)

  • Recheck Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
  • Filter: ((is_visible IS TRUE) AND (shiftoccurrence.group_uuid = group_uuid))
243. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_83_valid_range_idx (cost=0.00..1.66 rows=2 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
244. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_42_group_uuid_idx on groups_org_part_42 (cost=0.29..3.31 rows=1 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
245. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_10_group_uuid_idx on groups_org_part_10 (cost=0.41..4.96 rows=1 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
246. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_67 (cost=3.93..5.45 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
247. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.93..3.93 rows=1 width=0) (never executed)

248. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_67_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
249. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_67_valid_range_idx (cost=0.00..1.87 rows=29 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
250. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_31 (cost=4.47..5.99 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
251. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=4.47..4.47 rows=1 width=0) (never executed)

252. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_31_group_uuid_idx (cost=0.00..1.98 rows=26 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
253. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_31_valid_range_idx (cost=0.00..2.24 rows=62 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
254. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_56 (cost=3.98..5.49 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
255. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.98..3.98 rows=1 width=0) (never executed)

256. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_56_group_uuid_idx (cost=0.00..1.82 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
257. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_56_valid_range_idx (cost=0.00..1.90 rows=34 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
258. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_36 (cost=5.16..6.68 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
259. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=5.16..5.16 rows=1 width=0) (never executed)

260. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_36_valid_range_idx (cost=0.00..2.00 rows=46 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
261. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_36_group_uuid_idx (cost=0.00..2.91 rows=150 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
262. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_99 (cost=3.83..5.35 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
263. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.83..3.83 rows=1 width=0) (never executed)

264. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_99_valid_range_idx (cost=0.00..1.77 rows=16 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
265. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_99_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
266. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_62 (cost=4.69..6.20 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
267. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=4.69..4.69 rows=1 width=0) (never executed)

268. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_62_valid_range_idx (cost=0.00..1.78 rows=18 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
269. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_62_group_uuid_idx (cost=0.00..2.65 rows=116 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
270. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_40 (cost=4.15..5.66 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
271. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=4.15..4.15 rows=1 width=0) (never executed)

272. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_40_group_uuid_idx (cost=0.00..1.85 rows=9 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
273. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_40_valid_range_idx (cost=0.00..2.04 rows=52 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
274. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_57 (cost=3.96..5.48 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
275. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.96..3.96 rows=1 width=0) (never executed)

276. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_57_group_uuid_idx (cost=0.00..1.82 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
277. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_57_valid_range_idx (cost=0.00..1.89 rows=32 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
278. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_21 (cost=5.95..7.47 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
279. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=5.95..5.95 rows=1 width=0) (never executed)

280. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_21_valid_range_idx (cost=0.00..2.47 rows=92 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
281. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_21_group_uuid_idx (cost=0.00..3.23 rows=193 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
282. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_74 (cost=3.95..5.46 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
283. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.95..3.95 rows=1 width=0) (never executed)

284. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_74_group_uuid_idx (cost=0.00..1.84 rows=8 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
285. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_74_valid_range_idx (cost=0.00..1.85 rows=27 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
286. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_51_group_uuid_idx on groups_org_part_51 (cost=0.28..3.31 rows=1 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
287. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_23 (cost=1.83..9.27 rows=1 width=0) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
288. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_23_group_uuid_idx (cost=0.00..1.83 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
289. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_52_group_uuid_idx on groups_org_part_52 (cost=0.28..4.32 rows=1 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
290. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_75 (cost=3.90..5.42 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
291. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.90..3.90 rows=1 width=0) (never executed)

292. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_75_valid_range_idx (cost=0.00..1.76 rows=15 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
293. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_75_group_uuid_idx (cost=0.00..1.89 rows=15 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
294. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_94 (cost=3.82..5.34 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
295. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.82..3.82 rows=1 width=0) (never executed)

296. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_94_valid_range_idx (cost=0.00..1.75 rows=14 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
297. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_94_group_uuid_idx (cost=0.00..1.82 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
298. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_68 (cost=3.94..5.46 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
299. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.94..3.94 rows=1 width=0) (never executed)

300. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_68_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
301. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_68_valid_range_idx (cost=0.00..1.88 rows=30 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
302. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_18 (cost=1.81..6.29 rows=1 width=0) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
303. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_18_group_uuid_idx (cost=0.00..1.81 rows=3 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
304. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_77_group_uuid_idx on groups_org_part_77 (cost=0.28..3.38 rows=1 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
305. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_5 (cost=28.11..29.63 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
306. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=28.11..28.11 rows=1 width=0) (never executed)

307. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_5_group_uuid_idx (cost=0.00..2.22 rows=40 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
308. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_5_valid_range_idx (cost=0.00..25.64 rows=1,181 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
309. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_13 (cost=1.81..6.28 rows=1 width=0) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
310. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_13_group_uuid_idx (cost=0.00..1.81 rows=3 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
311. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_33 (cost=1.81..6.26 rows=1 width=0) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
312. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_33_group_uuid_idx (cost=0.00..1.81 rows=3 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
313. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_69 (cost=4.30..5.82 rows=1 width=0) (never executed)

  • Recheck Cond: ((valid_range @> (shiftoccurrence.end_date)::timestamp with time zone) AND (shiftoccurrence.group_uuid = group_uuid))
  • Filter: (is_visible IS TRUE)
314. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=4.30..4.30 rows=1 width=0) (never executed)

315. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_69_valid_range_idx (cost=0.00..1.76 rows=15 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
316. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_69_group_uuid_idx (cost=0.00..2.29 rows=68 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
317. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_17 (cost=6.76..8.28 rows=1 width=0) (never executed)

  • Recheck Cond: ((shiftoccurrence.group_uuid = group_uuid) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
318. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=6.76..6.76 rows=1 width=0) (never executed)

319. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_17_group_uuid_idx (cost=0.00..1.83 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
320. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_17_valid_range_idx (cost=0.00..4.68 rows=187 width=0) (never executed)

  • Index Cond: (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone)
321. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_default_group_uuid_idx on groups_org_part_default (cost=0.42..9.53 rows=1 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> (shiftoccurrence.end_date)::timestamp with time zone))
322. 0.000 0.000 ↓ 0.0 0

Limit (cost=4,045.67..4,045.67 rows=1 width=37) (never executed)

323. 0.000 0.000 ↓ 0.0 0

Sort (cost=4,045.67..4,053.32 rows=3,059 width=37) (never executed)

  • Sort Key: groups_org_part_61_1.valid_range
324. 0.000 0.000 ↓ 0.0 0

Append (cost=1.80..4,030.37 rows=3,059 width=37) (never executed)

325. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_61 groups_org_part_61_1 (cost=1.80..4.67 rows=2 width=34) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
326. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_61_group_uuid_idx (cost=0.00..1.79 rows=2 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
327. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_22 groups_org_part_22_1 (cost=2.28..88.25 rows=62 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
328. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_22_group_uuid_idx (cost=0.00..2.26 rows=63 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
329. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_8 groups_org_part_8_1 (cost=3.20..221.07 rows=164 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
330. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_8_group_uuid_idx (cost=0.00..3.15 rows=165 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
331. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_49 groups_org_part_49_1 (cost=1.82..7.64 rows=4 width=35) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
332. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_49_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
333. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_53 groups_org_part_53_1 (cost=1.82..8.81 rows=5 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
334. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_53_group_uuid_idx (cost=0.00..1.82 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
335. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_12 groups_org_part_12_1 (cost=1.83..9.25 rows=5 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
336. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_12_group_uuid_idx (cost=0.00..1.83 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
337. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_54 groups_org_part_54_1 (cost=1.83..10.31 rows=6 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
338. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_54_group_uuid_idx (cost=0.00..1.83 rows=6 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
339. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_3 groups_org_part_3_1 (cost=13.50..1,176.96 rows=910 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
340. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_3_group_uuid_idx (cost=0.00..13.28 rows=914 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
341. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_96_group_uuid_idx on groups_org_part_96 groups_org_part_96_1 (cost=0.28..3.30 rows=1 width=30) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
342. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_11 groups_org_part_11_1 (cost=2.05..49.14 rows=33 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
343. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_11_group_uuid_idx (cost=0.00..2.04 rows=33 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
344. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_26_group_uuid_idx on groups_org_part_26 groups_org_part_26_1 (cost=0.29..3.30 rows=1 width=30) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
345. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_45 groups_org_part_45_1 (cost=1.80..4.70 rows=2 width=34) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
346. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_45_group_uuid_idx (cost=0.00..1.80 rows=2 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
347. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_86 groups_org_part_86_1 (cost=1.81..7.49 rows=4 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
348. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_86_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
349. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_39 groups_org_part_39_1 (cost=1.80..4.73 rows=2 width=33) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
350. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_39_group_uuid_idx (cost=0.00..1.80 rows=2 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
351. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_48 groups_org_part_48_1 (cost=1.81..7.65 rows=4 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
352. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_48_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
353. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_1_group_uuid_idx on groups_org_part_1 groups_org_part_1_1 (cost=0.43..272.00 rows=176 width=37) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
354. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_55_group_uuid_idx on groups_org_part_55 groups_org_part_55_1 (cost=0.28..7.57 rows=4 width=36) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
355. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_30 groups_org_part_30_1 (cost=1.82..7.72 rows=4 width=35) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
356. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_30_group_uuid_idx (cost=0.00..1.82 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
357. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_14 groups_org_part_14_1 (cost=1.84..12.12 rows=7 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
358. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_14_group_uuid_idx (cost=0.00..1.84 rows=7 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
359. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_98_group_uuid_idx on groups_org_part_98 groups_org_part_98_1 (cost=0.28..3.29 rows=1 width=30) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
360. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_46 groups_org_part_46_1 (cost=1.80..4.73 rows=2 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
361. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_46_group_uuid_idx (cost=0.00..1.80 rows=2 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
362. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_65_group_uuid_idx on groups_org_part_65 groups_org_part_65_1 (cost=0.28..16.62 rows=12 width=37) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
363. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_6 groups_org_part_6_1 (cost=2.80..165.83 rows=113 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
364. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_6_group_uuid_idx (cost=0.00..2.77 rows=114 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
365. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_71_group_uuid_idx on groups_org_part_71 groups_org_part_71_1 (cost=0.28..7.41 rows=4 width=36) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
366. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_47 groups_org_part_47_1 (cost=1.89..21.21 rows=14 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
367. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_47_group_uuid_idx (cost=0.00..1.89 rows=14 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
368. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_4 groups_org_part_4_1 (cost=6.80..597.91 rows=410 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
369. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_4_group_uuid_idx (cost=0.00..6.70 rows=437 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
370. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_73_group_uuid_idx on groups_org_part_73 groups_org_part_73_1 (cost=0.28..3.30 rows=1 width=37) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
371. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_78 groups_org_part_78_1 (cost=1.81..7.51 rows=4 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
372. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_78_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
373. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_19 groups_org_part_19_1 (cost=1.82..7.69 rows=4 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
374. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_19_group_uuid_idx (cost=0.00..1.82 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
375. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_32 groups_org_part_32_1 (cost=1.85..14.81 rows=9 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
376. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_32_group_uuid_idx (cost=0.00..1.85 rows=9 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
377. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_2_group_uuid_idx on groups_org_part_2 groups_org_part_2_1 (cost=0.42..52.00 rows=33 width=37) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
378. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_97 groups_org_part_97_1 (cost=1.81..7.45 rows=4 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
379. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_97_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
380. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_27 groups_org_part_27_1 (cost=1.83..9.14 rows=5 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
381. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_27_group_uuid_idx (cost=0.00..1.83 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
382. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_16 groups_org_part_16_1 (cost=2.01..42.69 rows=27 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
383. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_16_group_uuid_idx (cost=0.00..2.00 rows=29 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
384. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_63 groups_org_part_63_1 (cost=1.81..7.57 rows=4 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
385. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_63_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
386. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_28 groups_org_part_28_1 (cost=1.82..7.71 rows=4 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
387. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_28_group_uuid_idx (cost=0.00..1.82 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
388. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_15 groups_org_part_15_1 (cost=1.80..4.77 rows=2 width=34) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
389. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_15_group_uuid_idx (cost=0.00..1.80 rows=2 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
390. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_20 groups_org_part_20_1 (cost=1.83..9.21 rows=4 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
391. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_20_group_uuid_idx (cost=0.00..1.83 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
392. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_66_group_uuid_idx on groups_org_part_66 groups_org_part_66_1 (cost=0.28..12.30 rows=100 width=37) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
393. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_89 groups_org_part_89_1 (cost=1.83..10.06 rows=6 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
394. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_89_group_uuid_idx (cost=0.00..1.82 rows=6 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
395. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_24 groups_org_part_24_1 (cost=1.86..16.30 rows=10 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
396. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_24_group_uuid_idx (cost=0.00..1.86 rows=10 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
397. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_85 groups_org_part_85_1 (cost=1.82..8.81 rows=5 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
398. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_85_group_uuid_idx (cost=0.00..1.82 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
399. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_43 groups_org_part_43_1 (cost=1.81..6.16 rows=3 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
400. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_43_group_uuid_idx (cost=0.00..1.80 rows=3 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
401. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_7 groups_org_part_7_1 (cost=2.52..115.65 rows=77 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
402. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_7_group_uuid_idx (cost=0.00..2.50 rows=78 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
403. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_58 groups_org_part_58_1 (cost=1.81..7.60 rows=4 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
404. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_58_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
405. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_93_group_uuid_idx on groups_org_part_93 groups_org_part_93_1 (cost=0.15..3.17 rows=1 width=48) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
406. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_64_group_uuid_idx on groups_org_part_64 groups_org_part_64_1 (cost=0.28..8.87 rows=5 width=36) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
407. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_37 groups_org_part_37_1 (cost=1.97..34.75 rows=24 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
408. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_37_group_uuid_idx (cost=0.00..1.96 rows=24 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
409. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_90 groups_org_part_90_1 (cost=1.80..6.09 rows=3 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
410. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_90_group_uuid_idx (cost=0.00..1.80 rows=3 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
411. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_60_group_uuid_idx on groups_org_part_60 groups_org_part_60_1 (cost=0.28..3.30 rows=1 width=30) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
412. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_81_group_uuid_idx on groups_org_part_81 groups_org_part_81_1 (cost=0.28..3.30 rows=1 width=30) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
413. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_38 groups_org_part_38_1 (cost=1.83..10.63 rows=6 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
414. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_38_group_uuid_idx (cost=0.00..1.83 rows=6 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
415. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_76 groups_org_part_76_1 (cost=1.81..7.51 rows=4 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
416. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_76_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
417. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_100_group_uuid_idx on groups_org_part_100 groups_org_part_100_1 (cost=0.28..3.29 rows=1 width=37) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
418. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_41 groups_org_part_41_1 (cost=1.81..6.27 rows=3 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
419. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_41_group_uuid_idx (cost=0.00..1.81 rows=3 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
420. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_25 groups_org_part_25_1 (cost=1.83..9.20 rows=5 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
421. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_25_group_uuid_idx (cost=0.00..1.83 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
422. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_59_group_uuid_idx on groups_org_part_59 groups_org_part_59_1 (cost=0.28..8.86 rows=5 width=36) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
423. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_50_group_uuid_idx on groups_org_part_50 groups_org_part_50_1 (cost=0.28..3.30 rows=1 width=30) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
424. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_72 groups_org_part_72_1 (cost=1.81..6.15 rows=3 width=35) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
425. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_72_group_uuid_idx (cost=0.00..1.80 rows=3 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
426. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_84 groups_org_part_84_1 (cost=1.81..7.50 rows=4 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
427. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_84_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
428. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_91 groups_org_part_91_1 (cost=1.82..8.80 rows=5 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
429. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_91_group_uuid_idx (cost=0.00..1.82 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
430. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_29 groups_org_part_29_1 (cost=1.81..6.27 rows=3 width=35) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
431. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_29_group_uuid_idx (cost=0.00..1.81 rows=3 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
432. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_70 groups_org_part_70_1 (cost=1.86..15.20 rows=10 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
433. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_70_group_uuid_idx (cost=0.00..1.85 rows=10 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
434. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_92_group_uuid_idx on groups_org_part_92 groups_org_part_92_1 (cost=0.28..7.56 rows=4 width=36) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
435. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_34_group_uuid_idx on groups_org_part_34 groups_org_part_34_1 (cost=0.29..3.30 rows=1 width=34) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
436. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_88_group_uuid_idx on groups_org_part_88 groups_org_part_88_1 (cost=0.28..3.29 rows=1 width=37) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
437. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_95 groups_org_part_95_1 (cost=1.82..8.78 rows=5 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
438. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_95_group_uuid_idx (cost=0.00..1.82 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
439. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_9_group_uuid_idx on groups_org_part_9 groups_org_part_9_1 (cost=0.29..3.31 rows=1 width=33) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
440. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_44 groups_org_part_44_1 (cost=1.80..4.71 rows=2 width=33) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
441. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_44_group_uuid_idx (cost=0.00..1.80 rows=2 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
442. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_80_group_uuid_idx on groups_org_part_80 groups_org_part_80_1 (cost=0.15..3.17 rows=1 width=48) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
443. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_35 groups_org_part_35_1 (cost=1.92..26.10 rows=17 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
444. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_35_group_uuid_idx (cost=0.00..1.91 rows=17 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
445. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_79 groups_org_part_79_1 (cost=1.98..28.96 rows=25 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
446. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_79_group_uuid_idx (cost=0.00..1.98 rows=26 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
447. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_87_group_uuid_idx on groups_org_part_87 groups_org_part_87_1 (cost=0.28..10.05 rows=6 width=36) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
448. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_82 groups_org_part_82_1 (cost=1.81..7.52 rows=4 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
449. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_82_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
450. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_83 groups_org_part_83_1 (cost=1.68..6.46 rows=4 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
451. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_83_group_uuid_idx (cost=0.00..1.68 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
452. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_42_group_uuid_idx on groups_org_part_42 groups_org_part_42_1 (cost=0.29..3.31 rows=1 width=36) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
453. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_10_group_uuid_idx on groups_org_part_10 groups_org_part_10_1 (cost=0.41..4.95 rows=2 width=37) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
454. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_67 groups_org_part_67_1 (cost=1.81..7.56 rows=4 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
455. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_67_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
456. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_31 groups_org_part_31_1 (cost=1.99..37.83 rows=26 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
457. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_31_group_uuid_idx (cost=0.00..1.98 rows=26 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
458. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_56_group_uuid_idx on groups_org_part_56 groups_org_part_56_1 (cost=0.28..9.01 rows=5 width=36) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
459. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_36 groups_org_part_36_1 (cost=2.95..136.12 rows=146 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
460. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_36_group_uuid_idx (cost=0.00..2.91 rows=150 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
461. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_99 groups_org_part_99_1 (cost=1.81..7.46 rows=4 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
462. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_99_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
463. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_62 groups_org_part_62_1 (cost=2.68..80.28 rows=114 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
464. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_62_group_uuid_idx (cost=0.00..2.65 rows=116 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
465. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_40 groups_org_part_40_1 (cost=1.85..14.71 rows=9 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
466. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_40_group_uuid_idx (cost=0.00..1.85 rows=9 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
467. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_57 groups_org_part_57_1 (cost=1.82..8.95 rows=5 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
468. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_57_group_uuid_idx (cost=0.00..1.82 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
469. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_21 groups_org_part_21_1 (cost=3.28..193.20 rows=191 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
470. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_21_group_uuid_idx (cost=0.00..3.23 rows=193 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
471. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_74 groups_org_part_74_1 (cost=1.84..13.07 rows=8 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
472. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_74_group_uuid_idx (cost=0.00..1.84 rows=8 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
473. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_51_group_uuid_idx on groups_org_part_51 groups_org_part_51_1 (cost=0.28..3.30 rows=1 width=30) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
474. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_23 groups_org_part_23_1 (cost=1.83..9.25 rows=5 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
475. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_23_group_uuid_idx (cost=0.00..1.83 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
476. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_52_group_uuid_idx on groups_org_part_52 groups_org_part_52_1 (cost=0.28..4.31 rows=1 width=37) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
477. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_75_group_uuid_idx on groups_org_part_75 groups_org_part_75_1 (cost=0.28..14.92 rows=11 width=37) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
478. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_94_group_uuid_idx on groups_org_part_94 groups_org_part_94_1 (cost=0.28..8.48 rows=5 width=37) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
479. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_68 groups_org_part_68_1 (cost=1.81..7.55 rows=4 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
480. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_68_group_uuid_idx (cost=0.00..1.81 rows=4 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
481. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_18 groups_org_part_18_1 (cost=1.81..6.28 rows=3 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
482. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_18_group_uuid_idx (cost=0.00..1.81 rows=3 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
483. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_77_group_uuid_idx on groups_org_part_77 groups_org_part_77_1 (cost=0.28..3.37 rows=2 width=33) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
484. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_5 groups_org_part_5_1 (cost=2.23..61.22 rows=39 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
485. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_5_group_uuid_idx (cost=0.00..2.22 rows=40 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
486. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_13 groups_org_part_13_1 (cost=1.81..6.27 rows=3 width=37) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
487. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_13_group_uuid_idx (cost=0.00..1.81 rows=3 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
488. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_33 groups_org_part_33_1 (cost=1.81..6.25 rows=3 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
489. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_33_group_uuid_idx (cost=0.00..1.81 rows=3 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
490. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_69_group_uuid_idx on groups_org_part_69 groups_org_part_69_1 (cost=0.28..8.60 rows=43 width=37) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
491. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on groups_org_part_17 groups_org_part_17_1 (cost=1.83..9.23 rows=5 width=36) (never executed)

  • Recheck Cond: (shiftoccurrence.group_uuid = group_uuid)
  • Filter: (is_visible IS TRUE)
492. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on groups_org_part_17_group_uuid_idx (cost=0.00..1.83 rows=5 width=0) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
493. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_default_group_uuid_idx on groups_org_part_default groups_org_part_default_1 (cost=0.42..9.51 rows=5 width=35) (never executed)

  • Index Cond: (group_uuid = shiftoccurrence.group_uuid)
  • Filter: (is_visible IS TRUE)
494. 0.000 0.000 ↓ 0.0 0

Index Scan using shifts_org_part_default_pkey on shifts_org_part_default s (cost=0.43..3.42 rows=1 width=69) (never executed)

  • Index Cond: ((organization_uuid = '2b0ef8fd-4c00-4dc3-836e-793721bb9b97'::uuid) AND (revision_uuid = shiftoccurrence.shift_revision_uuid))
  • Filter: (is_visible IS TRUE)
Planning time : 22.923 ms
Execution time : 40.455 ms