X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C461F52AF2 for ; Fri, 8 Jul 2005 13:08:10 -0300 (ADT) 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 91756-01 for ; Fri, 8 Jul 2005 16:08:08 +0000 (GMT) Received: from boutiquenumerique.com (boutiquenumerique.com [82.67.9.10]) by svr1.postgresql.org (Postfix) with ESMTP id 8F0BF5286A for ; Fri, 8 Jul 2005 13:08:05 -0300 (ADT) Received: (qmail 30741 invoked from network); 8 Jul 2005 18:08:32 +0200 Received: from unknown (HELO localhost) (boutiquenumerique-lists@192.168.0.4) by boutiquenumerique.com with SMTP; 8 Jul 2005 18:08:32 +0200 To: "Steve Wampler" , pgsql-sql@postgresql.org Subject: Re: Make COUNT(*) Faster? References: <9EF2931D-1097-470D-8ECB-59D00166C96F@apple.com> <60vf3mklue.fsf@dba2.int.libertyrms.com> <42CE89CA.2070607@noao.edu> <20050708143508.GD22725@wolff.to> <42CE96AF.3020903@noao.edu> <22916.1120836900@sss.pgh.pa.us> <42CEA305.1050904@noao.edu> Message-ID: Date: Fri, 08 Jul 2005 18:08:03 +0200 From: PFC Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?= Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit In-Reply-To: <42CEA305.1050904@noao.edu> User-Agent: Opera M2/8.0 (Linux, build 1095) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/81 X-Sequence-Number: 22059 > which wouldn't have helped.) If true, I can handle that parsing myself > easily enough without exposing RelationGetNumberOfBlocks. Is there a way to get EXPLAIN results in a non-text-formatted way for easier use ? I'm asking, because it seems the feature set grows by the minute in posgres nowadays...