"Vyacheslav Kalinin" <vka@mgcp.com> writes:
> How come that outermost join expects 1515 rows given the row estimations of
> the inner and outer nested loop's parts?
I couldn't reproduce such a problem. What PG version are you running?
regards, tom lane