To: pgsql-sql@postgresql.org
From: Thomas Kellerer <spam_eater@gmx.net>
Subject: Re: What does it mean? Plan stats and double rainbows.
Date: Thu, 9 Jun 2016 23:52:05 +0200
Lines: 10
Message-ID: <njcoee$oma$1@ger.gmane.org>
References: 
 <CACpWLjO4CG7qwcd9thirpSR5+YDHSmeYeSoefPeuXYSdBfCqKg@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21)
 Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666
In-Reply-To: 
 <CACpWLjO4CG7qwcd9thirpSR5+YDHSmeYeSoefPeuXYSdBfCqKg@mail.gmail.com>
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

Michael Moore schrieb am 09.06.2016 um 23:11:
> I'm having a difficult time finding documentation on EXPLAIN PLAN stats. For example, in
> '                    ->  Nested Loop Left Join  (cost=0.43..1415.06 rows=2 width=1377) (actual time=0.093..0.093 rows=0 loops=1)'
> what does 0.43..1415.06 mean? Is that a range?
>If so, it seems rather pointless, like saying "somewhere between 0 and infinity".

https://www.postgresql.org/docs/current/static/using-explain.html#USING-EXPLAIN-BASICS
  

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql