After a restart and seq disabled for session with no other load (same for
plan with seq enabled).

 Bitmap Heap Scan on t_user user0_  (cost=19567.17..58623.03 rows=800678
width=761) (actual time=0.370..0.702 rows=36 loops=1)
   Recheck Cond: (upper((username)::text) = ANY ('{[redacted]'::text[]))
   Heap Blocks: exact=36
   ->  Bitmap Index Scan on idx_t_user__username__upper
 (cost=0.00..19364.50 rows=800678 width=0) (actual time=0.356..0.356
rows=36 loops=1)
         Index Cond: (upper((username)::text) = ANY ('{redacted}'::text[]))
 Planning Time: 1.187 ms
 Execution Time: 1.067 ms

Reply via email to