Re: How to find out programmatically whether a query on a view will use an index?
This is a discussion on Re: How to find out programmatically whether a query on a view will use an index? within the pgsql Sql forums, part of the PostgreSQL category; --> =?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 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 11:52 AM
| ||||
| ||||
 Re: How to find out programmatically whether a query on a view will use an index? =?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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster      |
Linear Mode
