Re: Noobie: Problems with a query

On Mon, Jun 30, 2003 at 08:42:07 -0500,
Chris Boget <chris(at)wild(dot)net> wrote:
>
> so 'EXPLAIN ANALYZE your_query' gives more information that just EXPLAIN?

Yes. It sort of runs the query so that you find out how long it actually
takes to run as well as seeing the actual number of rows handled in some
steps. This helps tell why a plan didn't work very well.

> In any case, I did 'vacuum' and 'vacuum analyze' there but neither seemed to
> improve matters. However, this morning, after I did 'vacuum analyze' from
> the PG command prompt, I re-ran the query and the rows came back in
> milliseconds. I'll have to see if the rows come back that quickly in pgAdmin
> and, if it does, that tells me there is something wrong with the way pgAdmin
> does the 'vacuum' and 'vacuum analyze'. If the rows don't come back that
> fast, then it'll tell me that there is *alot* of overhead when using pgAdmin to
> run queries.

It seems odd that vacuum analyze didn't work form pgadmin. Perhaps it
wasn't run against all of the tables or you ran it before loading the
tables.