explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U5Xk

Settings
# exclusive inclusive rows x rows loops node
1. 70,669.191 2,276,446.962 ↑ 1.0 1 1

Aggregate (cost=20,878,198,297.17..20,878,198,297.18 rows=1 width=8) (actual time=2,276,446.961..2,276,446.962 rows=1 loops=1)

2.          

Initplan (for Aggregate)

3. 0.001 0.024 ↓ 0.0 0 1

Append (cost=0.28..3.31 rows=1 width=0) (actual time=0.024..0.024 rows=0 loops=1)

4. 0.023 0.023 ↓ 0.0 0 1

Index Scan using person_roles_org_part_150_organization_uuid_person_uuid_seq_idx on person_roles_org_part_150 (cost=0.28..3.30 rows=1 width=0) (actual time=0.023..0.023 rows=0 loops=1)

  • Index Cond: ((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid))
  • Filter: (is_company_admin AND upper_inf(valid_range))
  • Rows Removed by Filter: 1
5. 1,696,625.149 2,205,777.747 ↑ 8.6 72,487,461 1

Nested Loop Left Join (cost=2.25..20,876,635,331.13 rows=625,185,092 width=16) (actual time=11.456..2,205,777.747 rows=72,487,461 loops=1)

  • Join Filter: (pr.roles @> ((('["'::text || (role.role_uuid)::text) || '"]'::text))::jsonb)
  • Rows Removed by Join Filter: 2,391,303,972
6. 0.000 364,222.784 ↑ 8.6 72,464,907 1

Nested Loop Left Join (cost=0.28..20,726,590,872.48 rows=625,185,092 width=64) (actual time=11.368..364,222.784 rows=72,464,907 loops=1)

7. 7,475.340 219,999.206 ↑ 1.4 72,464,907 1

Append (cost=0.00..20,694,882,041.67 rows=99,869,823 width=16) (actual time=11.335..219,999.206 rows=72,464,907 loops=1)

8. 0.000 318.298 ↑ 1.0 119,363 1

