On Wed, Sep 03, 2003 at 23:19:24 -0700,
Ringo <no@email.com> wrote:
> What a prick..
From observing Tom's responses here, I think this is a real question (not
an RTFM response). If the documentation doesn't make it clear to new readers
that explain analyze does execute the query (though doesn't return the
results), then the documentation needs to get fixed.
>
> "Tom Lane" <tgl@sss.pgh.pa.us> wrote in message
> news:25792.1062510815@sss.pgh.pa.us...
> > Dinar <dinar@yantel.ru> writes:
> > > I thought that explain analyze doesn't execute query
> >
> > You thought wrong. Is the manual's explanation not clear enough?
> >
> > regards, tom lane
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 9: the planner will ignore your desire to choose an index scan if your
> > joining column's datatypes do not match
> >
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster