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 9143052ADA for ; Fri, 8 Jul 2005 16:51:33 -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 83833-09 for ; Fri, 8 Jul 2005 19:51:28 +0000 (GMT) Received: from mr1.surnet.cl (smtp1.surnet.cl [216.155.73.162]) by svr1.postgresql.org (Postfix) with ESMTP id 5A960529C8 for ; Fri, 8 Jul 2005 16:51:27 -0300 (ADT) Received: from smtp1.surnet.cl (216.155.73.168) by mr1.surnet.cl (7.0.031.3) id 42587EDE013FF25B; Fri, 8 Jul 2005 15:50:45 -0400 Received: from smtp2.surnet.cl (smtp2.surnet.cl []) by mr1.surnet.cl ([216.155.73.168]); Fri, 08 Jul 2005 19:50:45 +0000 Received: from cluster.surnet.cl (216.155.73.164) by smtp2.surnet.cl (7.0.031.3) id 4259ADE300C4107C; Fri, 8 Jul 2005 15:51:09 -0400 Received: from alvh.no-ip.org (216.155.85.95) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 42B3EF60002E7E39; Fri, 8 Jul 2005 15:51:21 -0400 Received: by alvh.no-ip.org (Postfix, from userid 1000) id D247EC2DC70; Fri, 8 Jul 2005 15:51:25 -0400 (CLT) Date: Fri, 8 Jul 2005 15:51:25 -0400 From: Alvaro Herrera To: PFC Cc: Steve Wampler , pgsql-sql@postgresql.org Subject: Re: Make COUNT(*) Faster? Message-ID: <20050708195125.GI1915@alvh.no-ip.org> 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> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.789 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200507/90 X-Sequence-Number: 22068 On Fri, Jul 08, 2005 at 06:08:03PM +0200, PFC wrote: > > > >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... Not yet, but a friend of mine was working on a patch to make it output in a custom XML format, to be able to create a tool similar to Redhat's Visual Explain. I expect he will show up in pgsql-hackers sometime ... In spanish: http://www.ubiobio.cl/~gpoo/weblog/archives/000397.html -- Alvaro Herrera () "Find a bug in a program, and fix it, and the program will work today. Show the program how to find and fix a bug, and the program will work forever" (Oliver Silfridge)