Seq Scan on persons_org_part_57 p (cost=0.00..36,739,701.80 rows=125,201 width=16) (actual time=11.333..318.298 rows=119,363 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 58,282
9.          

SubPlan (for Seq Scan)

10. 0.000 11,998.896 ↑ 1.0 1 3,216

Nested Loop (cost=0.81..202.93 rows=1 width=0) (actual time=3.731..3.731 rows=1 loops=3,216)

11. 189.744 283.008 ↓ 13.0 13 3,216

Nested Loop (cost=0.71..199.84 rows=1 width=16) (actual time=0.012..0.088 rows=13 loops=3,216)

  • Join Filter: (spr.roles @> ((('["'::text || (rr.source_role_uuid)::text) || '"]'::text))::jsonb)
  • Rows Removed by Join Filter: 50
12. 0.000 9.648 ↑ 1.0 1 3,216

Append (cost=0.28..3.31 rows=1 width=48) (actual time=0.003..0.003 rows=1 loops=3,216)

13. 9.648 9.648 ↑ 1.0 1 3,216

Index Scan using person_roles_org_part_150_organization_uuid_person_uuid_seq_idx on person_roles_org_part_150 spr (cost=0.28..3.30 rows=1 width=48) (actual time=0.003..0.003 rows=1 loops=3,216)

  • Index Cond: ((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid))
  • Filter: upper_inf(valid_range)
14. 83.616 83.616 ↓ 1.3 63 3,216

Index Scan using role_on_role_organization_uuid_idx on role_on_role rr (cost=0.42..195.18 rows=49 width=32) (actual time=0.005..0.026 rows=63 loops=3,216)

  • Index Cond: (organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid)
  • Filter: ((can_edit_person OR can_view_person OR can_use_person) AND upper_inf(valid_range))
  • Rows Removed by Filter: 3
15. 42.155 11,719.090 ↓ 0.0 0 42,155

Append (cost=0.10..3.09 rows=1 width=48) (actual time=0.278..0.278 rows=0 loops=42,155)

16. 10,496.595 11,676.935 ↓ 0.0 0 42,155

Bitmap Heap Scan on person_roles_org_part_150 tpr (cost=0.10..3.08 rows=1 width=48) (actual time=0.277..0.277 rows=0 loops=42,155)

  • Recheck Cond: (roles @> ((('["'::text || (rr.target_role_uuid)::text) || '"]'::text))::jsonb)
  • Filter: (upper_inf(valid_range) AND (organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (person_uuid = p.person_uuid))
  • Rows Removed by Filter: 237
  • Heap Blocks: exact=749,382
17. 1,180.340 1,180.340 ↓ 83.2 333 42,155

Bitmap Index Scan on person_roles_org_part_150_roles_idx (cost=0.00..0.10 rows=4 width=0) (actual time=0.028..0.028 rows=333 loops=42,155)

  • Index Cond: (roles @> ((('["'::text || (rr.target_role_uuid)::text) || '"]'::text))::jsonb)
18. 0.000 0.000 ↓ 0.0 0

Append (cost=0.28..3.31 rows=1 width=0) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Index Scan using person_roles_org_part_150_organization_uuid_person_uuid_seq_idx on person_roles_org_part_150 person_roles_org_part_150_1 (cost=0.28..3.30 rows=1 width=0) (never executed)

  • Index Cond: ((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (person_uuid = p.person_uuid))
  • Filter: (is_super_admin AND upper_inf(valid_range))
20. 0.001 0.448 ↓ 0.0 0 1

Append (cost=0.00..131.36 rows=1 width=16) (actual time=0.442..0.448 rows=0 loops=1)

21. 0.447 0.447 ↓ 0.0 0 1

Seq Scan on person_roles_org_part_150 person_roles_org_part_150_2 (cost=0.00..131.35 rows=1 width=16) (actual time=0.441..0.447 rows=0 loops=1)

  • Filter: (is_super_admin AND upper_inf(valid_range) AND (organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid))
  • Rows Removed by Filter: 3,736
22. 764.702 764.702 ↑ 1.4 366,145 1

Seq Scan on persons_org_part_32 p_1 (cost=0.00..102,987,627.99 rows=499,199 width=16) (actual time=0.043..764.702 rows=366,145 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 132,182
23. 452.682 452.682 ↑ 1.6 158,195 1

Seq Scan on persons_org_part_45 p_2 (cost=0.00..52,998,632.44 rows=256,882 width=16) (actual time=0.055..452.682 rows=158,195 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 98,687
24. 135.668 135.668 ↑ 1.7 49,801 1

Seq Scan on persons_org_part_86 p_3 (cost=0.00..17,273,501.80 rows=83,727 width=16) (actual time=0.050..135.668 rows=49,801 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 33,371
25. 223.513 223.513 ↑ 1.1 128,404 1

Seq Scan on persons_org_part_65 p_4 (cost=0.00..27,940,170.43 rows=135,431 width=16) (actual time=0.049..223.513 rows=128,404 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 6,996
26. 59.426 59.426 ↑ 1.3 32,450 1

Seq Scan on persons_org_part_119 p_5 (cost=0.00..8,640,990.91 rows=41,885 width=16) (actual time=0.049..59.426 rows=32,450 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 9,155
27. 45.832 45.832 ↑ 1.6 19,609 1

Seq Scan on persons_org_part_135 p_6 (cost=0.00..6,444,036.98 rows=31,235 width=16) (actual time=0.062..45.832 rows=19,609 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 11,626
28. 164.360 164.360 ↑ 1.5 66,850 1

Seq Scan on persons_org_part_77 p_7 (cost=0.00..21,224,797.21 rows=102,871 width=16) (actual time=0.054..164.360 rows=66,850 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 36,021
29. 849.145 849.145 ↑ 1.4 377,200 1

Seq Scan on persons_org_part_31 p_8 (cost=0.00..111,007,341.10 rows=538,075 width=16) (actual time=0.059..849.145 rows=377,200 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 152,293
30. 58.646 58.646 ↑ 2.5 16,077 1

Seq Scan on persons_org_part_122 p_9 (cost=0.00..8,231,576.24 rows=39,900 width=16) (actual time=0.064..58.646 rows=16,077 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 23,786
31. 355.476 355.476 ↑ 1.0 222,461 1

Seq Scan on persons_org_part_52 p_10 (cost=0.00..47,799,686.17 rows=231,694 width=16) (actual time=0.061..355.476 rows=222,461 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 8,746
32. 96.101 96.101 ↑ 1.7 37,805 1

Seq Scan on persons_org_part_95 p_11 (cost=0.00..13,532,206.91 rows=65,594 width=16) (actual time=0.063..96.101 rows=37,805 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 27,102
33. 74.516 74.516 ↑ 1.5 37,276 1

Seq Scan on persons_org_part_108 p_12 (cost=0.00..11,458,899.64 rows=55,544 width=16) (actual time=0.059..74.516 rows=37,276 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 17,788
34. 4,167.071 4,167.071 ↑ 1.4 1,658,153 1

Seq Scan on persons_org_part_11 p_13 (cost=0.00..473,102,186.04 rows=2,292,631 width=16) (actual time=0.059..4,167.071 rows=1,658,153 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 623,290
35. 238.156 238.156 ↑ 1.5 93,468 1

Seq Scan on persons_org_part_64 p_14 (cost=0.00..28,100,238.45 rows=136,179 width=16) (actual time=0.070..238.156 rows=93,468 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 42,711
36. 197.439 197.439 ↑ 1.2 107,636 1

Seq Scan on persons_org_part_68 p_15 (cost=0.00..26,937,976.97 rows=130,573 width=16) (actual time=0.062..197.439 rows=107,636 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 21,814
37. 3.952 3.952 ↑ 1.2 2,088 1

Seq Scan on persons_org_part_40 p_16 (cost=0.00..500,917.46 rows=2,428 width=16) (actual time=0.357..3.952 rows=2,088 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 302
38. 163.179 163.179 ↑ 1.7 58,968 1

Seq Scan on persons_org_part_78 p_17 (cost=0.00..20,953,754.59 rows=101,559 width=16) (actual time=0.060..163.179 rows=58,968 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 42,591
39. 155.902 155.902 ↑ 1.1 117,410 1

Seq Scan on persons_org_part_69 p_18 (cost=0.00..25,703,271.30 rows=124,587 width=16) (actual time=0.099..155.902 rows=117,410 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 7,190
40. 93.794 93.794 ↑ 1.4 45,733 1

Seq Scan on persons_org_part_102 p_19 (cost=0.00..12,991,294.96 rows=62,971 width=16) (actual time=0.099..93.794 rows=45,733 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 15,263
41. 717.073 717.073 ↑ 1.7 287,769 1

Seq Scan on persons_org_part_33 p_20 (cost=0.00..99,051,741.43 rows=480,126 width=16) (actual time=0.053..717.073 rows=287,769 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 192,357
42. 57.781 57.781 ↑ 1.6 24,934 1

Seq Scan on persons_org_part_121 p_21 (cost=0.00..8,085,590.41 rows=39,192 width=16) (actual time=0.117..57.781 rows=24,934 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 13,910
43. 119.190 119.190 ↑ 1.5 55,836 1

Seq Scan on persons_org_part_84 p_22 (cost=0.00..17,258,766.97 rows=83,656 width=16) (actual time=0.082..119.190 rows=55,836 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 27,731
44. 292.423 292.423 ↑ 1.4 135,094 1

Seq Scan on persons_org_part_55 p_23 (cost=0.00..38,800,565.17 rows=188,073 width=16) (actual time=0.087..292.423 rows=135,094 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 53,000
45. 1,172.027 1,172.027 ↑ 1.5 494,138 1

Seq Scan on persons_org_part_25 p_24 (cost=0.00..153,447,415.98 rows=743,765 width=16) (actual time=0.101..1,172.027 rows=494,138 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 246,218
46. 47.121 47.121 ↑ 1.6 19,159 1

Seq Scan on persons_org_part_136 p_25 (cost=0.00..6,322,317.84 rows=30,644 width=16) (actual time=0.104..47.121 rows=19,159 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 11,485
47. 48.206 48.206 ↑ 1.7 19,534 1

Seq Scan on persons_org_part_130 p_26 (cost=0.00..6,899,061.41 rows=33,441 width=16) (actual time=0.057..48.206 rows=19,534 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 13,615
48. 330.995 330.995 ↑ 1.2 188,625 1

Seq Scan on persons_org_part_49 p_27 (cost=0.00..48,463,563.09 rows=234,911 width=16) (actual time=0.059..330.995 rows=188,625 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 46,964
49. 39.142 39.142 ↑ 1.9 13,261 1

Seq Scan on persons_org_part_146 p_28 (cost=0.00..5,178,405.96 rows=25,101 width=16) (actual time=0.057..39.142 rows=13,261 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 11,595
50. 89.299 89.299 ↑ 1.2 44,958 1

Seq Scan on persons_org_part_112 p_29 (cost=0.00..10,962,261.10 rows=53,130 width=16) (actual time=0.062..89.299 rows=44,958 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 8,190
51. 64.673 64.673 ↑ 1.2 35,722 1

Seq Scan on persons_org_part_118 p_30 (cost=0.00..8,923,323.17 rows=43,253 width=16) (actual time=0.059..64.673 rows=35,722 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 7,507
52. 42.726 42.726 ↑ 1.4 18,663 1

Seq Scan on persons_org_part_144 p_31 (cost=0.00..5,546,385.19 rows=26,884 width=16) (actual time=0.086..42.726 rows=18,663 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 8,196
53. 418.397 418.397 ↑ 1.6 170,564 1

Seq Scan on persons_org_part_44 p_32 (cost=0.00..54,571,755.30 rows=264,497 width=16) (actual time=0.088..418.397 rows=170,564 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 93,933
54. 33.120 33.120 ↑ 1.5 14,655 1

Seq Scan on persons_org_part_157 p_33 (cost=0.00..4,640,789.77 rows=22,495 width=16) (actual time=0.175..33.120 rows=14,655 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 7,614
55. 53.631 53.631 ↑ 1.5 22,569 1

Seq Scan on persons_org_part_131 p_34 (cost=0.00..6,926,839.85 rows=33,575 width=16) (actual time=0.049..53.631 rows=22,569 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 10,505
56. 38.962 38.962 ↑ 1.7 13,816 1

Seq Scan on persons_org_part_153 p_35 (cost=0.00..4,801,611.45 rows=23,274 width=16) (actual time=0.086..38.962 rows=13,816 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 9,206
57. 156.280 156.280 ↑ 4.7 17,335 1

Seq Scan on persons_org_part_87 p_36 (cost=0.00..16,929,466.72 rows=82,059 width=16) (actual time=0.062..156.280 rows=17,335 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 64,686
58. 174.352 174.352 ↑ 1.5 80,093 1

Seq Scan on persons_org_part_70 p_37 (cost=0.00..24,389,370.17 rows=118,220 width=16) (actual time=0.072..174.352 rows=80,093 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 37,936
59. 172.878 172.878 ↑ 1.6 68,829 1

Seq Scan on persons_org_part_76 p_38 (cost=0.00..22,775,657.75 rows=110,399 width=16) (actual time=0.092..172.878 rows=68,829 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 40,412
60. 54.276 54.276 ↑ 1.6 22,443 1

Seq Scan on persons_org_part_126 p_39 (cost=0.00..7,195,715.67 rows=34,877 width=16) (actual time=0.115..54.276 rows=22,443 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 12,386
61. 645.923 645.923 ↑ 1.1 354,314 1

Seq Scan on persons_org_part_35 p_40 (cost=0.00..80,504,297.35 rows=390,214 width=16) (actual time=0.053..645.923 rows=354,314 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 35,878
62. 7,152.957 7,152.957 ↓ 1.0 4,121,233 1

Seq Scan on persons_org_part_4 p_41 (cost=0.00..831,495,146.81 rows=4,029,937 width=16) (actual time=0.386..7,152.957 rows=4,121,233 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 28,665
63. 202.286 202.286 ↑ 1.6 90,051 1

Seq Scan on persons_org_part_63 p_42 (cost=0.00..29,381,676.65 rows=142,421 width=16) (actual time=0.062..202.286 rows=90,051 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 51,806
64. 42.417 42.417 ↑ 1.6 17,504 1

Seq Scan on persons_org_part_142 p_43 (cost=0.00..5,864,814.63 rows=28,428 width=16) (actual time=0.061..42.417 rows=17,504 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 10,740
65. 81.009 81.009 ↑ 1.5 36,507 1

Seq Scan on persons_org_part_113 p_44 (cost=0.00..11,027,187.79 rows=53,451 width=16) (actual time=0.059..81.009 rows=36,507 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 16,393
66. 67.715 67.715 ↑ 1.4 34,866 1

Seq Scan on persons_org_part_114 p_45 (cost=0.00..9,739,462.59 rows=47,209 width=16) (actual time=0.060..67.715 rows=34,866 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 11,929
67. 49.426 49.426 ↑ 13.8 1,988 1

Seq Scan on persons_org_part_143 p_46 (cost=0.00..5,672,775.48 rows=27,497 width=16) (actual time=0.057..49.426 rows=1,988 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 25,481
68. 34.422 34.422 ↑ 2.0 11,858 1

Seq Scan on persons_org_part_155 p_47 (cost=0.00..4,831,601.24 rows=23,420 width=16) (actual time=0.080..34.422 rows=11,858 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 11,204
69. 32,081.468 32,081.468 ↑ 1.5 11,354,292 1

Seq Scan on persons_org_part_1 p_48 (cost=0.00..3,557,607,637.72 rows=17,242,569 width=16) (actual time=0.053..32,081.468 rows=11,354,292 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 5,893,439
70. 50.328 50.328 ↑ 1.4 17,282 1

Seq Scan on persons_org_part_149 p_49 (cost=0.00..4,988,645.05 rows=24,178 width=16) (actual time=0.099..50.328 rows=17,282 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 6,900
71. 109.567 109.567 ↑ 1.2 18,666 1

Seq Scan on persons_org_part_156 p_50 (cost=0.00..4,706,360.35 rows=22,812 width=16) (actual time=0.037..109.567 rows=18,666 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 3,958
72. 100.171 100.171 ↑ 1.6 33,308 1

Seq Scan on persons_org_part_111 p_51 (cost=0.00..11,044,722.99 rows=53,534 width=16) (actual time=0.056..100.171 rows=33,308 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 20,201
73. 38.532 38.532 ↑ 1.6 15,491 1

Seq Scan on persons_org_part_150 p_52 (cost=0.00..4,965,487.59 rows=24,069 width=16) (actual time=0.049..38.532 rows=15,491 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 8,373
74. 490.104 490.104 ↑ 1.5 94,230 1

Seq Scan on persons_org_part_71 p_53 (cost=0.00..29,290,152.74 rows=141,974 width=16) (actual time=0.050..490.104 rows=94,230 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 46,775
75. 43.698 43.698 ↑ 1.4 16,937 1

Seq Scan on persons_org_part_148 p_54 (cost=0.00..5,051,910.11 rows=24,486 width=16) (actual time=0.161..43.698 rows=16,937 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 7,338
76. 1,208.254 1,208.254 ↑ 1.5 402,001 1

Seq Scan on persons_org_part_30 p_55 (cost=0.00..122,446,012.78 rows=593,476 width=16) (actual time=0.050..1,208.254 rows=402,001 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 197,769
77. 861.998 861.998 ↓ 1.0 349,546 1

Seq Scan on persons_org_part_41 p_56 (cost=0.00..72,001,584.46 rows=349,009 width=16) (actual time=0.060..861.998 rows=349,546 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 75
78. 3,807.158 3,807.158 ↑ 1.5 1,442,376 1

Seq Scan on persons_org_part_13 p_57 (cost=0.00..448,263,053.73 rows=2,172,682 width=16) (actual time=0.075..3,807.158 rows=1,442,376 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 730,381
79. 206.375 206.375 ↑ 1.6 73,428 1

Seq Scan on persons_org_part_72 p_58 (cost=0.00..23,530,875.67 rows=114,049 width=16) (actual time=0.086..206.375 rows=73,428 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 40,621
80. 12,077.009 12,077.009 ↑ 1.7 17,222 1

Seq Scan on persons_org_part_139 p_59 (cost=0.00..6,135,026.68 rows=29,738 width=16) (actual time=0.055..12,077.009 rows=17,222 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 12,319
81. 128.946 128.946 ↑ 1.6 52,975 1

Seq Scan on persons_org_part_91 p_60 (cost=0.00..17,049,874.46 rows=82,645 width=16) (actual time=0.191..128.946 rows=52,975 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 28,660
82. 857.616 857.616 ↑ 1.6 240,488 1

Seq Scan on persons_org_part_39 p_61 (cost=0.00..80,849,569.56 rows=391,886 width=16) (actual time=0.040..857.616 rows=240,488 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 147,017
83. 157.902 157.902 ↑ 1.5 36,573 1

Seq Scan on persons_org_part_107 p_62 (cost=0.00..11,542,445.81 rows=55,949 width=16) (actual time=0.060..157.902 rows=36,573 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 18,748
84. 303.164 303.164 ↑ 1.7 101,910 1

Seq Scan on persons_org_part_58 p_63 (cost=0.00..35,171,023.33 rows=170,477 width=16) (actual time=0.096..303.164 rows=101,910 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 67,357
85. 114.088 114.088 ↑ 1.5 41,564 1

Seq Scan on persons_org_part_101 p_64 (cost=0.00..12,722,693.15 rows=61,669 width=16) (actual time=0.060..114.088 rows=41,564 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 19,567
86. 693.742 693.742 ↑ 1.2 316,017 1

Seq Scan on persons_org_part_36 p_65 (cost=0.00..80,947,091.66 rows=392,348 width=16) (actual time=0.042..693.742 rows=316,017 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 78,168
87. 432.253 432.253 ↑ 1.6 134,846 1

Seq Scan on persons_org_part_53 p_66 (cost=0.00..45,137,911.53 rows=218,794 width=16) (actual time=31.746..432.253 rows=134,846 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 84,683
88. 92.334 92.334 ↑ 2.6 17,047 1

Seq Scan on persons_org_part_115 p_67 (cost=0.00..9,236,626.34 rows=44,771 width=16) (actual time=0.068..92.334 rows=17,047 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 27,724
89. 59.917 59.917 ↑ 1.5 23,014 1

Seq Scan on persons_org_part_128 p_68 (cost=0.00..7,157,426.25 rows=34,693 width=16) (actual time=0.055..59.917 rows=23,014 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 11,663
90. 148.059 148.059 ↑ 1.1 58,699 1

Seq Scan on persons_org_part_97 p_69 (cost=0.00..12,821,958.20 rows=62,138 width=16) (actual time=0.050..148.059 rows=58,699 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 3,442
91. 4,458.275 4,458.275 ↑ 1.5 1,429,996 1

Seq Scan on persons_org_part_12 p_70 (cost=0.00..446,704,610.02 rows=2,165,021 width=16) (actual time=0.044..4,458.275 rows=1,429,996 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 733,367
92. 2,280.531 2,280.531 ↑ 1.5 568,016 1

Seq Scan on persons_org_part_24 p_71 (cost=0.00..170,373,740.55 rows=825,666 width=16) (actual time=0.086..2,280.531 rows=568,016 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 252,117
93. 3,270.891 3,270.891 ↑ 1.6 940,725 1

Seq Scan on persons_org_part_20 p_72 (cost=0.00..300,961,388.49 rows=1,458,691 width=16) (actual time=0.042..3,270.891 rows=940,725 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 451,000
94. 120.014 120.014 ↑ 8,204.6 8 1

Seq Scan on persons_org_part_94 p_73 (cost=0.00..13,541,197.92 rows=65,637 width=16) (actual time=0.091..120.014 rows=8 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 65,629
95. 402.875 402.875 ↑ 1.5 125,122 1

Seq Scan on persons_org_part_56 p_74 (cost=0.00..39,657,795.48 rows=192,229 width=16) (actual time=0.058..402.875 rows=125,122 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 68,491
96. 1,389.259 1,389.259 ↑ 1.0 1,033,003 1

Seq Scan on persons_org_part_22 p_75 (cost=0.00..215,188,547.56 rows=1,043,041 width=16) (actual time=0.051..1,389.259 rows=1,033,003 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 10,025
97. 168.955 168.955 ↑ 1.7 32,747 1

Seq Scan on persons_org_part_105 p_76 (cost=0.00..11,670,814.61 rows=56,571 width=16) (actual time=0.040..168.955 rows=32,747 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 23,414
98. 96.080 96.080 ↑ 1.6 38,725 1

Seq Scan on persons_org_part_100 p_77 (cost=0.00..12,666,652.42 rows=61,398 width=16) (actual time=0.052..96.080 rows=38,725 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 22,297
99. 57.108 57.108 ↑ 3.3 9,868 1

Seq Scan on persons_org_part_132 p_78 (cost=0.00..6,722,831.77 rows=32,587 width=16) (actual time=0.072..57.108 rows=9,868 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 22,596
100. 40.579 40.579 ↑ 1.8 13,803 1

Seq Scan on persons_org_part_151 p_79 (cost=0.00..5,044,608.61 rows=24,452 width=16) (actual time=0.034..40.579 rows=13,803 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 10,145
101. 37.187 37.187 ↑ 1.5 14,984 1

Seq Scan on persons_org_part_152 p_80 (cost=0.00..4,645,973.76 rows=22,520 width=16) (actual time=0.038..37.187 rows=14,984 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 7,539
102. 90.432 90.432 ↑ 1.5 37,283 1

Seq Scan on persons_org_part_110 p_81 (cost=0.00..11,309,937.89 rows=54,822 width=16) (actual time=0.045..90.432 rows=37,283 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 17,245
103. 65.746 65.746 ↑ 1.5 27,091 1

Seq Scan on persons_org_part_120 p_82 (cost=0.00..8,432,222.13 rows=40,873 width=16) (actual time=0.058..65.746 rows=27,091 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 13,572
104. 382.592 382.592 ↑ 1.5 147,447 1

Seq Scan on persons_org_part_51 p_83 (cost=0.00..46,874,859.21 rows=227,210 width=16) (actual time=0.121..382.592 rows=147,447 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 81,056
105. 163.234 163.234 ↑ 1.5 30,922 1

Seq Scan on persons_org_part_116 p_84 (cost=0.00..9,510,338.43 rows=46,099 width=16) (actual time=0.046..163.234 rows=30,922 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 14,626
106. 190.719 190.719 ↑ 1.5 56,291 1

Seq Scan on persons_org_part_90 p_85 (cost=0.00..17,605,077.13 rows=85,335 width=16) (actual time=0.041..190.719 rows=56,291 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 28,728
107. 7,778.026 7,778.026 ↑ 1.4 2,699,228 1

Seq Scan on persons_org_part_9 p_86 (cost=0.00..794,908,275.27 rows=3,852,971 width=16) (actual time=0.071..7,778.026 rows=2,699,228 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 1,292,499
108. 53.371 53.371 ↑ 1.5 22,792 1

Seq Scan on persons_org_part_129 p_87 (cost=0.00..6,969,719.25 rows=33,784 width=16) (actual time=0.054..53.371 rows=22,792 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 10,736
109. 133.141 133.141 ↑ 1.6 35,246 1

Seq Scan on persons_org_part_109 p_88 (cost=0.00..11,462,802.95 rows=55,563 width=16) (actual time=0.082..133.141 rows=35,246 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 19,784
110. 108.644 108.644 ↑ 1.6 18,718 1

Seq Scan on persons_org_part_140 p_89 (cost=0.00..6,070,868.78 rows=29,427 width=16) (actual time=62.014..108.644 rows=18,718 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 10,383
111. 5,026.831 5,026.831 ↑ 1.5 1,622,466 1

Seq Scan on persons_org_part_10 p_90 (cost=0.00..490,173,547.02 rows=2,375,557 width=16) (actual time=0.045..5,026.831 rows=1,622,466 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 782,066
112. 174.343 174.343 ↑ 1.4 63,307 1

Seq Scan on persons_org_part_81 p_91 (cost=0.00..18,332,728.40 rows=88,861 width=16) (actual time=0.044..174.343 rows=63,307 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 25,025
113. 152.548 152.548 ↑ 1.0 111,919 1

Seq Scan on persons_org_part_74 p_92 (cost=0.00..23,125,474.83 rows=112,092 width=16) (actual time=0.041..152.548 rows=111,919 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 173
114. 140.473 140.473 ↑ 1.7 49,423 1

Seq Scan on persons_org_part_83 p_93 (cost=0.00..17,625,745.07 rows=85,435 width=16) (actual time=0.132..140.473 rows=49,423 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 36,012
115. 96.853 96.853 ↑ 1.7 20,917 1

Seq Scan on persons_org_part_127 p_94 (cost=0.00..7,235,717.16 rows=35,072 width=16) (actual time=0.062..96.853 rows=20,917 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 14,007
116. 91.988 91.988 ↑ 1.5 30,584 1

Seq Scan on persons_org_part_117 p_95 (cost=0.00..9,356,442.18 rows=45,343 width=16) (actual time=0.066..91.988 rows=30,584 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 14,235
117. 3,710.234 3,710.234 ↑ 1.4 1,140,023 1

Seq Scan on persons_org_part_16 p_96 (cost=0.00..324,396,060.53 rows=1,572,022 width=16) (actual time=0.110..3,710.234 rows=1,140,023 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 430,281
118. 50.600 50.600 ↑ 1.6 18,104 1

Seq Scan on persons_org_part_141 p_97 (cost=0.00..5,946,954.84 rows=28,826 width=16) (actual time=0.082..50.600 rows=18,104 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 10,467
119. 397.326 397.326 ↑ 1.5 156,631 1

Seq Scan on persons_org_part_50 p_98 (cost=0.00..48,515,283.79 rows=235,164 width=16) (actual time=0.039..397.326 rows=156,631 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 80,106
120. 17,180.435 17,180.435 ↑ 1.0 3,449,605 1

Seq Scan on persons_org_part_7 p_99 (cost=0.00..714,733,568.76 rows=3,464,009 width=16) (actual time=0.084..17,180.435 rows=3,449,605 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 131,557
121. 119.746 119.746 ↑ 1.8 34,177 1

Seq Scan on persons_org_part_96 p_100 (cost=0.00..12,870,027.38 rows=62,382 width=16) (actual time=0.056..119.746 rows=34,177 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 28,209
122. 149.583 149.583 ↑ 1.7 48,930 1

Seq Scan on persons_org_part_85 p_101 (cost=0.00..17,137,017.10 rows=83,066 width=16) (actual time=0.060..149.583 rows=48,930 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 34,107
123. 438.157 438.157 ↑ 1.5 163,388 1

Seq Scan on persons_org_part_47 p_102 (cost=0.00..51,030,201.04 rows=247,354 width=16) (actual time=0.036..438.157 rows=163,388 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 85,399
124. 61.300 61.300 ↑ 1.5 22,020 1

Seq Scan on persons_org_part_133 p_103 (cost=0.00..6,596,587.48 rows=31,974 width=16) (actual time=0.065..61.300 rows=22,020 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 9,960
125. 7,740.439 7,740.439 ↑ 1.5 2,166,958 1

Seq Scan on persons_org_part_8 p_104 (cost=0.00..686,046,679.36 rows=3,324,935 width=16) (actual time=0.043..7,740.439 rows=2,166,958 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 1,251,746
126. 403.113 403.113 ↑ 1.4 161,063 1

Seq Scan on persons_org_part_54 p_105 (cost=0.00..45,902,775.09 rows=222,500 width=16) (actual time=0.090..403.113 rows=161,063 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 61,447
127. 123.911 123.911 ↑ 1.6 40,035 1

Seq Scan on persons_org_part_98 p_106 (cost=0.00..12,907,356.12 rows=62,560 width=16) (actual time=0.052..123.911 rows=40,035 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 22,083
128. 1,094.489 1,094.489 ↑ 1.5 287,177 1

Seq Scan on persons_org_part_34 p_107 (cost=0.00..88,424,694.78 rows=428,608 width=16) (actual time=0.041..1,094.489 rows=287,177 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 137,037
129. 49.511 49.511 ↑ 1.4 17,769 1

Seq Scan on persons_org_part_147 p_108 (cost=0.00..5,131,649.53 rows=24,874 width=16) (actual time=0.073..49.511 rows=17,769 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 6,904
130. 1,507.434 1,507.434 ↑ 1.0 735,540 1

Seq Scan on persons_org_part_26 p_109 (cost=0.00..155,246,659.15 rows=752,512 width=16) (actual time=0.076..1,507.434 rows=735,540 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 2,877
131. 516.199 516.199 ↑ 1.6 159,557 1

Seq Scan on persons_org_part_46 p_110 (cost=0.00..51,608,528.81 rows=250,141 width=16) (actual time=0.061..516.199 rows=159,557 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 90,584
132. 229.982 229.982 ↑ 1.6 58,553 1

Seq Scan on persons_org_part_79 p_111 (cost=0.00..19,632,457.36 rows=95,163 width=16) (actual time=0.118..229.982 rows=58,553 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 35,383
133. 768.371 768.371 ↑ 1.5 258,993 1

Seq Scan on persons_org_part_37 p_112 (cost=0.00..80,284,266.17 rows=389,129 width=16) (actual time=0.065..768.371 rows=258,993 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 132,107
134. 169.571 169.571 ↑ 1.5 58,662 1

Seq Scan on persons_org_part_80 p_113 (cost=0.00..18,455,288.22 rows=89,458 width=16) (actual time=0.139..169.571 rows=58,662 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 30,457
135. 10,285.038 10,285.038 ↑ 1.4 2,775,033 1

Seq Scan on persons_org_part_5 p_114 (cost=0.00..806,223,237.13 rows=3,906,934 width=16) (actual time=0.043..10,285.038 rows=2,775,033 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 1,128,979
136. 36.876 36.876 ↑ 1.6 14,118 1

Seq Scan on persons_org_part_154 p_115 (cost=0.00..4,720,481.63 rows=22,881 width=16) (actual time=0.058..36.876 rows=14,118 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 8,623
137. 219.957 219.957 ↑ 1.1 158,773 1

Seq Scan on persons_org_part_59 p_116 (cost=0.00..34,603,751.73 rows=167,730 width=16) (actual time=0.044..219.957 rows=158,773 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 5,947
138. 314.638 314.638 ↑ 1.5 110,297 1

Seq Scan on persons_org_part_61 p_117 (cost=0.00..35,090,648.79 rows=170,085 width=16) (actual time=0.058..314.638 rows=110,297 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 54,605
139. 459.180 459.180 ↑ 1.5 160,119 1

Seq Scan on persons_org_part_48 p_118 (cost=0.00..49,774,086.56 rows=241,247 width=16) (actual time=0.108..459.180 rows=160,119 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 81,130
140. 3,509.021 3,509.021 ↑ 1.4 1,445,478 1

Seq Scan on persons_org_part_14 p_119 (cost=0.00..416,782,086.61 rows=2,020,085 width=16) (actual time=0.044..3,509.021 rows=1,445,478 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 574,447
141. 36.488 36.488 ↑ 1.2 25,316 1

Seq Scan on persons_org_part_138 p_120 (cost=0.00..6,037,909.07 rows=29,267 width=16) (actual time=0.035..36.488 rows=25,316 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 3,951
142. 125.924 125.924 ↑ 1.5 54,287 1

Seq Scan on persons_org_part_89 p_121 (cost=0.00..17,316,196.21 rows=83,936 width=16) (actual time=0.127..125.924 rows=54,287 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 28,672
143. 97.826 97.826 ↑ 1.0 55,615 1

Seq Scan on persons_org_part_106 p_122 (cost=0.00..11,545,411.44 rows=55,962 width=16) (actual time=0.037..97.826 rows=55,615 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 28
144. 188.447 188.447 ↑ 1.5 73,501 1

Seq Scan on persons_org_part_73 p_123 (cost=0.00..23,132,849.65 rows=112,120 width=16) (actual time=0.046..188.447 rows=73,501 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 38,619
145. 1,383.621 1,383.621 ↑ 1.6 448,473 1

Seq Scan on persons_org_part_28 p_124 (cost=0.00..143,900,769.78 rows=697,402 width=16) (actual time=0.089..1,383.621 rows=448,473 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 244,140
146. 102.748 102.748 ↑ 1.5 43,641 1

Seq Scan on persons_org_part_99 p_125 (cost=0.00..13,121,414.00 rows=63,601 width=16) (actual time=0.059..102.748 rows=43,641 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 18,836
147. 647.714 647.714 ↑ 1.5 234,711 1

Seq Scan on persons_org_part_38 p_126 (cost=0.00..73,071,442.64 rows=354,163 width=16) (actual time=0.038..647.714 rows=234,711 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 119,452
148. 58.112 58.112 ↑ 1.4 26,826 1

Seq Scan on persons_org_part_123 p_127 (cost=0.00..8,019,437.99 rows=38,872 width=16) (actual time=0.579..58.112 rows=26,826 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 11,681
149. 3,463.069 3,463.069 ↑ 1.5 1,127,990 1

Seq Scan on persons_org_part_18 p_128 (cost=0.00..353,499,006.52 rows=1,713,206 width=16) (actual time=0.117..3,463.069 rows=1,127,990 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 562,189
150. 1,070.468 1,070.468 ↑ 1.5 466,138 1

Seq Scan on persons_org_part_29 p_129 (cost=0.00..145,331,840.16 rows=704,457 width=16) (actual time=0.067..1,070.468 rows=466,138 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 235,519
151. 97.612 97.612 ↑ 1.6 36,252 1

Seq Scan on persons_org_part_104 p_130 (cost=0.00..11,759,107.09 rows=56,995 width=16) (actual time=0.072..97.612 rows=36,252 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 20,792
152. 9,142.669 9,142.669 ↑ 1.0 4,548,483 1

Seq Scan on persons_org_part_3 p_131 (cost=0.00..960,669,800.38 rows=4,656,043 width=16) (actual time=0.095..9,142.669 rows=4,548,483 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 126,942
153. 50.999 50.999 ↑ 1.5 21,404 1

Seq Scan on persons_org_part_134 p_132 (cost=0.00..6,681,107.33 rows=32,385 width=16) (actual time=0.057..50.999 rows=21,404 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 10,718
154. 1,400.501 1,400.501 ↑ 1.6 578,580 1

Seq Scan on persons_org_part_23 p_133 (cost=0.00..193,065,654.24 rows=935,825 width=16) (actual time=0.054..1,400.501 rows=578,580 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 348,941
155. 417.049 417.049 ↑ 1.5 182,570 1

Seq Scan on persons_org_part_43 p_134 (cost=0.00..57,467,894.92 rows=278,560 width=16) (actual time=0.030..417.049 rows=182,570 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 97,004
156. 54.462 54.462 ↑ 1.7 20,940 1

Seq Scan on persons_org_part_125 p_135 (cost=0.00..7,557,685.63 rows=36,634 width=16) (actual time=0.080..54.462 rows=20,940 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 15,357
157. 249.355 249.355 ↑ 1.5 89,985 1

Seq Scan on persons_org_part_67 p_136 (cost=0.00..27,425,545.32 rows=132,904 width=16) (actual time=0.034..249.355 rows=89,985 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 42,026
158. 136.765 136.765 ↑ 1.6 56,752 1

Seq Scan on persons_org_part_82 p_137 (cost=0.00..19,003,306.10 rows=92,113 width=16) (actual time=0.178..136.765 rows=56,752 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 32,454
159. 202.232 202.232 ↑ 13,552.6 8 1

Seq Scan on persons_org_part_75 p_138 (cost=0.00..22,367,654.04 rows=108,421 width=16) (actual time=66.536..202.232 rows=8 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 108,413
160. 1,233.289 1,233.289 ↑ 1.0 735,666 1

Seq Scan on persons_org_part_27 p_139 (cost=0.00..154,517,357.28 rows=748,923 width=16) (actual time=0.057..1,233.289 rows=735,666 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 4,779
161. 191.825 191.825 ↑ 1.5 59,391 1

Seq Scan on persons_org_part_88 p_140 (cost=0.00..18,023,101.03 rows=87,328 width=16) (actual time=0.053..191.825 rows=59,391 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 29,765
162. 251.482 251.482 ↑ 1.6 106,182 1

Seq Scan on persons_org_part_60 p_141 (cost=0.00..34,249,419.95 rows=166,013 width=16) (actual time=0.078..251.482 rows=106,182 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 58,230
163. 97.686 97.686 ↑ 1.3 51,391 1

Seq Scan on persons_org_part_93 p_142 (cost=0.00..13,659,725.76 rows=66,209 width=16) (actual time=0.096..97.686 rows=51,391 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 14,696
164. 112.280 112.280 ↑ 1.4 56,863 1

Seq Scan on persons_org_part_92 p_143 (cost=0.00..15,907,858.26 rows=77,108 width=16) (actual time=0.173..112.280 rows=56,863 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 20,245
165. 580.866 580.866 ↑ 1.0 282,479 1

Seq Scan on persons_org_part_42 p_144 (cost=0.00..58,557,855.67 rows=283,759 width=16) (actual time=0.607..580.866 rows=282,479 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 2,400
166. 39.571 39.571 ↑ 1.4 21,829 1

Seq Scan on persons_org_part_137 p_145 (cost=0.00..6,245,884.73 rows=30,275 width=16) (actual time=0.054..39.571 rows=21,829 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 8,430
167. 52.161 52.161 ↑ 1.5 25,025 1

Seq Scan on persons_org_part_124 p_146 (cost=0.00..7,772,388.23 rows=37,674 width=16) (actual time=0.084..52.161 rows=25,025 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 11,967
168. 2,322.162 2,322.162 ↑ 1.7 808,732 1

Seq Scan on persons_org_part_19 p_147 (cost=0.00..279,097,489.47 rows=1,352,836 width=16) (actual time=0.155..2,322.162 rows=808,732 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 533,870
169. 48.838 48.838 ↑ 1.0 26,304 1

Seq Scan on persons_org_part_145 p_148 (cost=0.00..5,486,477.87 rows=26,593 width=16) (actual time=0.066..48.838 rows=26,304 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 16
170. 1,707.490 1,707.490 ↑ 1.5 703,192 1

Seq Scan on persons_org_part_21 p_149 (cost=0.00..222,421,707.91 rows=1,078,128 width=16) (actual time=0.072..1,707.490 rows=703,192 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 371,299
171. 7,023.043 7,023.043 ↑ 1.5 2,562,276 1

Seq Scan on persons_org_part_6 p_150 (cost=0.00..772,500,821.53 rows=3,743,320 width=16) (actual time=0.083..7,023.043 rows=2,562,276 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 1,212,843
172. 114.144 114.144 ↑ 1.5 38,375 1

Seq Scan on persons_org_part_103 p_151 (cost=0.00..11,954,428.96 rows=57,925 width=16) (actual time=0.082..114.144 rows=38,375 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 19,550
173. 157.669 157.669 ↑ 1.0 147,597 1

Seq Scan on persons_org_part_62 p_152 (cost=0.00..31,820,252.23 rows=154,240 width=16) (actual time=0.073..157.669 rows=147,597 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 3,846
174. 18,901.694 18,901.694 ↑ 1.5 8,141,735 1

Seq Scan on persons_org_part_2 p_153 (cost=0.00..2,510,221,832.93 rows=12,167,224 width=16) (actual time=0.087..18,901.694 rows=8,141,735 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 3,910,377
175. 172.677 172.677 ↑ 1.5 66,869 1

Seq Scan on persons_org_part_15 p_154 (cost=0.00..20,958,206.70 rows=101,588 width=16) (actual time=0.085..172.677 rows=66,869 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 34,309
176. 2,553.287 2,553.287 ↑ 1.6 1,025,672 1

Seq Scan on persons_org_part_17 p_155 (cost=0.00..334,379,271.83 rows=1,620,801 width=16) (actual time=0.072..2,553.287 rows=1,025,672 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 587,320
177. 260.209 260.209 ↑ 1.0 132,318 1

Seq Scan on persons_org_part_66 p_156 (cost=0.00..27,520,120.72 rows=133,385 width=16) (actual time=0.159..260.209 rows=132,318 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 1,067
178. 6,192.378 6,192.378 ↑ 1.3 1,570,583 1

Seq Scan on persons_org_part_default p_157 (cost=0.00..482,957,727.68 rows=1,963,471 width=16) (actual time=0.101..6,192.378 rows=1,570,583 loops=1)

  • Filter: (((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (valid_range @> '2019-09-25 14:55:57+00'::timestamp with time zone) AND (is_visible IS TRUE) AND ((person_uuid = 'f2bfc36c-1144-4477-93c1-26390205966e'::uuid) OR $0 OR (SubPlan 2)) AND (NOT (alternatives: SubPlan 3 or hashed SubPlan 4)) AND (((first_name)::text ~~* '%major%'::text) OR ((last_name)::text ~~* '%major%'::text) OR ((target_name)::text ~~* '%major%'::text) OR ((web_login)::text ~~ '%major%'::text))) OR ((first_name)::text ~~* '%i%'::text) OR ((last_name)::text ~~* '%i%'::text) OR ((target_name)::text ~~* '%i%'::text) OR ((web_login)::text ~~ '%i%'::text))
  • Rows Removed by Filter: 742,074
179. 72,464.907 144,929.814 ↓ 0.0 0 72,464,907

Append (cost=0.28..0.31 rows=1 width=64) (actual time=0.002..0.002 rows=0 loops=72,464,907)

180. 72,464.907 72,464.907 ↓ 0.0 0 72,464,907

Index Scan using person_roles_org_part_150_organization_uuid_person_uuid_seq_idx on person_roles_org_part_150 pr (cost=0.28..0.30 rows=1 width=64) (actual time=0.001..0.001 rows=0 loops=72,464,907)

  • Index Cond: ((organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid) AND (person_uuid = p.person_uuid))
  • Filter: upper_inf(valid_range)
  • Rows Removed by Filter: 0
181. 144,929.778 144,929.814 ↓ 4.1 33 72,464,907

Materialize (cost=1.97..36.60 rows=8 width=16) (actual time=0.000..0.002 rows=33 loops=72,464,907)

182. 0.021 0.036 ↓ 4.1 33 1

Bitmap Heap Scan on roles role (cost=1.97..36.56 rows=8 width=16) (actual time=0.026..0.036 rows=33 loops=1)

  • Recheck Cond: (organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid)
  • Filter: upper_inf(valid_range)
  • Heap Blocks: exact=2
183. 0.015 0.015 ↓ 1.4 33 1

Bitmap Index Scan on roles_organization_uuid_idx (cost=0.00..1.97 rows=24 width=0) (actual time=0.015..0.015 rows=33 loops=1)

  • Index Cond: (organization_uuid = '59a65168-9a43-4081-9687-fb83eb8b83ba'::uuid)