| From: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
|---|---|
| To: | "Braud Agnes" <Agnes(dot)Braud(at)lifo(dot)univ-orleans(dot)fr> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Using the EXPLAIN results |
| Date: | 2002-05-24 18:42:48 |
| Message-ID: | 20020524144248.32aaa382.nconway@klamath.dyndns.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 24 May 2002 20:26:39 +0200
"Braud Agnes" <Agnes(dot)Braud(at)lifo(dot)univ-orleans(dot)fr> wrote:
> Hi
>
> I am using the libpq library, and I would like to get the plan
> returned by the explain command for a given query to decide
> if I execute the query or not. I want to get the time predicted
> by the optimizer for the execution of the query.
> Is it possible to get the plan as a string in a C or C++ program ?
In 7.3, EXPLAIN results are returned as a result set -- so then it
should be easy to use within a program.
Prior to that, you can use PQsetNoticeProcessor().
Cheers,
Neil
--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Conway | 2002-05-24 18:44:29 | Re: Question on crypt password |
| Previous Message | Braud Agnes | 2002-05-24 18:26:39 | Using the EXPLAIN results |