Postgres Pro
Downloads
Home   >   mailing lists

Re: How to find out programmatically whether a query on a view will use an index? - Mailing list pgsql-sql

From Tom Lane
Subject Re: How to find out programmatically whether a query on a view will use an index?
Date
Msg-id 22476.1106586762@sss.pgh.pa.us
Whole thread Raw
In response to How to find out programmatically whether a query on a view will use an index?  (Martin Schäfer <Martin.Schaefer@cadcorp.com>)
List pgsql-sql
Tree view 
Martin Schäfer <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

pgsql-sql by date:

Previous
From: Martin Schäfer
Date:
Subject: How to find out programmatically whether a query on a view will use an index?
Next
From: Martin Schäfer
Date:
Subject: Re: How to find out programmatically whether a query on a view will use an index?