Re: effectiveness tool

Your best bet is probably EXPLAIN ANALYZE. This should give you a better 
idea of where the inefficiencies are in your queries. The only way to make 
it more accurate is, as far as I know, increasing the number of rows 
postgresql samples from each table during the vacuum.

Stefano

---------------------------------
Stefano Buliani
Covestor
email: stefano@covestor.com
mobile: +44 (0) 7766295328

This message is intended solely for the recipient(s) to whom it is 
addressed.  If you are not the intended recipient, you should not disclose, 
distribute or copy this email.  Please notify the sender immediately and 
delete this email from your system.
----- Original Message ----- 
From: "Judith Altamirano" <jaltamirano@correolux.com.mx>
To: <pgsql-sql@postgresql.org>
Sent: Tuesday, October 14, 2008 11:34 PM
Subject: [SQL] effectiveness tool


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