Michael Guerin <guerin@rentec.com> writes:
> I'm trying to understand why the row count is way off, setting the statistics_target higher seems to make it worse.
This is not a row count estimate, it's just ANALYZE telling you how many
rows it sampled to prepare the pg_stats statistics.
regards, tom lane