explain EXPLAIN? - Mailing list pgsql-sql

From David Olbersen
Subject explain EXPLAIN?
Date
Msg-id Pine.LNX.4.31.0103081517580.31922-100000@bubbles.electricutopia.net
Whole thread Raw
List pgsql-sql
Hello, I'm looking for a better tutorial of how EXPLAIN works. I know Mr. Tom Lane wrote a "quick & dirty explanation"
andthat "plan-reading is an art that deserves a tutorial, and I haven't had time to write one". In which case I'd like
toknow if there's any other tutorials/resources.
 
 I think I get the jist of it (an index scan is better than a seq scan?) but I'd like to read more. Does anybody have
anysuggestions?
 

-- Dave



pgsql-sql by date:

Previous
From: Michael Davis
Date:
Subject: Access tables inside pl/pgsql functions
Next
From: Kyle
Date:
Subject: Re: A query that doesn't work on 7.1