Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

Next:From: Scott MarloweDate: 2008-10-15 00:01:04
Subject: Re: effectiveness tool
Previous:From: Judith AltamiranoDate: 2008-10-14 22:34:53
Subject: effectiveness tool

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group