Tim Uckun <timuckun(at)gmail(dot)com> writes:
> relname | pg_relation_size | reltuples | relpages
> ------------------------+------------------+-------------+----------
> consolidated_urls | 1303060480 | 1.80192e+06 | 159065
> consolidated_urls_pkey | 114745344 | 1.80192e+06 | 14007
With a table that large, you're probably going to need a larger stats
target in order to get reasonable estimates for low-frequency values.
Am I right in guessing that pg_stats.n_distinct is much too low for
the domain_id column?
regards, tom lane