On Tue, Feb 21, 2023 at 10:30 AM Arthur Ramsey <arthur.ramsey@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
REINDEXdidn't help. This is on an RDS instance that's a db.m5.large (2 * vCPU, 8 GB memory) with 200 storage on io1
with10000 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)
