On Tue, Feb 21, 2023 at 10:30 AM Arthur Ramsey <arthur.ram...@code42.com> wrote:
>
> I'm trying to figure out why a sequential scan is out performing.  I've tried 
> psql 13.7, psql14.6 and REINDEX.  The REINDEX didn't help.  This is on an RDS 
> instance that's a db.m5.large (2 * vCPU, 8 GB memory) with 200 storage on io1 
> with 10000 provisioned IOPS.  I restarted the RDS instance in between each 
> test.
>

At glance, it seems there are very few rows to operate on:

-> Seq Scan on t_status_175000000_176000000 t_status_39
(cost=0.00..13.80 rows=380 width=14) (actual time=0.009..0.010 rows=0
loops=1)


Reply via email to