explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FLzR

Settings
# exclusive inclusive rows x rows loops node
1. 1,760.465 97,868.074 ↑ 1.0 1 1

Aggregate (cost=44,305,653.43..44,305,653.44 rows=1 width=8) (actual time=97,868.073..97,868.074 rows=1 loops=1)

  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
  • ((last_name)::text ~~* '%10%'::text) OR ((target_name)::text ~~* '%10%'::text) OR ((web_login)::text ~~ '%10%'::text))
2.          

Initplan (for Aggregate)

3. 0.001 0.035 ↓ 0.0 0 1

Append (cost=0.42..4.13 rows=1 width=0) (actual time=0.035..0.035 rows=0 loops=1)

4. 0.034 0.034 ↓ 0.0 0 1

Index Scan using person_roles_org_part_20_organization_uuid_person_uuid_sequ_idx on person_roles_org_part_20 (cost=0.42..4.12 rows=1 width=0) (actual time=0.034..0.034 rows=0 loops=1)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (person_uuid = '8ba6c978-5e01-4ca2-8496-bde271d81b72'::uuid))
  • Filter: (is_company_admin AND upper_inf(valid_range))
  • Rows Removed by Filter: 2
5. 743.201 96,107.574 ↑ 375.4 5,744,802 1

Merge Left Join (cost=5,908,983.95..38,913,627.69 rows=2,156,808,648 width=16) (actual time=91,081.904..96,107.574 rows=5,744,802 loops=1)

  • Merge Cond: (p_48.person_uuid = pr.person_uuid)
6. 1,676.953 92,332.320 ↓ 1.1 5,720,454 1

Gather Merge (cost=5,854,919.00..6,494,641.28 rows=5,116,013 width=16) (actual time=88,092.180..92,332.320 rows=5,720,454 loops=1)

  • Workers Planned: 4
  • Params Evaluated: $0
  • Workers Launched: 4
7. 1,992.453 90,655.367 ↑ 1.1 1,144,091 5 / 5

