Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... - Mailing list pgsql-performance

From Craig Ringer
Subject Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ...
Date
Msg-id 4C4D5BE9.6040808@postnewspapers.com.au
Whole thread Raw
In response to Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ...  (Vitalii Tymchyshyn <tivv00@gmail.com>)
Responses Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ...
List pgsql-performance
On 26/07/10 17:25, Vitalii Tymchyshyn wrote:
> 26.07.10 12:15, Craig Ringer написав(ла):
>> On 26/07/10 16:35, Piotr Gasidło wrote:
>>
>>> Hello,
>>>
>>> I've found strange problem in my database (8.4.4, but also 9.0beta3,
>>> default postgresql.conf, shared_buffers raised to 256MB).
>>>
>>> EXPLAIN ANALYZE SELECT ...
>>> Total runtime: 4.782 ms
>>> Time: 25,970 ms

>> Given that, I'm wondering if the difference in this case is planning
>> time. I can't really imagine the query planner taking 20 seconds (!!) to
>> run, though, no matter how horrifyingly complicated the query and table
>> structure were, unless there was something going wrong.
>>
> Actually it's 20ms, so I suspect your point about planning time is correct.

Oh, a commas-as-fraction-separator locale.

That makes sense. Thanks for the catch.

--
Craig Ringer

pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: Re: Testing Sandforce SSD
Next
From: Piotr Gasidło
Date:
Subject: Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ...