explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YNr5

Settings
# exclusive inclusive rows x rows loops node
1. 44.548 10,139.920 ↑ 1,997.5 23,775 1

Nested Loop (cost=73,799.79..114,036,901,880.96 rows=47,491,102 width=352) (actual time=340.385..10,139.920 rows=23,775 loops=1)

2. 14.978 8,906.622 ↑ 16.1 23,775 1

Nested Loop (cost=73,799.50..74,435.47 rows=383,580 width=80) (actual time=319.169..8,906.622 rows=23,775 loops=1)

3. 24.076 261.319 ↓ 118.9 23,775 1

HashAggregate (cost=73,799.08..73,801.08 rows=200 width=16) (actual time=245.369..261.319 rows=23,775 loops=1)

  • Group Key: t.shift_occurrence_uuid
4. 8.777 237.243 ↓ 15.0 23,775 1

Sort (cost=73,775.33..73,779.29 rows=1,583 width=24) (actual time=234.621..237.243 rows=23,775 loops=1)

  • Sort Key: t.start_date
  • Sort Method: quicksort Memory: 2626kB
5. 2.767 228.466 ↓ 15.0 23,775 1

Subquery Scan on t (cost=60,236.47..73,691.21 rows=1,583 width=24) (actual time=205.481..228.466 rows=23,775 loops=1)

  • Filter: (t.rn = 1)
  • Rows Removed by Filter: 982
6. 17.597 225.699 ↑ 12.8 24,757 1

WindowAgg (cost=60,236.47..69,733.93 rows=316,582 width=80) (actual time=205.476..225.699 rows=24,757 loops=1)

7. 38.678 208.102 ↑ 12.8 24,757 1

Sort (cost=60,236.47..61,027.93 rows=316,582 width=72) (actual time=205.445..208.102 rows=24,757 loops=1)

  • Sort Key: sh_1.shift_uuid, sho_1.start_date, sho_1.end_date, (lower(sh_1.valid_range)) DESC
  • Sort Method: quicksort Memory: 4250kB
8. 2.135 169.424 ↑ 12.8 24,757 1

Nested Loop (cost=1,000.29..22,965.69 rows=316,582 width=72) (actual time=6.146..169.424 rows=24,757 loops=1)

9. 0.000 60.101 ↓ 10.5 26,797 1

Gather (cost=1,000.00..19,249.61 rows=2,557 width=64) (actual time=6.051..60.101 rows=26,797 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
10. 0.667 140.844 ↓ 8.1 6,699 4

Parallel Append (cost=0.00..17,993.91 rows=825 width=64) (actual time=0.356..140.844 rows=6,699 loops=4)

11. 140.177 140.177 ↓ 8.1 6,699 4

Parallel Seq Scan on shift_occurrence_org_part_10 sho_1 (cost=0.00..17,989.78 rows=825 width=64) (actual time=0.354..140.177 rows=6,699 loops=4)

  • Filter: ((start_date < end_date) AND (organization_uuid = '9179fd37-1322-4957-8a99-7e2056388b4f'::uuid) AND (tstzrange((start_date)::timestamp with time zone, (end_date)::timestamp with time zone, '[)'::text) && '[""2019-10-27 00:00:00+00"",""2019-10-28 00:00:00+00"")'::tstzrange))
  • Rows Removed by Filter: 184422
12. 26.797 107.188 ↑ 1.0 1 26,797

Append (cost=0.29..1.13 rows=1 width=66) (actual time=0.003..0.004 rows=1 loops=26,797)

13. 80.391 80.391 ↑ 1.0 1 26,797

Index Scan using shifts_org_part_17_revision_uuid_uidx on shifts_org_part_17 sh_1 (cost=0.29..1.13 rows=1 width=66) (actual time=0.003..0.003 rows=1 loops=26,797)

  • Index Cond: (revision_uuid = sho_1.shift_revision_uuid)
  • Filter: (organization_uuid = '9179fd37-1322-4957-8a99-7e2056388b4f'::uuid)
14. 0.000 8,630.325 ↑ 1.0 1 23,775

Append (cost=0.42..3.16 rows=1 width=80) (actual time=0.362..0.363 rows=1 loops=23,775)

15. 8,630.325 8,630.325 ↑ 1.0 1 23,775

Index Scan using shift_occurrence_org_part_10_pkey on shift_occurrence_org_part_10 sho (cost=0.42..3.16 rows=1 width=80) (actual time=0.362..0.363 rows=1 loops=23,775)

  • Index Cond: ((organization_uuid = '9179fd37-1322-4957-8a99-7e2056388b4f'::uuid) AND (shift_occurrence_uuid = t.shift_occurrence_uuid))
16. 23.775 166.425 ↑ 1.0 1 23,775

Append (cost=0.29..0.32 rows=1 width=274) (actual time=0.006..0.007 rows=1 loops=23,775)

17. 142.650 142.650 ↑ 1.0 1 23,775

Index Scan using shifts_org_part_17_revision_uuid_uidx on shifts_org_part_17 sh (cost=0.29..0.31 rows=1 width=274) (actual time=0.006..0.006 rows=1 loops=23,775)

  • Index Cond: (revision_uuid = sho.shift_revision_uuid)
  • Filter: (organization_uuid = '9179fd37-1322-4957-8a99-7e2056388b4f'::uuid)
18.          

SubPlan (forNested Loop)

19. 71.325 1,022.325 ↑ 1.0 1 23,775

Limit (cost=2,401.18..2,401.18 rows=1 width=31) (actual time=0.040..0.043 rows=1 loops=23,775)

20. 142.650 951.000 ↑ 1,171.0 1 23,775

Sort (cost=2,401.18..2,404.11 rows=1,171 width=31) (actual time=0.040..0.040 rows=1 loops=23,775)

  • Sort Key: (lower(g.valid_range))
  • Sort Method: quicksort Memory: 25kB
21. 23.775 808.350 ↑ 1,171.0 1 23,775

Append (cost=0.28..2,395.33 rows=1,171 width=31) (actual time=0.032..0.034 rows=1 loops=23,775)

22. 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 (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)))
23. 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)))
24. 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..119.84 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)))
25. 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_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)))
26. 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_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)))
27. 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..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)))
28. 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_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)))
29. 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..740.96 rows=374 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_96_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_96 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)))
31. 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_9 (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)))
32. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_26_group_uuid_idx on groups_org_part_26 g_10 (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)))
33. 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_11 (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)))
34. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_86_group_uuid_idx on groups_org_part_86 g_12 (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)))
35. 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_13 (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)))
36. 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_14 (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)))
37. 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_15 (cost=0.56..131.90 rows=61 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_55_group_uuid_idx on groups_org_part_55 g_16 (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)))
39. 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_17 (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)))
40. 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_18 (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)))
41. 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_19 (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_46_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_46 g_20 (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)))
43. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_65_group_uuid_idx on groups_org_part_65 g_21 (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)))
44. 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_22 (cost=0.42..101.15 rows=47 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_71_group_uuid_idx on groups_org_part_71 g_23 (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)))
46. 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_24 (cost=0.28..11.59 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)))
47. 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_25 (cost=0.42..362.58 rows=166 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_73_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_73 g_26 (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)))
49. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_78_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_78 g_27 (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_19_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_19 g_28 (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)))
51. 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_29 (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)))
52. 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_30 (cost=0.42..24.71 rows=10 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_97_group_uuid_idx on groups_org_part_97 g_31 (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)))
54. 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_32 (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)))
55. 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_33 (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)))
56. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_63_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_63 g_34 (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)))
57. 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_35 (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)))
58. 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_36 (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)))
59. 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_37 (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)))
60. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_66_group_uuid_idx on groups_org_part_66 g_38 (cost=0.28..12.06 rows=37 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_89_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_89 g_39 (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_24_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_24 g_40 (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)))
63. 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_41 (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)))
64. 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_42 (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)))
65. 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_43 (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)))
66. 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_44 (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)))
67. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_93_group_uuid_idx on groups_org_part_93 g_45 (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_64_group_uuid_idx on groups_org_part_64 g_46 (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)))
69. 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_47 (cost=0.29..24.73 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)))
70. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_90_group_uuid_idx on groups_org_part_90 g_48 (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)))
71. 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_49 (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)))
72. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_81_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_81 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)))
73. 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_51 (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)))
74. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_76_group_uuid_idx on groups_org_part_76 g_52 (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. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_100_organization_uuid_group_uuid_sequence_l_idx on groups_org_part_100 g_53 (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)))
76. 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_54 (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)))
77. 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)))
78. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_59_group_uuid_idx on groups_org_part_59 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)))
79. 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_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)))
80. 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_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)))
81. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_84_group_uuid_idx on groups_org_part_84 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)))
82. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_91_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_91 g_60 (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)))
83. 784.575 784.575 ↑ 1.0 1 23,775

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=0.031..0.033 rows=1 loops=23,775)

  • 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
84. 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_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)))
85. 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)))
86. 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)))
87. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_88_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_88 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)))
88. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_95_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_95 g_66 (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)))
89. 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)))
90. 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_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)))
91. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_80_group_uuid_idx on groups_org_part_80 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)))
92. 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)))
93. 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_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)))
94. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_87_group_uuid_idx on groups_org_part_87 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)))
95. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_82_group_uuid_idx on groups_org_part_82 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)))
96. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_83_group_uuid_idx on groups_org_part_83 g_74 (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)))
97. 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_75 (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)))
98. 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)))
99. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_67_organization_uuid_group_uuid_sequence_lo_idx on groups_org_part_67 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)))
100. 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)))
101. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_56_group_uuid_idx on groups_org_part_56 g_79 (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)))
102. 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)))
103. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_99_group_uuid_idx on groups_org_part_99 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)))
104. 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_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)))
105. 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)))
106. 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_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)))
107. 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)))
108. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_74_group_uuid_idx on groups_org_part_74 g_86 (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)))
109. 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_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)))
110. 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)))
111. 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_89 (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)))
112. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_75_group_uuid_idx on groups_org_part_75 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)))
113. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_94_group_uuid_idx on groups_org_part_94 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)))
114. 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_92 (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)))
115. 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)))
116. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_77_group_uuid_idx on groups_org_part_77 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)))
117. 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)))
118. 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)))
119. 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..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)))
120. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_org_part_69_group_uuid_idx on groups_org_part_69 g_98 (cost=0.28..10.61 rows=28 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)))
121. 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)))
122. 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)))
Planning time : 920.501 ms
Execution time : 10,159.622 ms