Re: Join query on 1M row table slow - Mailing list pgsql-general

On Tue, 10 Feb 2004, CSN wrote:

> > 2. Vacuum analyze the tables concerned and post the
> > output of EXPLAIN ANALYSE
> > with your query.
>
> => explain analyze;
>
> results in:
>
> ERROR:  syntax error at or near ";" at character 16

No silly.  you do:

explain analyze select ... (rest of the query...)

and it runs the query and tells you how long each bit took and what it
THOUGHT it would get back in terms of number of rows and what it actually
got back.

Let us know...