From: Tom Lane <tgl@sss.pgh.pa.us>
To: Martin Schäfer <Martin.Schaefer@cadcorp.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: How to find out programmatically whether a query on a view will use an index?
Date: Mon, 24 Jan 2005 12:12:42 -0500
Message-ID: <22476.1106586762@sss.pgh.pa.us> (raw)
In-Reply-To: <37936EEC582B394A9E1AA951991A551609D274@dev001_pdc.Dev.cadcorp.net>
References: <37936EEC582B394A9E1AA951991A551609D274@dev001_pdc.Dev.cadcorp.net>
=?iso-8859-1?Q?Martin_Sch=E4fer?= <Martin.Schaefer@cadcorp.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, Martin.Schaefer@cadcorp.com
Subject: Re: How to find out programmatically whether a query on a view will use an index?
In-Reply-To: <22476.1106586762@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox