Re: Sort operation displays more tuples than it contains its subnode

2024-05-23 Thread Alena Rybakina
Yes, I got it. Thank you very much for the explanation. On 23.05.2024 00:17, Tom Lane wrote: "a.rybakina" writes: I faced the issue, when the sorting node in the actual information shows a larger number of tuples than it actually is. And I can not understand why? If I'm reading this correctly

Re: Sort operation displays more tuples than it contains its subnode

2024-05-22 Thread Tom Lane
"a.rybakina" writes: > I faced the issue, when the sorting node in the actual information  > shows a larger number of tuples than it actually is. And I can not > understand why? If I'm reading this correctly, the sort node you're worrying about feeds the inner side of a merge join. Merge join

Re: Sort operation displays more tuples than it contains its subnode

2024-05-22 Thread David Rowley
On Thu, 23 May 2024 at 08:48, a.rybakina wrote: >-> Sort (cost=613.48..632.86 rows=7754 width=8) (actual > time=7.612..21.214 rows=77531 loops=1) > Sort Key: broke_down_course.sno, broke_down_course.cno > Sort Method: quicksort Memory: