From: | Basil Bourque <basil(dot)list(at)me(dot)com> |
---|---|
To: | seapug(at)postgresql(dot)org |
Subject: | Thanks for explaining EXPLAIN |
Date: | 2010-07-14 23:11:33 |
Message-ID: | D29EA764-304C-4FAB-BB82-CEF0D1A47F31@me.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | seapug |
Thanks to Andrew Nierman for his interesting talk yesterday on query planner, EXPLAIN command, and such.
Today I noticed that v9 will provide a machine-readable version of EXPLAIN. That should make it even easier to study and test the query planner/optimizer.
http://www.commandprompt.com/blogs/
----
EXPLAIN now machine-readable
This is an amazingly useful feature, especially when combined with auto_explain - you'll now be able to get explain output in XML, JSON or YAML, allowing for easy parsing, manipulation and comparison of the EXPLAIN output.
This also allows for transformation of the output - easily converting it to HTML, for instance. Easy comparison before and after an index is created, simplifying programmatic discovery of indexes.
----
--Basil Bourque
From | Date | Subject | |
---|---|---|---|
Next Message | Albin, Lloyd P | 2010-08-06 23:39:40 | Postgres Users Group Meeting |
Previous Message | Albin, Lloyd P | 2010-07-13 21:26:22 | Re: Meeting tonight? (Tuesday 2010-07-13) |