Re: Query performance - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Query performance
Date
Msg-id slrne74iif.jf9.sgunderson@trofast.sesse.net
Whole thread Raw
In response to Query performance  ("Lou O'Quin" <loquin@talleyds.com>)
List pgsql-performance
antonio.batovanja@humanomed.co.at wrote:
> The above query takes 5 seconds to execute!
>
> [...]
>
>  Total runtime: 96109.571 ms

It sure doesn't look like it...

>  Total runtime: 461.907 ms
>
> [...]
>
> Suddenly the query takes only 0.29 seconds!

How are you timing this, really?

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: "Jonathan Blitz"
Date:
Subject: Re: slow query using sub select
Next
From: "Tim Jones"
Date:
Subject: Re: slow query using sub select