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 [EMAIL PROTECTED] -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql