explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lcCD

Settings
# exclusive inclusive rows x rows loops node
1. 4.721 9,909.663 ↑ 11.9 200 1

Hash Join (cost=30,619.87..5,874,615.60 rows=2,389 width=312) (actual time=5,988.681..9,909.663 rows=200 loops=1)

  • Hash Cond: (sho.shift_revision_uuid = sh.revision_uuid)
2. 0.653 3,380.630 ↑ 1,475.8 200 1

Nested Loop (cost=1.68..346.75 rows=295,165 width=80) (actual time=67.287..3,380.630 rows=200 loops=1)

3. 0.537 0.577 ↓ 2.0 200 1

HashAggregate (cost=1.25..2.25 rows=100 width=16) (actual time=0.098..0.577 rows=200 loops=1)

  • Group Key: unnest.unnest
4. 0.040 0.040 ↓ 2.0 200 1

Function Scan on unnest (cost=0.00..1.00 rows=100 width=16) (actual time=0.029..0.040 rows=200 loops=1)

5. 0.400 3,379.400 ↑ 1.0 1 200

Append (cost=0.42..3.43 rows=1 width=80) (actual time=16.891..16.897 rows=1 loops=200)

6. 3,379.000 3,379.000 ↑ 1.0 1 200

Index Scan using shift_occurrence_org_part_11_pkey on shift_occurrence_org_part_11 sho (cost=0.42..3.43 rows=1 width=80) (actual time=16.889..16.895 rows=1 loops=200)

  • Index Cond: ((organization_uuid = '9179fd37-1322-4957-8a99-7e2056388b4f'::uuid) AND (shift_occurrence_uuid = unnest.unnest))
7. 17.938 5,861.912 ↓ 1.0 24,749 1

