Re: explain - Mailing list pgsql-sql

From A.Bhuvaneswaran
Subject Re: explain
Date
Msg-id Pine.LNX.4.44.0303211835130.2317-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to Re: explain  (Popeanga Marian <pmarian@cnlo.ro>)
List pgsql-sql
> > Hello all,
> >
> >
> >            Can someone point me how can i make explain plan for a query?
> 
> I don't want this for pgsql, but from any other tool that connects to 
> postgres.

7.2.x and earlier:

The result of explain query is printed in STDERR, just like any other
notice message.

7.3:

The result is returned like a value returned from a function. 

regards,
bhuvaneswaran



pgsql-sql by date:

Previous
From: Popeanga Marian
Date:
Subject: Re: explain
Next
From: Eric Veldhuyzen
Date:
Subject: cast of integer to bool doesn't work (anymore?)