Re: How to find out programmatically whether a query on a view will use an index?

Поиск
Список
Период
Сортировка
От Martin Schäfer
Тема Re: How to find out programmatically whether a query on a view will use an index?
Дата
Msg-id 37936EEC582B394A9E1AA951991A551609D276@dev001_pdc.Dev.cadcorp.net
обсуждение исходный текст
Ответ на How to find out programmatically whether a query on a view will use an index?  (Martin Schäfer <Martin.Schaefer@cadcorp.com>)
Список pgsql-sql
Дерево обсуждения 
> > 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How to find out programmatically whether a query on a view will use an index?
Следующее
От: franco
Дата:
Сообщение: Re: update from multiple rows