On Wed, Sep 03, 2003 at 23:19:24 -0700, Ringo <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Dinar <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
