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(at)comcast(dot)net