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

From: Martin Schäfer <Martin(dot)Schaefer(at)cadcorp(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: How to find out programmatically whether a query on a view will use an index?
Date: 2005-01-24 17:22:00
Message-ID: 37936EEC582B394A9E1AA951991A551609D276@dev001_pdc.Dev.cadcorp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message franco 2005-01-24 17:44:45 Re: update from multiple rows
Previous Message Kevin Duffy 2005-01-24 17:14:22 Moving from Transact SQL to PL/pgSQL