Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ...

From: Vitalii Tymchyshyn <tivv00(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ...
Date: 2010-07-28 11:07:08
Message-ID: 4C500F5C.1080802@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

27.07.10 02:03, Lew написав(ла):
> Piotr Gasidło wrote:
>>>>> EXPLAIN ANALYZE SELECT ...
>>>>> Total runtime: 4.782 ms
>>>>> Time: 25,970 ms
>
> Strangely, the runtime is shown with a period for the separator, though.
>
One value is calculated on server by EXPLAIN ANALYZE command, another is
calculated by psql itself.

Best regards, Vitalii Tymchyshyn

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Stone 2010-07-28 12:21:52 Re: Testing Sandforce SSD
Previous Message Vitalii Tymchyshyn 2010-07-28 11:03:59 Re: Pooling in Core WAS: Need help in performance tuning.