row estimate disaster

RU: катастрофа row estimate

A query plan failure caused by the PostgreSQL planner grossly misjudging the number of rows a node will produce. Misestimates typically occur when correlated column conditions are evaluated independently, leading the planner to choose a slow plan such as a nested loop over millions of rows instead of a hash join.