explain EXPLAIN?

From: David Olbersen <dave(at)slickness(dot)org>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: explain EXPLAIN?
Date: 2001-03-08 23:20:08
Message-ID: Pine.LNX.4.31.0103081517580.31922-100000@bubbles.electricutopia.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,
I'm looking for a better tutorial of how EXPLAIN works. I know Mr. Tom Lane
wrote a "quick & dirty explanation" and that "plan-reading is an art that
deserves a tutorial, and I haven't had time to write one". In which case I'd
like to know 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 any suggestions?

-- Dave

Browse pgsql-sql by date

  From Date Subject
Next Message Kyle 2001-03-09 00:21:22 Re: A query that doesn't work on 7.1
Previous Message Najm Hashmi 2001-03-08 22:54:38 quotes in pl/pgsql