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
--
On Tue, Oct 14, 2008 at 4:34 PM, Judith Altamirano
<[EMAIL PROTECTED]> 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.
Google pg fouine.
--
Sent via pgs
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
