Question on Sort node's actual rows

From: Victor Yegorov <vyegorov(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Question on Sort node's actual rows
Date: 2014-01-23 13:57:21
Message-ID: CAGnEbojZBC44gXzgUZ0zJMwyEXjjbysrenTJayDrbPdBafrbcA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings.

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?

"-> Sort (cost=37.06..37.94 rows=352 width=20) (actual time=4.441..16.971
rows=128818 loops=1)
" Sort Key: ts.currency
" Sort Method: quicksort Memory: 52kB
" Buffers: shared hit=13
" -> Seq Scan on transaction_slip ts (cost=0.00..22.18 rows=352
width=20) (actual time=0.041..4.035 rows=352 loops=1)
" Filter: (account_id = 101)
" Rows Removed by Filter: 382
" Buffers: shared hit=13

This is:
PostgreSQL 9.3.1 on x86_64-apple-darwin12.5.0, compiled by
i686-apple-darwin11-llvm-gcc-4.2 (GCC) 4.2.1 (Based on Apple Inc. build
5658) (LLVM build 2336.11.00), 64-bit

--
Victor Y. Yegorov

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Lubensky 2014-01-23 14:31:15 Prepared statements and cursors
Previous Message Bill Moran 2014-01-23 13:46:11 Help with details of what happens when I create a constraint NOT VALID