X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B87E753795 for ; Fri, 8 Apr 2005 02:30:16 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79484-07 for ; Fri, 8 Apr 2005 01:30:09 +0000 (GMT) Received: from biglumber.com (biglumber.com [207.228.252.42]) by svr1.postgresql.org (Postfix) with SMTP id A7D43529D4 for ; Fri, 8 Apr 2005 02:30:07 +0100 (BST) Received: (qmail 18568 invoked from network); 8 Apr 2005 01:30:10 -0000 Received: from unknown (HELO localhost) (207.228.252.42) by 0 with SMTP; 8 Apr 2005 01:30:10 -0000 From: "Greg Sabino Mullane" To: pgsql-performance@postgresql.org Subject: Re: help on explain analyse in psql 7.1.3 (linux) X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: <4254E604.90006@familyhealth.com.au> Date: Fri, 8 Apr 2005 01:30:10 -0000 X-Mailer: JoyMail 1.48 Message-ID: <6f7d87109a48cd84c74dda77a17f87b0@biglumber.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.224 tagged_above=0 required=5 tests=AWL, UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200504/175 X-Sequence-Number: 11572 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Christopher Kings-Lynne wrote: > Explain analyze was added in 7.2 - you really need to upgrade... > > You can use \timing in psql to get an approximation... Actually, \timing was not added until 7.2 either! So, the original poster really, really needs to upgrade... :) - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200504072129 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFCVd69vJuQZxSWSsgRAvRHAJ9T1uxfWEnHSNI/+iiiHiJ2I1IGUgCggMYb tjDwzfseK3aDAKHI5Ko1S/Q= =AvKY -----END PGP SIGNATURE-----