EXPLAIN explanation

From: Binand Sethumadhavan <binand(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: EXPLAIN explanation
Date: 2012-03-30 11:09:29
Message-ID: CAFBJCCY4XrsXN7XWSTLdYRK=p4k10p6=uwO1L_3SpnQSb42F6w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Is there a comprehensive online document or printed book that explains
the EXPLAIN output? Something akin to the MySQL documentation here:

http://dev.mysql.com/doc/refman/5.1/en/explain-output.html

I would really like to know what EXPLAIN is telling me, and more
importantly, what it is not telling me. I have read some documents,
but none that breaks it down to pieces and explains each piece
separately.

TIA.

Binand

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Thomas Kellerer 2012-03-30 11:31:47 Re: EXPLAIN explanation
Previous Message Binand Sethumadhavan 2012-03-30 10:56:57 EXPLAIN explanation