Re: effectiveness tool - Mailing list pgsql-sql

On Tuesday 14 October 2008 3:34:53 pm Judith Altamirano wrote:
> Hello everybody!!
>
>    I just want to know if there be some tool to analize the performance
> of a query, I mean to qualify the effectiveness, speed, if I have the
> correct indexes.
>
>    Hope somebody can help me....
>
>   Thanks in advanced!!

Take a look at:
http://www.postgresql.org/docs/8.3/interactive/sql-explain.html
and:
http://www.postgresql.org/docs/8.3/interactive/using-explain.html
-- 
Adrian Klaver
aklaver@comcast.net