Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 814309FB548 for ; Tue, 12 Jun 2007 10:53:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 33171-08 for ; Tue, 12 Jun 2007 10:53:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from oxford.xeocode.com (unknown [62.232.55.118]) by postgresql.org (Postfix) with ESMTP id B6E6B9FB2DE for ; Tue, 12 Jun 2007 10:53:33 -0300 (ADT) Received: from localhost ([127.0.0.1] helo=oxford.xeocode.com) by oxford.xeocode.com with esmtp (Exim 4.67) (envelope-from ) id 1Hy6oI-0006hc-NF; Tue, 12 Jun 2007 14:53:26 +0100 From: Gregory Stark To: "Christo Du Preez" Cc: Subject: Re: test / live environment, major performance difference In-Reply-To: <466EA078.20601@mecola.com> (Christo Du Preez's message of "Tue, 12 Jun 2007 15:32:40 +0200") Organization: EnterpriseDB References: <466EA078.20601@mecola.com> X-Draft-From: ("nnimap+mail01.enterprisedb.com:INBOX.performance" 944) Date: Tue, 12 Jun 2007 14:53:26 +0100 Message-ID: <871wghgtyh.fsf@oxford.xeocode.com> User-Agent: Gnus/5.110006 (No Gnus v0.6) Emacs/21.4 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/204 X-Sequence-Number: 25237 "Christo Du Preez" writes: > On my laptop the explain analyze looks like this: > > "Index Scan using fki_layertype_parentid on layertype (cost=0.00..8.27 > rows=1 width=109)" > " Index Cond: (parentid = 300)" That's not "explain analyze", that's just plain "explain". -- Gregory Stark EnterpriseDB http://www.enterprisedb.com