Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> I'm afraid I'll have to defer to someone else (Tom?) as why the estimate was
> out by three orders of magnitude.
I'd like to know that, too.
> I'd suggest playing around with statistics and seeing if you can work out
> why they were so bad.
Could we see the pg_stats row for the ip_saddr column? Also, does the
estimate get better if you increase the stats target for ip_saddr and
re-analyze?
regards, tom lane