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

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Thomas KellererDate: 2012-03-30 11:31:47
Subject: Re: EXPLAIN explanation
Previous:From: Binand SethumadhavanDate: 2012-03-30 10:56:57
Subject: EXPLAIN explanation

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