On Fri, June 3, 2011 13:57, tv(at)fuzzy(dot)cz wrote:
> See this http://explain.depesz.com/s/THh
>
>
> There's something very wrong with snames - the planner expects 22 rows but
> gets 164147851. Which probably causes a bad plan choice or something like that.
> Try to analyze the snames table (and maybe increase the statistics
> target on the columns).
Thanks - like you say, looks like the interesting bit is:
rows=22 --> rows=164147851 for table snames.
Nice online tool you have there my china!
Cheers
Henry