Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id A33C2632D49 for ; Wed, 28 Jul 2010 08:07:16 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 43449-07 for ; Wed, 28 Jul 2010 11:07:07 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f46.google.com (mail-bw0-f46.google.com [209.85.214.46]) by mail.postgresql.org (Postfix) with ESMTP id 8ADE0632D05 for ; Wed, 28 Jul 2010 08:07:08 -0300 (ADT) Received: by bwz1 with SMTP id 1so3865949bwz.19 for ; Wed, 28 Jul 2010 04:07:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:subject:references:in-reply-to :content-type:content-transfer-encoding; bh=erozThAVvxr07/GFwk7MgB7QnxyaeVJ+i1ORs7/p7Ls=; b=xcheA6Mu98jalxVgM3ApEv1jJxwdcDIcDzUHri9zxi3cMJTfH1TX72WNj0LDb/AtLU CQz8hgqYn1VH6pXYs1ifJZVv4PrbDvOI0ekTTmwx8S/Wqdr3siciQf8yVVbYN4xK5lyg xWCTaZKtUzhQqQv+krk5vEQwzzr6CQBYTiZBc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:content-transfer-encoding; b=NOvw93F/GcqkBVwUR/BBLrznzTHX9/bitJeYOdlrQSf8ogzavElbT7U1d62btjJ6EW s/EBaOiQwZQYVTNnQsq5Zw4BHp6SX60dk4ijiaKTQH+ICxU6gQ2sfhZrQpwe1Z25sqdI scv2oIwNgx3Zzm9oAmtNrYomlHzoUO7Eo1GWs= Received: by 10.204.81.14 with SMTP id v14mr7921654bkk.7.1280315226625; Wed, 28 Jul 2010 04:07:06 -0700 (PDT) Received: from [10.1.1.57] (skuns.zoral.com.ua [91.193.166.194]) by mx.google.com with ESMTPS id x19sm4687666bkv.9.2010.07.28.04.07.05 (version=TLSv1/SSLv3 cipher=RC4-MD5); Wed, 28 Jul 2010 04:07:05 -0700 (PDT) Message-ID: <4C500F5C.1080802@gmail.com> Date: Wed, 28 Jul 2010 14:07:08 +0300 From: Vitalii Tymchyshyn User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.10) Gecko/20100528 Thunderbird/3.0.5 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... References: <4C4D5220.9010101@postnewspapers.com.au> <4C4D547E.50905@gmail.com> <4C4D5BE9.6040808@postnewspapers.com.au> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201007/431 X-Sequence-Number: 39820 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