Sort returns more rows than seq scan?

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Sort returns more rows than seq scan?
Date: 2016-03-01 14:15:06
Message-ID: CAFj8pRAtegy_7o=0rmGLQUv8Nu08mXi7GxGAjsAYumxemvo4bA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

I don't understand how is possible to get more rows from Sort node than in
nested seq scan?

http://explain.depesz.com/s/568O

Sec scan returns 1.6M rows, Sort returns 2.7M rows

Regards

Pavel

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Craig Ringer 2016-03-01 14:25:01 Re: Equivalent of --enable-tap-tests in MSVC scripts
Previous Message Jim Nasby 2016-03-01 14:09:09 Re: WIP: Upper planner pathification