7k records into Sort node, 4.5m out? - Mailing list pgsql-performance

From Christophe Pettus
Subject 7k records into Sort node, 4.5m out?
Date
Msg-id D2CA9292-023A-4DF4-82B8-6E99CE82CCB1@thebuild.com
Whole thread Raw
Responses Re: 7k records into Sort node, 4.5m out?
List pgsql-performance
Consider this EXPLAIN ANALYZE output:

    http://explain.depesz.com/s/TCi

Note the Bitmap Heap Scan at the bottom claims to be producing 7094 rows, and the Sort above it expects to be
processing7330 rows (the same number the Bitmap Heap Scan expected to produce)... but the sort is actually producing
4512231rows, which the sort time would indicate is what really happened.  How can this be? 

--
-- Christophe Pettus
   xof@thebuild.com



pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Increasing WAL usage followed by sudden drop
Next
From: "Tomas Vondra"
Date:
Subject: Re: 7k records into Sort node, 4.5m out?