Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 118529FB36F for ; Wed, 4 Oct 2006 10:47:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 01149-10 for ; Wed, 4 Oct 2006 10:47:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.libertyrms.com (vgateway.libertyrms.info [207.219.45.62]) by postgresql.org (Postfix) with ESMTP id 449EE9FB31C for ; Wed, 4 Oct 2006 10:47:09 -0300 (ADT) Received: from dba5.int.libertyrms.com ([10.1.3.44]) by mail.libertyrms.com with esmtp (Exim 4.22) id 1GV75W-0002UX-1r; Wed, 04 Oct 2006 09:47:06 -0400 Subject: Re: PostgreSQL Caching From: Brad Nicholson To: Dave Dutcher Cc: 'Adnan DURSUN' , pgsql-performance@postgresql.org In-Reply-To: <008701c6e7b1$ee763630$8300a8c0@tridecap.com> References: <008701c6e7b1$ee763630$8300a8c0@tridecap.com> Content-Type: text/plain Date: Wed, 04 Oct 2006 09:47:05 -0400 Message-Id: <1159969625.15773.19.camel@dba5.int.libertyrms.com> Mime-Version: 1.0 X-Mailer: Evolution 2.6.2 (2.6.2-1.fc5.5) Content-Transfer-Encoding: 7bit X-SA-Exim-Mail-From: bnichols@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.255 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200610/83 X-Sequence-Number: 21212 On Wed, 2006-10-04 at 07:38 -0500, Dave Dutcher wrote: > > -----Original Message----- > > From: pgsql-performance-owner@postgresql.org > > [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of > > Adnan DURSUN > > i want to be can read an execution plan when > > i look at it. > > So, is there any doc about how it should be read ? > > > You are asking how to read the output from EXPLAIN? This page is a good > place to start: > > http://www.postgresql.org/docs/8.1/interactive/performance-tips.html Robert Treat's Explaining Explain presentation from OSCON is also very good: http://redivi.com/~bob/oscon2005_pgsql_pdf/OSCON_Explaining_Explain_Public.pdf#search=%22%22explaining%20explain%22%22 Brad.