Postgres Pro
Downloads
Home   >   mailing lists

Re: Question on Sort node's actual rows - Mailing list pgsql-general

From Tom Lane
Subject Re: Question on Sort node's actual rows
Date
Msg-id 11764.1390489203@sss.pgh.pa.us
Whole thread Raw
In response to Question on Sort node's actual rows  (Victor Yegorov <vyegorov@gmail.com>)
List pgsql-general
Tree view 
Victor Yegorov <vyegorov@gmail.com> writes:
> I'm looking at a plan: http://explain.depesz.com/s/sPv

> And I have a question. Why in the following snippet `Sort` node
> reports 128818 rows, although
> child node returned only 352?

It's under a mergejoin, which evidently is rescanning its right input
a lot due to duplicate join keys in the left input.

            regards, tom lane

pgsql-general by date:

Previous
From: Andreas Lubensky
Date:
Subject: Prepared statements and cursors
Next
From: Bill Moran
Date:
Subject: Help with details of what happens when I create a constraint NOT VALID