Add indexes to improve performance

create index on fs00001000_mod_users.users using gin (to_tsvector('simple', f_unaccent(jsonb ->> 'patronGroup')));
SELECT COUNT(*) FROM fs00001000_mod_users.users WHERE to_tsvector('simple', f_unaccent(users.jsonb->>'patronGroup')) @@ to_tsquery('simple', f_unaccent('ad0bc554-d5bc-463c-85d1-5562127ae91b'));
319.702 ms vs 0.110 ms

create index on fs00001000_mod_users.users using gin (to_tsvector('simple', f_unaccent(jsonb ->> 'barcode')));
SELECT COUNT(*) FROM fs00001000_mod_users.users WHERE to_tsvector('simple', f_unaccent(users.jsonb->>'barcode')) @@ to_tsquery('simple', f_unaccent('299308637069604'));
129.645 ms vs 0.035 ms

create index on fs00001000_mod_users.users using gin (to_tsvector('simple', f_unaccent(jsonb ->> 'username')));
SELECT COUNT(*) FROM fs00001000_mod_users.users  WHERE to_tsvector('simple', f_unaccent(users.jsonb->>'username')) @@ to_tsquery('simple', f_unaccent('JMPajerek'))
109.786 ms vs 

create index on fs00001000_mod_users.users (lower(f_unaccent(jsonb -> 'personal' ->> 'firstName')));
create index on fs00001000_mod_users.users (lower(f_unaccent(jsonb -> 'personal' ->> 'lastName')));
SELECT * FROM fs00001000_mod_users.users  WHERE to_tsvector('simple', f_unaccent(users.jsonb->>'active')) @@ to_tsquery('simple', f_unaccent('true')) ORDER BY lower(f_unaccent(users.jsonb->'personal'->>'lastName')), lower(f_unaccent(users.jsonb->'personal'->>'firstName')) LIMIT 30 OFFSET 30;
155.960 ms vs 

create index on fs00001000_mod_users.users using gin (to_tsvector('simple', f_unaccent(jsonb -> 'personal' ->> 'firstName')));
create index on fs00001000_mod_users.users using gin (to_tsvector('simple', f_unaccent(jsonb -> 'personal' ->> 'lastName')));
create index on fs00001000_mod_users.users using gin (to_tsvector('simple', f_unaccent(jsonb -> 'personal' ->> 'email')));
create index on fs00001000_mod_users.users using gin (to_tsvector('simple', f_unaccent(jsonb ->> 'externalSystemId')));
create index on fs00001000_mod_users.users using gin (to_tsvector('simple', f_unaccent(jsonb ->> 'active')));
SELECT COUNT(*) FROM fs00001000_mod_users.users  WHERE ((((((to_tsvector('simple', f_unaccent(users.jsonb->>'username')) @@ to_tsquery('simple', f_unaccent('emelianov:*'))) OR (to_tsvector('simple', f_unaccent(users.jsonb->'personal'->>'firstName')) @@ to_tsquery('simple', f_unaccent('emelianov:*')))) OR (to_tsvector('simple', f_unaccent(users.jsonb->'personal'->>'lastName')) @@ to_tsquery('simple', f_unaccent('emelianov:*')))) OR (to_tsvector('simple', f_unaccent(users.jsonb->'personal'->>'email')) @@ to_tsquery('simple', f_unaccent('emelianov:*')))) OR (to_tsvector('simple', f_unaccent(users.jsonb->>'barcode')) @@ to_tsquery('simple', f_unaccent('emelianov:*')))) OR (false /* id == invalid UUID */)) OR (to_tsvector('simple', f_unaccent(users.jsonb->>'externalSystemId')) @@ to_tsquery('simple', f_unaccent('emelianov:*')));
910.729 ms vs 0.107 ms