X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 55E64D1B8D3 for ; Tue, 26 Aug 2003 03:46:15 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 04626-04 for ; Tue, 26 Aug 2003 03:45:41 -0300 (ADT) Received: from cerebro.int-bytecraft.com (unknown [219.93.229.26]) by svr1.postgresql.org (Postfix) with ESMTP id 31A3BD1B8A5 for ; Tue, 26 Aug 2003 03:45:38 -0300 (ADT) Received: from bytecraft.com.my (home.int-bytecraft.com [127.0.0.1]) by cerebro.int-bytecraft.com (8.11.6/8.11.6) with ESMTP id h7Q6i4O16998; Tue, 26 Aug 2003 14:44:16 +0800 Message-ID: <3F4B02ED.4080704@bytecraft.com.my> Date: Tue, 26 Aug 2003 14:49:17 +0800 From: Ang Chin Han User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Stephan Szabo Cc: Rhaoni Chiu Pereira , PostgreSQL Performance Subject: Re: Query too slow References: <20030825083343.H90125-100000@megazone.bigpanda.com> In-Reply-To: <20030825083343.H90125-100000@megazone.bigpanda.com> X-Enigmail-Version: 0.76.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig5822A8680F096BFD16C2E4ED" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/332 X-Sequence-Number: 3148 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig5822A8680F096BFD16C2E4ED Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Stephan Szabo wrote: > Looking at the explain: Veering aside a bit, since we usually pinpoint performance problems by looking at EXPLAIN ANALYZE's differences between the planner's estimation and actual execution's stats, what's involved in parsing the EXPLAIN ANALYZE results, and highlighting the places where they are way different? Bold, underline, or put some asterisks in front of those steps. Makes looking at big EXPLAIN ANALYZE trees much easier. -- Linux homer 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux 2:30pm up 243 days, 5:48, 8 users, load average: 5.52, 5.29, 5.10 --------------enig5822A8680F096BFD16C2E4ED Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE/SwLwNYbTUIgzwfARArG3AKCghYFWM/ukKYCQcXM1swDVeF9eqwCfUU4y +BJdOjxn5YOslSBfC4m+rQc= =Nw+o -----END PGP SIGNATURE----- --------------enig5822A8680F096BFD16C2E4ED--