7k records into Sort node, 4.5m out?

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема 7k records into Sort node, 4.5m out?
Дата
Msg-id D2CA9292-023A-4DF4-82B8-6E99CE82CCB1@thebuild.com
обсуждение исходный текст
Ответы Re: 7k records into Sort node, 4.5m out?  ("Tomas Vondra" <tv@fuzzy.cz>)
Список 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 по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Increasing WAL usage followed by sudden drop
Следующее
От: "Tomas Vondra"
Дата:
Сообщение: Re: 7k records into Sort node, 4.5m out?