Owen Nelson <onelson(at)gmail(dot)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