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 E45053A553B for ; Mon, 24 Jan 2005 17:12:53 +0000 (GMT) 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 66681-06 for ; Mon, 24 Jan 2005 17:12:50 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 5D96E3A5513 for ; Mon, 24 Jan 2005 17:12:49 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j0OHChoQ022477; Mon, 24 Jan 2005 12:12:43 -0500 (EST) To: =?iso-8859-1?Q?Martin_Sch=E4fer?= Cc: pgsql-sql@postgresql.org Subject: Re: How to find out programmatically whether a query on a view will use an index? In-reply-to: <37936EEC582B394A9E1AA951991A551609D274@dev001_pdc.Dev.cadcorp.net> References: <37936EEC582B394A9E1AA951991A551609D274@dev001_pdc.Dev.cadcorp.net> Comments: In-reply-to =?iso-8859-1?Q?Martin_Sch=E4fer?= message dated "Mon, 24 Jan 2005 16:34:09 +0000" Date: Mon, 24 Jan 2005 12:12:42 -0500 Message-ID: <22476.1106586762@sss.pgh.pa.us> From: Tom Lane 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: 200501/210 X-Sequence-Number: 19998 =?iso-8859-1?Q?Martin_Sch=E4fer?= writes: > Using 'EXPLAIN SELECT ...' does tell me whether the spatial index is used, > but the output is not machine readable. I guess the output is localized to > the current locale, AFAIK it's not localized, so grepping for "Index" would probably work. > Is there no way to get a machine readable query plan? No, and no such API is likely to be defined in the future either, because we reserve the right to change plan structures at any time. regards, tom lane