Cut and paste is your friend :)
If you are using psql, do \o foo and then explain....
-alex
On Fri, 22 Jun 2001, Josh Berkus wrote:
> Alex,
>
> > please do 'explain select * from yourview'
>
> I can't figure out how to get Explain to output to a file instead of the
> screen. Embarassing, I know, but the command seems to subbornly resist
> all command-line re-direction.
>
> >
> > also make sure all tables are vacuumed
>
> They are.
>
> -Josh
>
>