Merge Left Join (cost=5,853,918.94..5,884,274.76 rows=1,279,003 width=16) (actual time=88,019.287..90,655.367 rows=1,144,091 loops=5)

  • Merge Cond: (p_48.person_uuid = adm.person_uuid)
  • Filter: (((p_48.organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (p_48.valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (p_48.is_visible IS TRUE) AND ((p_48.person_uuid = '8ba6c978-5e01-4ca2-8496-bde271d81b72'::uuid) OR $0 OR (tpr.person_uuid IS NOT NULL)) AND (adm.person_uuid IS NULL) AND (((p_48.first_name)::text ~~* '%is%'::text) OR ((p_48.last_name)::text ~~* '%is%'::text) OR ((p_48.target_name)::text ~~* '%is%'::text) OR ((p_48.web_login)::text ~~ '%is%'::text))) OR ((p_48.first_name)::text ~~* '%10%'::text) OR ((p_48.last_name)::text ~~* '%10%'::text) OR ((p_48.target_name)::text ~~* '%10%'::text) OR ((p_48.web_login)::text ~~ '%10%'::text))
  • Rows Removed by Filter: 117
8. 276.225 88,623.503 ↑ 1.9 1,144,208 5 / 5

Merge Left Join (cost=5,845,180.69..5,869,660.31 rows=2,166,333 width=103) (actual time=87,979.852..88,623.503 rows=1,144,208 loops=5)

  • Merge Cond: (p_48.person_uuid = tpr.person_uuid)
9. 1,563.277 87,952.656 ↑ 1.9 1,143,396 5 / 5

Sort (cost=5,844,820.84..5,850,236.69 rows=2,166,338 width=87) (actual time=87,597.893..87,952.656 rows=1,143,396 loops=5)

  • Sort Key: p_48.person_uuid
  • Sort Method: external merge Disk: 153,016kB
  • Worker 0: Sort Method: external merge Disk: 81,480kB
  • Worker 1: Sort Method: external merge Disk: 139,568kB
  • Worker 2: Sort Method: external merge Disk: 102,432kB
  • Worker 3: Sort Method: external merge Disk: 77,920kB
10. 127.294 86,389.379 ↑ 1.9 1,143,396 5 / 5

Parallel Append (cost=0.00..5,550,207.64 rows=2,166,338 width=87) (actual time=2.100..86,389.379 rows=1,143,396 loops=5)

11. 36,434.687 36,434.687 ↑ 1.7 310,663 5 / 5

Parallel Seq Scan on persons_org_part_1 p_48 (cost=0.00..974,293.55 rows=526,129 width=82) (actual time=0.114..36,434.687 rows=310,663 loops=5)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 3,153,880
12. 5,153.530 5,153.530 ↓ 4.0 251,790 1 / 5

Parallel Seq Scan on persons_org_part_2 p_153 (cost=0.00..494,361.47 rows=63,084 width=85) (actual time=0.277..25,767.650 rows=251,790 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 12,091,880
13. 1,864.713 1,864.713 ↓ 2.7 573,242 1 / 5

Parallel Seq Scan on persons_org_part_6 p_150 (cost=0.00..363,896.44 rows=212,965 width=86) (actual time=0.238..9,323.565 rows=573,242 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 3,201,887
14. 1,760.896 1,760.896 ↓ 2.2 370,074 1 / 5

Parallel Seq Scan on persons_org_part_5 p_114 (cost=0.00..337,327.33 rows=169,790 width=83) (actual time=3.971..8,804.480 rows=370,074 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 3,533,938
15. 2,262.643 2,262.643 ↓ 3.3 154,291 1 / 5

Parallel Seq Scan on persons_org_part_3 p_131 (cost=0.00..264,841.05 rows=47,444 width=108) (actual time=0.100..11,313.215 rows=154,291 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 4,521,134
16. 1,696.499 1,696.499 ↓ 153.4 58,122 1 / 5

Parallel Seq Scan on persons_org_part_4 p_41 (cost=0.00..238,337.91 rows=379 width=100) (actual time=0.067..8,482.496 rows=58,122 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 4,091,776
17. 2,576.017 2,576.017 ↓ 3.8 105,038 1 / 5

Parallel Seq Scan on persons_org_part_7 p_99 (cost=0.00..211,159.91 rows=27,446 width=108) (actual time=0.046..12,880.087 rows=105,038 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 3,494,521
18. 2,964.660 2,964.660 ↓ 2.1 171,212 1 / 5

Parallel Seq Scan on persons_org_part_8 p_104 (cost=0.00..210,869.22 rows=83,367 width=90) (actual time=40.056..14,823.298 rows=171,212 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 3,272,204
19. 1,724.269 1,724.269 ↓ 1.7 202,037 1 / 5

Parallel Seq Scan on persons_org_part_11 p_13 (cost=0.00..199,558.98 rows=119,504 width=84) (actual time=61.292..8,621.343 rows=202,037 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 2,089,850
20. 2,094.142 2,094.142 ↓ 4.5 5,777 1 / 5

Parallel Seq Scan on persons_org_part_10 p_90 (cost=0.00..166,196.31 rows=1,294 width=84) (actual time=51.096..10,470.712 rows=5,777 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 2,402,720
21. 3,495.145 3,495.145 ↓ 7.8 83,622 1 / 5

Parallel Seq Scan on persons_org_part_9 p_86 (cost=0.00..161,536.36 rows=10,780 width=85) (actual time=0.310..17,475.727 rows=83,622 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 4,043,987
22. 1,060.664 1,060.664 ↓ 1.6 144,822 1 / 5

Parallel Seq Scan on persons_org_part_16 p_96 (cost=0.00..133,966.00 rows=92,539 width=85) (actual time=0.022..5,303.318 rows=144,822 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 1,425,482
23. 1,315.075 1,315.075 ↓ 2.5 207,425 1 / 5

Parallel Seq Scan on persons_org_part_12 p_70 (cost=0.00..124,270.33 rows=84,074 width=86) (actual time=0.263..6,575.373 rows=207,425 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 1,955,938
24. 1,201.849 1,201.849 ↓ 2.4 101,697 1 / 5

Parallel Seq Scan on persons_org_part_18 p_128 (cost=0.00..114,844.01 rows=42,003 width=82) (actual time=30.961..6,009.246 rows=101,697 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 1,588,533
25. 2,170.135 2,170.135 ↓ 2.2 211,078 1 / 5

Parallel Seq Scan on persons_org_part_13 p_57 (cost=0.00..102,460.97 rows=95,645 width=85) (actual time=47.059..10,850.673 rows=211,078 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 1,961,685
26. 1,444.690 1,444.690 ↓ 2.4 443 1 / 5

Parallel Seq Scan on persons_org_part_14 p_119 (cost=0.00..97,821.89 rows=188 width=85) (actual time=128.507..7,223.450 rows=443 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 2,019,491
27. 1,539.513 1,539.513 ↓ 2.7 72,052 1 / 5

Parallel Seq Scan on persons_org_part_default p_157 (cost=0.00..89,788.11 rows=26,592 width=89) (actual time=44.749..7,697.567 rows=72,052 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 2,249,662
28. 1,277.201 1,277.201 ↓ 3.9 5,236 1 / 5

Parallel Seq Scan on persons_org_part_20 p_72 (cost=0.00..76,512.05 rows=1,360 width=84) (actual time=1.928..6,386.007 rows=5,236 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 1,393,986
29. 1,669.331 1,669.331 ↑ 2.5 2,496 3 / 5

Parallel Seq Scan on persons_org_part_24 p_71 (cost=0.00..63,745.64 rows=6,209 width=84) (actual time=23.930..2,782.218 rows=2,496 loops=3)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 273,084
30. 1,152.755 1,152.755 ↓ 1.2 143,167 2 / 5

Parallel Seq Scan on persons_org_part_17 p_155 (cost=0.00..55,843.26 rows=123,856 width=81) (actual time=9.102..2,881.887 rows=143,167 loops=2)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 668,417
31. 728.145 728.145 ↓ 2.5 45,105 1 / 5

Parallel Seq Scan on persons_org_part_19 p_147 (cost=0.00..47,272.57 rows=17,900 width=89) (actual time=41.194..3,640.725 rows=45,105 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 1,303,054
32. 587.089 587.089 ↓ 4.3 169,723 1 / 5

Parallel Seq Scan on persons_org_part_28 p_124 (cost=0.00..47,175.28 rows=39,123 width=79) (actual time=50.908..2,935.443 rows=169,723 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 523,387
33. 675.266 675.266 ↓ 1.9 196,710 1 / 5

Parallel Seq Scan on persons_org_part_22 p_75 (cost=0.00..39,771.56 rows=103,882 width=131) (actual time=38.768..3,376.329 rows=196,710 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 846,328
34. 424.452 424.452 ↓ 165.1 20,137 1 / 5

Parallel Seq Scan on persons_org_part_21 p_149 (cost=0.00..38,256.43 rows=122 width=84) (actual time=0.075..2,122.258 rows=20,137 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 1,055,857
35. 311.547 311.547 ↓ 4.4 34,094 1 / 5

Parallel Seq Scan on persons_org_part_27 p_139 (cost=0.00..36,431.64 rows=7,738 width=85) (actual time=0.019..1,557.735 rows=34,094 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 711,513
36. 352.477 352.477 ↓ 2.7 23,557 1 / 5

Parallel Seq Scan on persons_org_part_23 p_133 (cost=0.00..34,679.06 rows=8,742 width=81) (actual time=0.051..1,762.386 rows=23,557 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 908,463
37. 314.101 314.101 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_25 p_24 (cost=0.00..32,536.68 rows=80 width=100) (actual time=1,570.505..1,570.505 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 742,997
38. 238.736 238.736 ↓ 62.3 3,366 1 / 5

Parallel Seq Scan on persons_org_part_30 p_55 (cost=0.00..31,172.14 rows=54 width=84) (actual time=0.183..1,193.678 rows=3,366 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 602,663
39. 298.225 298.225 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_26 p_109 (cost=0.00..27,427.10 rows=1 width=105) (actual time=1,491.124..1,491.124 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 742,238
40. 135.536 135.536 ↓ 3.4 36,644 1 / 5

Parallel Seq Scan on persons_org_part_42 p_144 (cost=0.00..27,414.73 rows=10,631 width=95) (actual time=0.026..677.680 rows=36,644 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 249,128
41. 269.017 269.017 ↑ 2.8 7,457 1 / 5

Parallel Seq Scan on persons_org_part_29 p_129 (cost=0.00..24,926.06 rows=20,905 width=85) (actual time=0.057..1,345.085 rows=7,457 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 698,161
42. 240.467 240.467 ↓ 1.6 30,663 1 / 5

Parallel Seq Scan on persons_org_part_31 p_8 (cost=0.00..19,578.32 rows=19,188 width=84) (actual time=0.052..1,202.335 rows=30,663 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 500,983
43. 146.417 146.417 ↓ 2.3 23,299 1 / 5

Parallel Seq Scan on persons_org_part_37 p_112 (cost=0.00..19,517.44 rows=10,000 width=78) (actual time=0.025..732.087 rows=23,299 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 370,212
44. 134.165 134.165 ↓ 1.8 32,214 1 / 5

Parallel Seq Scan on persons_org_part_38 p_126 (cost=0.00..18,899.61 rows=17,733 width=80) (actual time=0.039..670.823 rows=32,214 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 321,949
45. 374.060 374.060 ↓ 1.8 17,327 1 / 5

Parallel Seq Scan on persons_org_part_32 p_1 (cost=0.00..18,779.76 rows=9,695 width=82) (actual time=17.820..1,870.302 rows=17,327 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 481,277
46. 216.551 216.551 ↓ 1.6 11,903 1 / 5

Parallel Seq Scan on persons_org_part_36 p_65 (cost=0.00..18,220.53 rows=7,395 width=85) (actual time=21.826..1,082.753 rows=11,903 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 383,806
47. 241.296 241.296 ↑ 2.8 557 1 / 5

Parallel Seq Scan on persons_org_part_33 p_20 (cost=0.00..17,044.78 rows=1,543 width=83) (actual time=70.273..1,206.478 rows=557 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 479,569
48. 283.897 283.897 ↓ 1.6 72 1 / 5

Parallel Seq Scan on persons_org_part_34 p_107 (cost=0.00..16,556.15 rows=45 width=96) (actual time=65.186..1,419.486 rows=72 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 425,855
49. 201.512 201.512 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_39 p_61 (cost=0.00..16,168.54 rows=42 width=83) (actual time=1,007.560..1,007.560 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 391,357
50. 294.916 294.916 ↓ 1.9 72 1 / 5

Parallel Seq Scan on persons_org_part_35 p_40 (cost=0.00..15,581.39 rows=38 width=103) (actual time=63.530..1,474.581 rows=72 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 390,120
51. 224.555 224.555 ↓ 1.7 50 1 / 5

Parallel Seq Scan on persons_org_part_44 p_32 (cost=0.00..14,451.26 rows=29 width=84) (actual time=37.946..1,122.776 rows=50 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 264,447
52. 117.326 117.326 ↑ 1.2 12 1 / 5

Parallel Seq Scan on persons_org_part_41 p_56 (cost=0.00..13,296.71 rows=15 width=90) (actual time=152.813..586.628 rows=12 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 350,533
53. 156.308 156.308 ↓ 1.2 11,906 1 / 5

Parallel Seq Scan on persons_org_part_45 p_2 (cost=0.00..12,906.20 rows=9,801 width=79) (actual time=32.055..781.538 rows=11,906 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 244,976
54. 170.545 170.545 ↓ 2.7 8,258 1 / 5

Parallel Seq Scan on persons_org_part_48 p_118 (cost=0.00..12,516.76 rows=3,024 width=91) (actual time=24.560..852.723 rows=8,258 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 232,991
55. 151.738 151.738 ↓ 1.4 17,924 1 / 5

Parallel Seq Scan on persons_org_part_46 p_110 (cost=0.00..12,410.17 rows=12,476 width=79) (actual time=31.522..758.689 rows=17,924 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 232,217
56. 169.240 169.240 ↓ 1.1 3,356 1 / 5

Parallel Seq Scan on persons_org_part_57 p (cost=0.00..11,791.83 rows=3,025 width=79) (actual time=125.844..846.200 rows=3,356 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 174,579
57. 174.972 174.972 ↓ 1.6 5,361 1 / 5

Parallel Seq Scan on persons_org_part_67 p_136 (cost=0.00..11,694.86 rows=3,256 width=84) (actual time=0.096..874.862 rows=5,361 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 126,869
58. 155.502 155.502 ↓ 1.6 759 1 / 5

Parallel Seq Scan on persons_org_part_64 p_14 (cost=0.00..10,849.50 rows=466 width=82) (actual time=54.278..777.510 rows=759 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 135,420
59. 148.347 148.347 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_43 p_134 (cost=0.00..10,820.39 rows=28 width=84) (actual time=741.734..741.734 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 280,573
60. 89.019 89.019 ↓ 2.5 3,397 1 / 5

Parallel Seq Scan on persons_org_part_88 p_140 (cost=0.00..10,405.66 rows=1,375 width=82) (actual time=13.837..445.096 rows=3,397 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 85,766
61. 136.439 136.439 ↓ 1.1 4,514 1 / 5

Parallel Seq Scan on persons_org_part_47 p_102 (cost=0.00..9,783.68 rows=4,027 width=81) (actual time=20.012..682.197 rows=4,514 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 244,340
62. 131.970 131.970 ↓ 1.7 20,976 1 / 5

Parallel Seq Scan on persons_org_part_49 p_27 (cost=0.00..9,681.79 rows=12,229 width=80) (actual time=44.318..659.851 rows=20,976 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 215,292
63. 105.739 105.739 ↓ 1.5 18,138 1 / 5

Parallel Seq Scan on persons_org_part_51 p_83 (cost=0.00..9,423.48 rows=12,345 width=84) (actual time=0.031..528.694 rows=18,138 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 211,658
64. 85.823 85.823 ↑ 1.7 12 1 / 5

Parallel Seq Scan on persons_org_part_52 p_10 (cost=0.00..9,402.69 rows=20 width=100) (actual time=30.938..429.114 rows=12 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 231,922
65. 87.853 87.853 ↓ 1.2 2,308 1 / 5

Parallel Seq Scan on persons_org_part_50 p_98 (cost=0.00..9,233.40 rows=1,906 width=85) (actual time=0.342..439.267 rows=2,308 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 235,999
66. 83.422 83.422 ↓ 1.6 7,109 1 / 5

Parallel Seq Scan on persons_org_part_54 p_105 (cost=0.00..8,846.79 rows=4,421 width=85) (actual time=0.109..417.111 rows=7,109 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 215,433
67. 80.336 80.336 ↓ 1.6 9,987 1 / 5

Parallel Seq Scan on persons_org_part_53 p_66 (cost=0.00..8,400.75 rows=6,235 width=85) (actual time=0.112..401.679 rows=9,987 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 210,242
68. 59.127 59.127 ↓ 20.7 496 1 / 5

Parallel Seq Scan on persons_org_part_61 p_117 (cost=0.00..8,101.94 rows=24 width=82) (actual time=0.078..295.637 rows=496 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 165,544
69. 68.193 68.193 ↓ 1.2 6,367 1 / 5

Parallel Seq Scan on persons_org_part_55 p_23 (cost=0.00..7,716.73 rows=5,357 width=81) (actual time=0.088..340.963 rows=6,367 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 181,728
70. 72.289 72.289 ↓ 1.4 28,434 1 / 5

Parallel Seq Scan on persons_org_part_56 p_74 (cost=0.00..7,710.34 rows=19,821 width=84) (actual time=0.035..361.447 rows=28,434 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 166,510
71. 61.748 61.748 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_58 p_63 (cost=0.00..7,655.68 rows=22 width=83) (actual time=308.739..308.739 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 170,087
72. 51.387 51.387 ↓ 2.9 6,650 1 / 5

Parallel Seq Scan on persons_org_part_66 p_156 (cost=0.00..7,484.20 rows=2,259 width=83) (actual time=0.322..256.935 rows=6,650 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 126,735
73. 60.068 60.068 ↓ 1.3 132 1 / 5

Parallel Seq Scan on persons_org_part_59 p_116 (cost=0.00..6,993.81 rows=99 width=93) (actual time=15.786..300.342 rows=132 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 165,167
74. 59.492 59.492 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_60 p_141 (cost=0.00..6,803.58 rows=14 width=90) (actual time=297.458..297.458 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 165,019
75. 41.592 41.592 ↓ 1.6 25 1 / 5

Parallel Seq Scan on persons_org_part_72 p_58 (cost=0.00..6,576.21 rows=16 width=84) (actual time=6.017..207.961 rows=25 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 114,024
76. 27.107 27.107 ↑ 1.3 6 1 / 5

Parallel Seq Scan on persons_org_part_103 p_151 (cost=0.00..6,537.74 rows=8 width=106) (actual time=1.996..135.534 rows=6 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 57,919
77. 39.603 39.603 ↑ 1.0 2,728 1 / 5

Parallel Seq Scan on persons_org_part_73 p_123 (cost=0.00..6,435.08 rows=2,775 width=79) (actual time=0.351..198.014 rows=2,728 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 109,392
78. 38.269 38.269 ↓ 2.9 8,950 1 / 5

Parallel Seq Scan on persons_org_part_77 p_7 (cost=0.00..6,126.20 rows=3,041 width=79) (actual time=0.013..191.345 rows=8,950 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 93,921
79. 52.055 52.055 ↑ 2.7 414 1 / 5

Parallel Seq Scan on persons_org_part_71 p_53 (cost=0.00..6,066.86 rows=1,117 width=83) (actual time=0.114..260.273 rows=414 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 145,439
80. 56.394 56.394 ↑ 1.5 12 1 / 5

Parallel Seq Scan on persons_org_part_62 p_152 (cost=0.00..5,989.63 rows=18 width=91) (actual time=97.669..281.972 rows=12 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 151,827
81. 37.112 37.112 ↓ 1.4 15,034 1 / 5

Parallel Seq Scan on persons_org_part_78 p_17 (cost=0.00..5,703.07 rows=11,126 width=80) (actual time=0.038..185.559 rows=15,034 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 86,525
82. 47.911 47.911 ↓ 1.1 9 1 / 5

Parallel Seq Scan on persons_org_part_65 p_4 (cost=0.00..5,516.04 rows=8 width=94) (actual time=9.594..239.556 rows=9 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 135,399
83. 42.791 42.791 ↓ 1.3 8,176 1 / 5

Parallel Seq Scan on persons_org_part_70 p_37 (cost=0.00..5,455.37 rows=6,223 width=82) (actual time=0.044..213.956 rows=8,176 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 109,914
84. 46.967 46.967 ↓ 21.0 126 1 / 5

Parallel Seq Scan on persons_org_part_68 p_15 (cost=0.00..5,372.70 rows=6 width=83) (actual time=2.736..234.833 rows=126 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 129,574
85. 48.382 48.382 ↓ 1.9 15,155 1 / 5

Parallel Seq Scan on persons_org_part_69 p_18 (cost=0.00..5,352.89 rows=8,121 width=108) (actual time=0.235..241.912 rows=15,155 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 109,445
86. 49.464 49.464 ↓ 1.0 5,636 1 / 5

Parallel Seq Scan on persons_org_part_63 p_42 (cost=0.00..5,247.55 rows=5,455 width=81) (actual time=0.072..247.322 rows=5,636 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 136,562
87. 25.096 25.096 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_97 p_69 (cost=0.00..5,073.18 rows=2 width=94) (actual time=125.480..125.480 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 62,141
88. 41.951 41.951 ↑ 1.1 5,393 1 / 5

Parallel Seq Scan on persons_org_part_76 p_38 (cost=0.00..4,915.95 rows=6,148 width=89) (actual time=0.038..209.754 rows=5,393 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 104,224
89. 39.965 39.965 ↓ 1.0 5,310 1 / 5

Parallel Seq Scan on persons_org_part_75 p_138 (cost=0.00..4,864.20 rows=5,114 width=89) (actual time=0.050..199.827 rows=5,310 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 103,111
90. 45.544 45.544 ↑ 9.0 7 1 / 5

Parallel Seq Scan on persons_org_part_74 p_92 (cost=0.00..4,835.68 rows=63 width=106) (actual time=0.324..227.719 rows=7 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 112,085
91. 39.117 39.117 ↑ 6.4 278 1 / 5

Parallel Seq Scan on persons_org_part_15 p_154 (cost=0.00..4,798.31 rows=1,771 width=96) (actual time=2.364..195.586 rows=278 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 101,352
92. 38.223 38.223 ↓ 1.7 8,258 1 / 5

Parallel Seq Scan on persons_org_part_81 p_91 (cost=0.00..4,380.44 rows=4,791 width=117) (actual time=0.019..191.113 rows=8,258 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 80,360
93. 32.801 32.801 ↑ 1.6 2,989 1 / 5

Parallel Seq Scan on persons_org_part_79 p_111 (cost=0.00..4,269.51 rows=4,768 width=82) (actual time=0.204..164.005 rows=2,989 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 91,262
94. 32.163 32.163 ↓ 1.6 89,142 1 / 5

Parallel Seq Scan on persons_org_part_82 p_137 (cost=0.00..4,185.44 rows=54,184 width=82) (actual time=0.014..160.816 rows=89,142 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 64
95. 31.098 31.098 ↓ 1.0 1,983 1 / 5

Parallel Seq Scan on persons_org_part_85 p_101 (cost=0.00..4,179.17 rows=1,912 width=84) (actual time=0.024..155.488 rows=1,983 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 83,910
96. 31.990 31.990 ↓ 2.0 22 1 / 5

Parallel Seq Scan on persons_org_part_86 p_3 (cost=0.00..4,088.62 rows=11 width=104) (actual time=35.064..159.951 rows=22 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 83,440
97. 30.675 30.675 ↓ 1.6 319 1 / 5

Parallel Seq Scan on persons_org_part_90 p_85 (cost=0.00..4,075.58 rows=195 width=79) (actual time=0.049..153.377 rows=319 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 86,446
98. 32.779 32.779 ↓ 1.0 1,179 1 / 5

Parallel Seq Scan on persons_org_part_87 p_36 (cost=0.00..4,072.45 rows=1,165 width=108) (actual time=0.102..163.893 rows=1,179 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 80,853
99. 30.164 30.164 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_83 p_93 (cost=0.00..4,020.96 rows=9 width=83) (actual time=150.821..150.821 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 85,435
100. 30.086 30.086 ↓ 16.6 532 1 / 5

Parallel Seq Scan on persons_org_part_84 p_22 (cost=0.00..3,980.85 rows=32 width=82) (actual time=0.137..150.432 rows=532 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 83,082
101. 22.420 22.420 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_98 p_106 (cost=0.00..3,816.61 rows=8 width=83) (actual time=112.099..112.099 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 62,281
102. 31.990 31.990 ↓ 1.5 3,580 1 / 5

Parallel Seq Scan on persons_org_part_80 p_113 (cost=0.00..3,788.68 rows=2,328 width=83) (actual time=0.166..159.950 rows=3,580 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 85,626
103. 16.624 16.624 ↓ 1.6 1,537 1 / 5

Parallel Seq Scan on persons_org_part_117 p_95 (cost=0.00..3,782.52 rows=984 width=77) (actual time=0.618..83.119 rows=1,537 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 43,350
104. 28.224 28.224 ↓ 1.3 6,037 1 / 5

Parallel Seq Scan on persons_org_part_112 p_29 (cost=0.00..3,730.26 rows=4,698 width=163) (actual time=0.105..141.121 rows=6,037 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 47,125
105. 29.814 29.814 ↓ 1.1 3,163 1 / 5

Parallel Seq Scan on persons_org_part_89 p_121 (cost=0.00..3,667.37 rows=2,898 width=84) (actual time=0.042..149.070 rows=3,163 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 80,009
106. 30.533 30.533 ↓ 1.3 4,520 1 / 5

Parallel Seq Scan on persons_org_part_92 p_143 (cost=0.00..3,651.52 rows=3,609 width=83) (actual time=0.022..152.664 rows=4,520 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 72,588
107. 31.938 31.938 ↓ 1.7 81,510 1 / 5

Parallel Seq Scan on persons_org_part_91 p_60 (cost=0.00..3,627.64 rows=48,818 width=84) (actual time=0.015..159.692 rows=81,510 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 347
108. 26.562 26.562 ↑ 1.1 11,611 1 / 5

Parallel Seq Scan on persons_org_part_93 p_142 (cost=0.00..3,568.30 rows=12,287 width=83) (actual time=0.015..132.809 rows=11,611 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 55,128
109. 21.560 21.560 ↓ 1.0 5,719 1 / 5

Parallel Seq Scan on persons_org_part_104 p_130 (cost=0.00..3,387.48 rows=5,467 width=82) (actual time=0.015..107.799 rows=5,719 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 51,382
110. 23.957 23.957 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_96 p_100 (cost=0.00..3,190.01 rows=10 width=99) (actual time=119.783..119.783 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 62,388
111. 25.597 25.597 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_99 p_125 (cost=0.00..3,164.28 rows=8 width=104) (actual time=127.983..127.983 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 62,779
112. 24.235 24.235 ↑ 1.7 2,978 1 / 5

Parallel Seq Scan on persons_org_part_94 p_73 (cost=0.00..2,986.35 rows=5,052 width=81) (actual time=0.103..121.173 rows=2,978 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 62,659
113. 25.429 25.429 ↑ 1.3 4,118 1 / 5

Parallel Seq Scan on persons_org_part_102 p_19 (cost=0.00..2,969.46 rows=5,429 width=92) (actual time=0.086..127.143 rows=4,118 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 56,878
114. 22.702 22.702 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_101 p_64 (cost=0.00..2,927.29 rows=2 width=81) (actual time=113.510..113.510 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 61,302
115. 22.813 22.813 ↑ 1.3 2,499 1 / 5

Parallel Seq Scan on persons_org_part_95 p_11 (cost=0.00..2,877.70 rows=3,131 width=84) (actual time=0.029..114.066 rows=2,499 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 62,639
116. 21.627 21.627 ↓ 2.1 21 1 / 5

Parallel Seq Scan on persons_org_part_111 p_51 (cost=0.00..2,862.17 rows=10 width=102) (actual time=16.539..108.136 rows=21 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 53,488
117. 23.170 23.170 ↓ 1.3 2,888 1 / 5

Parallel Seq Scan on persons_org_part_100 p_77 (cost=0.00..2,781.28 rows=2,275 width=87) (actual time=0.052..115.850 rows=2,888 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 58,270
118. 23.099 23.099 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_106 p_122 (cost=0.00..2,766.20 rows=1 width=106) (actual time=115.495..115.495 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 55,847
119. 21.121 21.121 ↑ 1.2 5 1 / 5

Parallel Seq Scan on persons_org_part_105 p_76 (cost=0.00..2,558.61 rows=6 width=83) (actual time=29.320..105.605 rows=5 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 56,367
120. 22.618 22.618 ↑ 1.1 3,090 1 / 5

Parallel Seq Scan on persons_org_part_107 p_62 (cost=0.00..2,481.12 rows=3,531 width=86) (actual time=0.103..113.088 rows=3,090 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 52,432
121. 19.914 19.914 ↑ 1.2 5,754 1 / 5

Parallel Seq Scan on persons_org_part_108 p_12 (cost=0.00..2,473.49 rows=6,626 width=85) (actual time=0.053..99.569 rows=5,754 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 49,542
122. 21.659 21.659 ↓ 1.0 2,488 1 / 5

Parallel Seq Scan on persons_org_part_109 p_88 (cost=0.00..2,459.87 rows=2,487 width=82) (actual time=0.035..108.295 rows=2,488 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 52,767
123. 80.481 80.481 ↑ 1.5 184 1 / 5

Parallel Seq Scan on persons_org_part_113 p_44 (cost=0.00..2,457.36 rows=279 width=92) (actual time=0.330..402.405 rows=184 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 52,897
124. 19.582 19.582 ↑ 1.1 1,772 1 / 5

Parallel Seq Scan on persons_org_part_110 p_81 (cost=0.00..2,421.32 rows=2,001 width=86) (actual time=0.182..97.909 rows=1,772 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 52,857
125. 18.244 18.244 ↑ 1.0 1,843 1 / 5

Parallel Seq Scan on persons_org_part_115 p_67 (cost=0.00..2,211.76 rows=1,846 width=110) (actual time=0.020..91.221 rows=1,843 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 42,928
126. 16.899 16.899 ↓ 1.3 4,160 1 / 5

Parallel Seq Scan on persons_org_part_114 p_45 (cost=0.00..2,199.75 rows=3,297 width=86) (actual time=0.102..84.495 rows=4,160 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 42,786
127. 12.635 12.635 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_126 p_39 (cost=0.00..2,026.06 rows=6 width=81) (actual time=63.173..63.173 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 34,829
128. 16.247 16.247 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_116 p_84 (cost=0.00..2,021.56 rows=5 width=80) (actual time=81.234..81.234 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 45,701
129. 15.849 15.849 ↑ 1.1 1,228 1 / 5

Parallel Seq Scan on persons_org_part_118 p_30 (cost=0.00..2,013.09 rows=1,401 width=87) (actual time=0.108..79.246 rows=1,228 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 42,038
130. 14.181 14.181 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_121 p_21 (cost=0.00..1,895.64 rows=1 width=89) (actual time=70.905..70.906 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 38,853
131. 13.530 13.530 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_122 p_9 (cost=0.00..1,868.26 rows=24 width=78) (actual time=67.649..67.649 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 40,124
132. 15.385 15.385 ↓ 4.5 9 1 / 5

Parallel Seq Scan on persons_org_part_119 p_5 (cost=0.00..1,865.69 rows=2 width=89) (actual time=8.564..76.924 rows=9 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 41,926
133. 12.328 12.328 ↓ 7.0 35 1 / 5

Parallel Seq Scan on persons_org_part_127 p_94 (cost=0.00..1,808.73 rows=5 width=81) (actual time=3.550..61.641 rows=35 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 34,928
134. 14.295 14.295 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_120 p_82 (cost=0.00..1,806.37 rows=7 width=82) (actual time=71.473..71.473 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 40,690
135. 13.662 13.662 ↑ 1.2 791 1 / 5

Parallel Seq Scan on persons_org_part_124 p_146 (cost=0.00..1,792.64 rows=955 width=87) (actual time=0.313..68.310 rows=791 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 36,213
136. 14.625 14.625 ↑ 1.1 4,566 1 / 5

Parallel Seq Scan on persons_org_part_123 p_127 (cost=0.00..1,773.85 rows=4,995 width=88) (actual time=0.042..73.123 rows=4,566 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 34,392
137. 11.146 11.146 ↑ 1.9 931 1 / 5

Parallel Seq Scan on persons_org_part_136 p_25 (cost=0.00..1,721.91 rows=1,761 width=80) (actual time=0.020..55.730 rows=931 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 29,713
138. 10.055 10.055 ↓ 6.1 67 1 / 5

Parallel Seq Scan on persons_org_part_149 p_49 (cost=0.00..1,721.61 rows=11 width=100) (actual time=0.311..50.276 rows=67 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 24,142
139. 13.881 13.881 ↓ 3.0 3 1 / 5

Parallel Seq Scan on persons_org_part_131 p_34 (cost=0.00..1,706.01 rows=1 width=117) (actual time=55.695..69.407 rows=3 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 33,198
140. 12.551 12.551 ↓ 1.7 611 1 / 5

Parallel Seq Scan on persons_org_part_128 p_68 (cost=0.00..1,691.75 rows=358 width=85) (actual time=0.183..62.756 rows=611 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 34,125
141. 12.917 12.917 ↑ 1.7 1,196 1 / 5

Parallel Seq Scan on persons_org_part_133 p_103 (cost=0.00..1,667.29 rows=1,995 width=108) (actual time=0.053..64.586 rows=1,196 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 30,785
142. 13.254 13.254 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_125 p_135 (cost=0.00..1,604.91 rows=4 width=83) (actual time=66.269..66.269 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 36,401
143. 11.614 11.614 ↑ 1.4 648 1 / 5

Parallel Seq Scan on persons_org_part_130 p_26 (cost=0.00..1,564.86 rows=876 width=79) (actual time=0.381..58.070 rows=648 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 32,585
144. 10.946 10.946 ↑ 17.3 10 1 / 5

Parallel Seq Scan on persons_org_part_135 p_6 (cost=0.00..1,542.07 rows=173 width=80) (actual time=5.726..54.732 rows=10 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 31,225
145. 11.714 11.714 ↓ 10.0 10 1 / 5

Parallel Seq Scan on persons_org_part_132 p_78 (cost=0.00..1,476.73 rows=1 width=90) (actual time=19.708..58.570 rows=10 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 32,485
146. 11.500 11.500 ↑ 1.0 413 1 / 5

Parallel Seq Scan on persons_org_part_129 p_87 (cost=0.00..1,476.25 rows=427 width=81) (actual time=1.940..57.499 rows=413 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 33,201
147. 8.715 8.715 ↓ 1.1 1,197 1 / 5

Parallel Seq Scan on persons_org_part_148 p_54 (cost=0.00..1,460.71 rows=1,074 width=77) (actual time=0.053..43.575 rows=1,197 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 23,118
148. 10.966 10.966 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_145 p_148 (cost=0.00..1,446.21 rows=3 width=117) (actual time=54.829..54.829 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 26,444
149. 11.354 11.354 ↑ 1.1 864 1 / 5

Parallel Seq Scan on persons_org_part_134 p_132 (cost=0.00..1,420.43 rows=919 width=81) (actual time=0.051..56.769 rows=864 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 31,359
150. 10.756 10.756 ↓ 1.1 500 1 / 5

Parallel Seq Scan on persons_org_part_137 p_145 (cost=0.00..1,398.31 rows=472 width=82) (actual time=0.025..53.779 rows=500 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 29,759
151. 9.815 9.815 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_141 p_97 (cost=0.00..1,346.47 rows=2 width=81) (actual time=49.074..49.074 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 28,690
152. 10.402 10.402 ↑ 1.1 1,329 1 / 5

Parallel Seq Scan on persons_org_part_138 p_120 (cost=0.00..1,331.56 rows=1,459 width=87) (actual time=0.221..52.009 rows=1,329 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 27,938
153. 10.362 10.362 ↓ 1.4 223 1 / 5

Parallel Seq Scan on persons_org_part_144 p_31 (cost=0.00..1,324.21 rows=156 width=100) (actual time=1.211..51.810 rows=223 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 26,667
154. 10.523 10.523 ↓ 6.0 12 1 / 5

Parallel Seq Scan on persons_org_part_139 p_59 (cost=0.00..1,305.02 rows=2 width=83) (actual time=3.307..52.613 rows=12 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 29,605
155. 10.171 10.171 ↓ 1.0 349 1 / 5

Parallel Seq Scan on persons_org_part_140 p_89 (cost=0.00..1,297.41 rows=338 width=79) (actual time=0.297..50.856 rows=349 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 28,897
156. 72.339 72.339 ↓ 1.1 1,091 1 / 5

Parallel Seq Scan on persons_org_part_142 p_43 (cost=0.00..1,293.77 rows=1,016 width=80) (actual time=19.853..361.696 rows=1,091 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 27,228
157. 10.032 10.032 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_143 p_46 (cost=0.00..1,276.11 rows=5 width=93) (actual time=50.158..50.158 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 27,475
158. 8.884 8.884 ↓ 1.7 323 1 / 5

Parallel Seq Scan on persons_org_part_156 p_50 (cost=0.00..1,190.29 rows=193 width=95) (actual time=0.440..44.419 rows=323 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 22,415
159. 8.881 8.881 ↓ 1.6 229 1 / 5

Parallel Seq Scan on persons_org_part_147 p_108 (cost=0.00..1,172.44 rows=139 width=86) (actual time=0.031..44.407 rows=229 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 24,525
160. 8.472 8.472 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_151 p_79 (cost=0.00..1,169.19 rows=14 width=83) (actual time=42.358..42.358 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 23,990
161. 9.726 9.726 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_153 p_35 (cost=0.00..1,148.33 rows=2 width=127) (actual time=48.628..48.628 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 23,095
162. 8.870 8.870 ↑ 1.1 2,142 1 / 5

Parallel Seq Scan on persons_org_part_146 p_28 (cost=0.00..1,106.56 rows=2,331 width=86) (actual time=0.013..44.351 rows=2,142 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 22,777
163. 8.054 8.054 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_154 p_115 (cost=0.00..1,074.86 rows=2 width=84) (actual time=40.270..40.270 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 22,781
164. 8.599 8.599 ↑ 1.1 2,724 1 / 5

Parallel Seq Scan on persons_org_part_150 p_52 (cost=0.00..1,045.44 rows=2,955 width=83) (actual time=0.016..42.996 rows=2,724 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 21,184
165. 35.999 35.999 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_155 p_47 (cost=0.00..1,026.78 rows=1 width=81) (actual time=179.997..179.997 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 23,186
166. 8.137 8.137 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_152 p_80 (cost=0.00..1,024.65 rows=4 width=83) (actual time=40.685..40.685 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 22,523
167. 7.749 7.749 ↑ 1.1 173 1 / 5

Parallel Seq Scan on persons_org_part_157 p_33 (cost=0.00..1,000.86 rows=182 width=81) (actual time=0.074..38.747 rows=173 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 22,149
168. 1.133 1.133 ↓ 0.0 0 1 / 5

Parallel Seq Scan on persons_org_part_40 p_16 (cost=0.00..120.25 rows=7 width=132) (actual time=5.666..5.666 rows=0 loops=1)

  • Filter: (((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (valid_range @> '2019-09-18 21:46:50+00'::timestamp with time zone) AND (is_visible IS TRUE) AND (((first_name)::text ~~* '%is%'::text) OR ((last_name)::text ~~* '%is%'::text) OR ((target_name)::text ~~* '%is%'::text) OR ((web_login)::text ~~ '%is%'::text))) OR ((first_name)::text ~~* '%10%'::text) OR
  • Rows Removed by Filter: 2,392
169. 56.549 394.622 ↓ 1,813.0 152,288 5 / 5

Sort (cost=359.84..360.05 rows=84 width=16) (actual time=381.946..394.622 rows=152,288 loops=5)

  • Sort Key: tpr.person_uuid
  • Sort Method: quicksort Memory: 8,167kB
  • Worker 0: Sort Method: quicksort Memory: 8,167kB
  • Worker 1: Sort Method: quicksort Memory: 8,167kB
  • Worker 2: Sort Method: quicksort Memory: 8,167kB
  • Worker 3: Sort Method: quicksort Memory: 8,167kB
170. 10.067 338.073 ↓ 1,380.6 115,974 5 / 5

Nested Loop (cost=4.15..357.16 rows=84 width=16) (actual time=161.974..338.073 rows=115,974 loops=5)

171. 0.254 1.486 ↓ 15.0 15 5 / 5

Nested Loop (cost=0.84..193.13 rows=1 width=16) (actual time=0.283..1.486 rows=15 loops=5)

  • Join Filter: (spr.roles @> ((('["'::text || (rr.source_role_uuid)::text) || '"]'::text))::jsonb)
  • Rows Removed by Join Filter: 179
172. 0.002 0.069 ↑ 1.0 1 5 / 5

Append (cost=0.42..4.13 rows=1 width=42) (actual time=0.066..0.069 rows=1 loops=5)

173. 0.067 0.067 ↑ 1.0 1 5 / 5

Index Scan using person_roles_org_part_20_organization_uuid_person_uuid_sequ_idx on person_roles_org_part_20 spr (cost=0.42..4.12 rows=1 width=42) (actual time=0.065..0.067 rows=1 loops=5)

  • Index Cond: ((organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid) AND (person_uuid = '8ba6c978-5e01-4ca2-8496-bde271d81b72'::uuid))
  • Filter: upper_inf(valid_range)
  • Rows Removed by Filter: 1
174. 1.163 1.163 ↓ 4.1 194 5 / 5

Index Scan using role_on_role_organization_uuid_idx on role_on_role rr (cost=0.42..187.71 rows=47 width=32) (actual time=0.045..1.163 rows=194 loops=5)

  • Index Cond: (organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid)
  • Filter: ((can_edit_person OR can_view_person OR can_use_person) AND upper_inf(valid_range))
  • Rows Removed by Filter: 216
175. 8.445 326.520 ↓ 92.0 7,732 75 / 5

Append (cost=3.31..163.19 rows=84 width=58) (actual time=11.268..21.768 rows=7,732 loops=75)

176. 295.845 318.075 ↓ 92.0 7,732 75 / 5

Bitmap Heap Scan on person_roles_org_part_20 tpr (cost=3.31..162.77 rows=84 width=58) (actual time=11.264..21.205 rows=7,732 loops=75)

  • Recheck Cond: (roles @> ((('["'::text || (rr.target_role_uuid)::text) || '"]'::text))::jsonb)
  • Filter: (upper_inf(valid_range) AND (organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid))
  • Rows Removed by Filter: 8,032
  • Heap Blocks: exact=8,985
177. 22.230 22.230 ↓ 62.3 15,764 75 / 5

Bitmap Index Scan on person_roles_org_part_20_roles_idx (cost=0.00..3.28 rows=253 width=0) (actual time=1.482..1.482 rows=15,764 loops=75)

  • Index Cond: (roles @> ((('["'::text || (rr.target_role_uuid)::text) || '"]'::text))::jsonb)
178. 0.011 39.411 ↓ 0.0 0 5 / 5

Materialize (cost=8,738.25..8,738.26 rows=1 width=16) (actual time=39.411..39.411 rows=0 loops=5)

179. 0.010 39.400 ↓ 0.0 0 5 / 5

Sort (cost=8,738.25..8,738.25 rows=1 width=16) (actual time=39.400..39.400 rows=0 loops=5)

  • Sort Key: adm.person_uuid
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
  • Worker 2: Sort Method: quicksort Memory: 25kB
  • Worker 3: Sort Method: quicksort Memory: 25kB
180. 0.002 39.390 ↓ 0.0 0 5 / 5

Append (cost=0.00..8,738.24 rows=1 width=16) (actual time=39.390..39.390 rows=0 loops=5)

181. 39.388 39.388 ↓ 0.0 0 5 / 5

Seq Scan on person_roles_org_part_20 adm (cost=0.00..8,738.24 rows=1 width=16) (actual time=39.388..39.388 rows=0 loops=5)

  • Filter: (is_super_admin AND upper_inf(valid_range) AND (organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid))
  • Rows Removed by Filter: 252,949
182. 118.072 3,032.053 ↓ 4.1 343,577 1

Sort (cost=54,064.96..54,275.75 rows=84,316 width=16) (actual time=2,989.716..3,032.053 rows=343,577 loops=1)

  • Sort Key: pr.person_uuid
  • Sort Method: external sort Disk: 3,784kB
183. 2,708.822 2,913.981 ↓ 1.5 128,608 1

Nested Loop Left Join (cost=2.12..47,166.43 rows=84,316 width=16) (actual time=0.118..2,913.981 rows=128,608 loops=1)

  • Join Filter: (pr.roles @> ((('["'::text || (role.role_uuid)::text) || '"]'::text))::jsonb)
  • Rows Removed by Join Filter: 3,056,299
184. 8.901 78.252 ↓ 1.5 126,907 1

Append (cost=0.00..9,159.82 rows=84,316 width=58) (actual time=0.018..78.252 rows=126,907 loops=1)

185. 69.351 69.351 ↓ 1.5 126,907 1

Seq Scan on person_roles_org_part_20 pr (cost=0.00..8,738.24 rows=84,316 width=58) (actual time=0.018..69.351 rows=126,907 loops=1)

  • Filter: (upper_inf(valid_range) AND (organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid))
  • Rows Removed by Filter: 126,042
186. 126.849 126.907 ↓ 1.7 25 126,907

Materialize (cost=2.12..64.45 rows=15 width=16) (actual time=0.000..0.001 rows=25 loops=126,907)

187. 0.039 0.058 ↓ 1.7 25 1

Bitmap Heap Scan on roles role (cost=2.12..64.37 rows=15 width=16) (actual time=0.030..0.058 rows=25 loops=1)

  • Recheck Cond: (organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid)
  • Filter: upper_inf(valid_range)
  • Rows Removed by Filter: 25
  • Heap Blocks: exact=7
188. 0.019 0.019 ↓ 1.1 50 1

Bitmap Index Scan on roles_organization_uuid_idx (cost=0.00..2.12 rows=44 width=0) (actual time=0.019..0.019 rows=50 loops=1)

  • Index Cond: (organization_uuid = '57746a44-45a2-4b38-aeda-85b411de685b'::uuid)
Planning time : 191.706 ms
Execution time : 97,919.954 ms