What does it mean? Plan stats and double rainbows.

From: Michael Moore <michaeljmoore(at)gmail(dot)com>
To: postgres list <pgsql-sql(at)postgresql(dot)org>
Subject: What does it mean? Plan stats and double rainbows.
Date: 2016-06-09 21:11:28
Message-ID: CACpWLjO4CG7qwcd9thirpSR5+YDHSmeYeSoefPeuXYSdBfCqKg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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".

Also, is there a way to tell the query planner to limit the search for the
best plan on a per statement basis. I know that this exists as a config
parameter but I think that applies to the entire database. I have a query
that takes 9 times more time to plan than it does to execute.

Tia,
Mike

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Kellerer 2016-06-09 21:52:05 Re: What does it mean? Plan stats and double rainbows.
Previous Message Michael Moore 2016-06-03 19:25:42 Re: NOT NULL CHECK (mycol !='') :good idea? bad idea?