Skip site navigation (1) Skip section navigation (2)

Thanks for explaining EXPLAIN

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: (view raw, whole thread or download thread mbox)
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.

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

seapug by date

Next:From: Albin, Lloyd PDate: 2010-08-06 23:39:40
Subject: Postgres Users Group Meeting
Previous:From: Albin, Lloyd PDate: 2010-07-13 21:26:22
Subject: Re: Meeting tonight? (Tuesday 2010-07-13)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group