Postgres Pro
Downloads
Home   >   mailing lists

Re: Table scan on 15.2 - Mailing list pgsql-general

From Arthur Ramsey
Subject Re: Table scan on 15.2
Date
Msg-id CAEJqy4UW=uo3z0NTU=ukTwKoUMSg1ViAWmwfA2BZ70vQ+TSY4w@mail.gmail.com
Whole thread Raw
In response to Re: Table scan on 15.2  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Table scan on 15.2  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Table scan on 15.2
Next
From: Adrian Klaver
Date:
Subject: Re: How to behive if I remove password from postgres role