Re: Understanding the output of EXPLAIN ANALYSE
От
Greg Stark
Тема
Re: Understanding the output of EXPLAIN ANALYSE
Дата
Msg-id
407d949e0907231411u6c392854sa9169db7bd2c1eec@mail.gmail.com
Ответ на
Understanding the output of EXPLAIN ANALYSE (Thurber, Fred)
Список
Дерево обсуждения
Understanding the output of EXPLAIN ANALYSE "Thurber, Fred" <Fred.Thurber@gdit.com>
Re: Understanding the output of EXPLAIN ANALYSE Jaime Casanova <jcasanov@systemguards.com.ec>
Re: Understanding the output of EXPLAIN ANALYSE Greg Stark <gsstark@mit.edu>
Re: Understanding the output of EXPLAIN ANALYSE "Thurber, Fred" <Fred.Thurber@gdit.com>
Re: Understanding the output of EXPLAIN ANALYSE Andreas Wenk <a.wenk@netzmeister-st-pauli.de>
On Thu, Jul 23, 2009 at 6:14 PM, Thurber, Fred wrote: > "Nested Loop (cost=78.63..101.14 rows=1 width=256) (actual > time=0.000..16.000 rows=2818 loops=1)" Well it was expecting 1 row and got 2,818 so the costs are going to be pretty wildly wrong. But since you cut out all the details it's pretty hard to guess what happened. -- greg http://mit.edu/~gsstark/resume.pdf
В списке pgsql-novice по дате отправления
