Re: effectiveness tool

From: Adrian Klaver <aklaver(at)comcast(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Cc: Judith Altamirano <jaltamirano(at)correolux(dot)com(dot)mx>
Subject: Re: effectiveness tool
Date: 2008-10-14 23:54:40
Message-ID: 200810141654.40924.aklaver@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)comcast(dot)net

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Scott Marlowe 2008-10-15 00:01:04 Re: effectiveness tool
Previous Message Judith Altamirano 2008-10-14 22:34:53 effectiveness tool