| 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: | Whole Thread | Raw Message | 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
| 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? |