Re: Table scan on 15.2

From: Arthur Ramsey <arthur(dot)ramsey(at)code42(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Table scan on 15.2
Date: 2023-03-15 16:10:59
Message-ID: CAEJqy4UW=uo3z0NTU=ukTwKoUMSg1ViAWmwfA2BZ70vQ+TSY4w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2023-03-15 16:12:11 Re: How to behive if I remove password from postgres role
Previous Message Tom Lane 2023-03-15 16:03:22 Re: Table scan on 15.2