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 Martin Schäfer
Subject Re: How to find out programmatically whether a query on a view will use an index?
Date
Msg-id 37936EEC582B394A9E1AA951991A551609D276@dev001_pdc.Dev.cadcorp.net
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 
> > 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.

How about a list of the indices used in a query? That alone would
already be very useful.

Martin

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to find out programmatically whether a query on a view will use an index?
Next
From: franco
Date:
Subject: Re: update from multiple rows