7k records into Sort node, 4.5m out?

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: 7k records into Sort node, 4.5m out?
Date: 2012-08-14 01:15:26
Message-ID: D2CA9292-023A-4DF4-82B8-6E99CE82CCB1@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 processing 7330 rows (the same number the Bitmap Heap Scan expected to produce)... but the sort is actually producing 4512231 rows, which the sort time would indicate is what really happened. How can this be?

--
-- Christophe Pettus
xof(at)thebuild(dot)com

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2012-08-14 01:35:21 Re: 7k records into Sort node, 4.5m out?
Previous Message Josh Berkus 2012-08-14 01:09:23 Re: Increasing WAL usage followed by sudden drop