Owen Nelson <onel...@gmail.com> writes: >> Are your ANALYZE stats up to date on this table?
> It's a very good question! Right now, I'm taking it on faith that > autovacuum and autoanalyze are keeping things up to date, but if I'm honest > I've been getting some conflicting information from pg_stat_user_tables and > I'm starting to suspect this might be an AWS Aurora quirk. Oh, you didn't say this was Aurora. Aurora is not really Postgres --- at least, my not-an-insider impression is that the storage engine is quite different. Not sure how much of the advice you got here is relevant to it. regards, tom lane