On Tue, Feb 21, 2023 at 10:30 AM Arthur Ramsey <arthur.ramsey@xxxxxxxxxx> 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)