Hash (cost=30,309.33..30,309.33 rows=24,709 width=235) (actual time=5,861.910..5,861.912 rows=24,749 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 7718kB
8. 5,719.618 5,843.974 ↓ 1.0 24,749 1

Bitmap Heap Scan on shifts sh (cost=329.92..30,309.33 rows=24,709 width=235) (actual time=155.560..5,843.974 rows=24,749 loops=1)

  • Recheck Cond: (organization_uuid = '9179fd37-1322-4957-8a99-7e2056388b4f'::uuid)
  • Heap Blocks: exact=2768
9. 124.356 124.356 ↓ 1.0 24,749 1

Bitmap Index Scan on shifts_organization_uuid_idx (cost=0.00..323.75 rows=24,709 width=0) (actual time=124.356..124.356 rows=24,749 loops=1)

  • Index Cond: (organization_uuid = '9179fd37-1322-4957-8a99-7e2056388b4f'::uuid)
10.          

SubPlan (forHash Join)

11. 3.600 662.400 ↑ 1.0 1 200

Limit (cost=2,445.70..2,445.70 rows=1 width=31) (actual time=3.297..3.312 rows=1 loops=200)

12. 12.000 658.800 ↑ 1,175.0 1 200

Sort (cost=2,445.70..2,448.64 rows=1,175 width=31) (actual time=3.294..3.294 rows=1 loops=200)

  • Sort Key: (lower(g.valid_range))
  • Sort Method: quicksort Memory: 25kB
13. 1.600 646.800 ↑ 1,175.0 1 200

Append (cost=0.28..2,439.82 rows=1,175 width=31) (actual time=3.071..3.234 rows=1 loops=200)

14. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_59_group_uuid_idx on groups_org_part_59 g (cost=0.28..3.35 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
15. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_22_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_22 g_1 (cost=0.41..48.64 rows=22 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
16. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_8_organization_uuid_group_uuid_sequence_low_idx on groups_org_part_8 g_2 (cost=0.42..120.53 rows=58 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
17. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_47_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_47 g_3 (cost=0.28..4.01 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
18. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_50_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_50 g_4 (cost=0.28..6.07 rows=2 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
19. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_12_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_12 g_5 (cost=0.41..5.52 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
20. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_51_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_51 g_6 (cost=0.28..5.38 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
21. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_3_organization_uuid_group_uuid_sequence_low_idx on groups_org_part_3 g_7 (cost=0.42..733.99 rows=370 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
22. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_94_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_94 g_8 (cost=0.28..3.31 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
23. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_99_group_uuid_idx on groups_org_part_99 g_9 (cost=0.28..3.34 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
24. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_11_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_11 g_10 (cost=0.41..26.20 rows=11 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
25. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_26_group_uuid_idx on groups_org_part_26 g_11 (cost=0.29..3.32 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
26. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_43_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_43 g_12 (cost=0.28..4.01 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
27. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_84_group_uuid_idx on groups_org_part_84 g_13 (cost=0.28..3.35 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
28. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_39_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_39 g_14 (cost=0.29..4.01 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
29. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_46_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_46 g_15 (cost=0.28..5.38 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
30. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_1_organization_uuid_group_uuid_sequence_low_idx on groups_org_part_1 g_16 (cost=0.56..129.84 rows=60 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
31. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_52_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_52 g_17 (cost=0.28..4.00 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
32. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_30_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_30 g_18 (cost=0.41..4.82 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
33. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_14_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_14 g_19 (cost=0.41..6.89 rows=2 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
34. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_96_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_96 g_20 (cost=0.28..3.31 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
35. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_44_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_44 g_21 (cost=0.28..4.01 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
36. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_63_group_uuid_idx on groups_org_part_63 g_22 (cost=0.28..3.61 rows=3 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
37. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_6_organization_uuid_group_uuid_sequence_low_idx on groups_org_part_6 g_23 (cost=0.42..108.08 rows=51 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
38. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_69_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_69 g_24 (cost=0.28..4.00 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
39. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_45_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_45 g_25 (cost=0.28..12.28 rows=4 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
40. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_4_organization_uuid_group_uuid_sequence_low_idx on groups_org_part_4 g_26 (cost=0.42..368.09 rows=168 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
41. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_71_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_71 g_27 (cost=0.28..3.31 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
42. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_76_group_uuid_idx on groups_org_part_76 g_28 (cost=0.28..3.35 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
43. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_19_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_19 g_29 (cost=0.41..5.51 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
44. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_32_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_32 g_30 (cost=0.29..8.84 rows=3 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
45. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_2_organization_uuid_group_uuid_sequence_low_idx on groups_org_part_2 g_31 (cost=0.42..24.71 rows=11 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
46. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_95_group_uuid_idx on groups_org_part_95 g_32 (cost=0.28..3.34 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
47. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_27_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_27 g_33 (cost=0.41..5.51 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
48. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_16_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_16 g_34 (cost=0.41..27.61 rows=12 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
49. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_61_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_61 g_35 (cost=0.28..4.00 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
50. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_28_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_28 g_36 (cost=0.41..4.13 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
51. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_15_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_15 g_37 (cost=0.41..4.14 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
52. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_20_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_20 g_38 (cost=0.41..4.83 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
53. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_64_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_64 g_39 (cost=0.28..54.25 rows=37 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
54. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_87_group_uuid_idx on groups_org_part_87 g_40 (cost=0.28..3.41 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
55. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_24_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_24 g_41 (cost=0.41..8.96 rows=3 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
56. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_83_group_uuid_idx on groups_org_part_83 g_42 (cost=0.28..3.38 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
57. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_41_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_41 g_43 (cost=0.28..4.70 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
58. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_7_organization_uuid_group_uuid_sequence_low_idx on groups_org_part_7 g_44 (cost=0.42..59.18 rows=27 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
59. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_55_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_55 g_45 (cost=0.28..4.00 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
60. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_90_group_uuid_idx on groups_org_part_90 g_46 (cost=0.28..3.38 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
61. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_62_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_62 g_47 (cost=0.28..5.38 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
62. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_37_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_37 g_48 (cost=0.29..24.76 rows=11 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
63. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_89_group_uuid_idx on groups_org_part_89 g_49 (cost=0.28..3.34 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
64. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_57_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_57 g_50 (cost=0.28..3.31 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
65. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_79_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_79 g_51 (cost=0.28..3.31 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
66. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_38_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_38 g_52 (cost=0.29..4.01 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
67. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_74_group_uuid_idx on groups_org_part_74 g_53 (cost=0.28..3.38 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
68. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_98_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_98 g_54 (cost=0.28..3.31 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
69. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_25_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_25 g_55 (cost=0.41..5.51 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
70. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_56_group_uuid_idx on groups_org_part_56 g_56 (cost=0.28..3.41 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
71. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_48_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_48 g_57 (cost=0.28..3.32 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
72. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_70_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_70 g_58 (cost=0.28..3.31 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
73. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_82_group_uuid_idx on groups_org_part_82 g_59 (cost=0.28..3.35 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
74. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_88_group_uuid_idx on groups_org_part_88 g_60 (cost=0.28..3.38 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
75. 645.200 645.200 ↑ 1.0 1 200

Index Scan using groups_org_part_29_group_uuid_idx on groups_org_part_29 g_61 (cost=0.29..3.32 rows=1 width=31) (actual time=3.064..3.226 rows=1 loops=200)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
  • Rows Removed by Filter: 0
76. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_68_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_68 g_62 (cost=0.28..8.14 rows=3 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
77. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_92_group_uuid_idx on groups_org_part_92 g_63 (cost=0.28..3.34 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
78. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_34_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_34 g_64 (cost=0.29..3.32 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
79. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_85_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_85 g_65 (cost=0.28..3.31 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
80. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_93_group_uuid_idx on groups_org_part_93 g_66 (cost=0.28..3.38 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
81. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_9_group_uuid_idx on groups_org_part_9 g_67 (cost=0.29..3.33 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
82. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_42_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_42 g_68 (cost=0.28..4.01 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
83. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_78_group_uuid_idx on groups_org_part_78 g_69 (cost=0.28..4.55 rows=13 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
84. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_35_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_35 g_70 (cost=0.29..15.73 rows=6 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
85. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_77_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_77 g_71 (cost=0.28..17.93 rows=9 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
86. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_86_group_uuid_idx on groups_org_part_86 g_72 (cost=0.28..3.41 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
87. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_100_group_uuid_idx on groups_org_part_100 g_73 (cost=0.28..3.38 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
88. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_80_group_uuid_idx on groups_org_part_80 g_74 (cost=0.28..3.38 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
89. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_81_group_uuid_idx on groups_org_part_81 g_75 (cost=0.28..3.35 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
90. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_10_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_10 g_76 (cost=0.41..4.14 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
91. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_65_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_65 g_77 (cost=0.28..4.00 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
92. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_31_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_31 g_78 (cost=0.41..20.68 rows=9 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
93. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_53_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_53 g_79 (cost=0.28..4.69 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
94. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_36_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_36 g_80 (cost=0.29..86.38 rows=51 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
95. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_97_group_uuid_idx on groups_org_part_97 g_81 (cost=0.28..3.38 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
96. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_60_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_60 g_82 (cost=0.28..55.71 rows=39 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
97. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_40_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_40 g_83 (cost=0.29..8.15 rows=3 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
98. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_54_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_54 g_84 (cost=0.28..4.69 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
99. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_21_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_21 g_85 (cost=0.41..121.66 rows=69 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
100. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_72_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_72 g_86 (cost=0.28..5.38 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
101. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_49_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_49 g_87 (cost=0.28..3.32 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
102. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_23_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_23 g_88 (cost=0.41..4.13 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
103. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_58_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_58 g_89 (cost=0.28..3.31 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
104. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_73_group_uuid_idx on groups_org_part_73 g_90 (cost=0.28..3.71 rows=3 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
105. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_91_group_uuid_idx on groups_org_part_91 g_91 (cost=0.28..3.38 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
106. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_66_group_uuid_idx on groups_org_part_66 g_92 (cost=0.28..3.35 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
107. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_18_group_uuid_idx on groups_org_part_18 g_93 (cost=0.29..3.32 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
108. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_75_group_uuid_idx on groups_org_part_75 g_94 (cost=0.28..3.35 rows=1 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
109. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_5_organization_uuid_group_uuid_sequence_low_idx on groups_org_part_5 g_95 (cost=0.42..32.98 rows=14 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
110. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_13_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_13 g_96 (cost=0.41..4.83 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
111. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_33_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_33 g_97 (cost=0.29..3.32 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
112. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_67_group_uuid_idx on groups_org_part_67 g_98 (cost=0.28..10.81 rows=30 width=31) (never executed)

  • Index Cond: (group_uuid = sho.group_uuid)
  • Filter: (is_visible AND (organization_uuid = sho.organization_uuid) AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
113. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_17_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_17 g_99 (cost=0.41..4.83 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))
114. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_default_organization_uuid_group_uuid_sequen_idx on groups_org_part_default g_100 (cost=0.55..3.58 rows=1 width=31) (never executed)

  • Index Cond: ((organization_uuid = sho.organization_uuid) AND (group_uuid = sho.group_uuid))
  • Filter: (is_visible AND ((valid_range && tstzrange((sho.start_date)::timestamp with time zone, (sho.end_date)::timestamp with time zone, '[]'::text)) OR upper_inf(valid_range)))