Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VoZc5-0006sQ-2K for pgsql-performance@arkaria.postgresql.org; Thu, 05 Dec 2013 14:09:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VoZc4-0003JP-CR for pgsql-performance@arkaria.postgresql.org; Thu, 05 Dec 2013 14:09:08 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VoZc2-0003HX-JP for pgsql-performance@postgresql.org; Thu, 05 Dec 2013 14:09:06 +0000 Received: from nm30-vm6.bullet.mail.ne1.yahoo.com ([98.138.91.123]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VoZby-0006MY-PT for pgsql-performance@postgresql.org; Thu, 05 Dec 2013 14:09:05 +0000 Received: from [98.138.226.177] by nm30.bullet.mail.ne1.yahoo.com with NNFMP; 05 Dec 2013 14:09:01 -0000 Received: from [98.138.87.3] by tm12.bullet.mail.ne1.yahoo.com with NNFMP; 05 Dec 2013 14:09:00 -0000 Received: from [127.0.0.1] by omp1003.mail.ne1.yahoo.com with NNFMP; 05 Dec 2013 14:09:00 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 938609.33684.bm@omp1003.mail.ne1.yahoo.com Received: (qmail 67052 invoked by uid 60001); 5 Dec 2013 14:09:00 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1386252540; bh=7FwD0Wxr300L7gSan+NNDkEpvNCkuTEwoZNJrzeP3Lc=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=PWCFoXKUFI1qXXSQkPd7RDyNElAjksXQyaZYFae31luBb7CLLghc/4pgunnh1WAmtcKHWHDMUx3SkAkiOsZl0mUj+9cLqvrANVN2q6izd0AiRmYpNZAamVLIGNdquuIxCvVeHEUUa9FRyiux/btESAEjKYTfYBl1tXvea+orrwk= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=e2yMfSMb8Xx5nCo6pBFtDriV6W9yc7Qak3Toipi14SlPO0R9dw52XWbAlA+8mNL88PAgMMTgu7L6sTaLZIhY1mLDYHbP6nb/6OVZ9nJfmkaNnFxUVI4AauiZD25xyI9p0oOcwX8GV/oHT517nYHcJ+kegMBWMUz2uXuzZ0b0PFo=; X-YMail-OSG: sXhwfw4VM1lSuI.rnkmtp_XTYPf_sZp3vkyxgZcB5nxdwos 4brSVOpp3idoGw1qFQ6aMdYPkfoxBKxo91NpZHRoHemXpks.dFKocgXRsjRF FdMEtIw._zAm_xlBS1x6Kcj0.Ttc9f314Xo.1tHIWo62a_8qHfoflZXByHuK bQYi.2wJx5C2MuBHLfIveCgN7pojh6rZVPuj7BNCD9jXVTQctwIt80OmD6oZ GrMGCXGFguLojcMhN6V.y7gt_Q0WZc7uMdXrHGPHUxQWFnHA1wto_.Cneljb 203edvd1.QoEJNlQfCFtdsxLynRvARdUfs_zYm7dMoskQH0T7ym2Ca5dq4gK 1jcBc1F8Q7Qr4m8w2iwHxfHdOdbZ.jaEDgBKIjJVp8k6zvoX0kD_RuLD6Vfz 84l46.WvUG8_6lZDxZW5l9reWWtrYFokfvN4jKTBqpCXV.iDGTEsz7tIyq55 gtgRG.FW_ruY66h8fXIeWyJ456cob_.kqYuRyF4HOsEVaysfTsjPAXg6k9uU vCEpCog4yLLILtDIjeAeAEZ3PTBrRSOcCpeusBPRrB.9w5LE_l9T89XcZPZy rSyiDEi9naw-- Received: from [80.152.211.89] by web122206.mail.ne1.yahoo.com via HTTP; Thu, 05 Dec 2013 06:09:00 PST X-Rocket-MIMEInfo: 002.001, CgpIZWxsbyBndXlzLCAKCgpXaGVuIEkgZXhjdXRlIGEgcXVlcnkswqAgdGhlIGV4ZWN0aW9uIHRpbWUgaXMgYWJvdXQgMSBtaW51dGU7IGhvd2V2ZXIsIHdoZW4gSSBleGVjdXRlIHRoZSBxdWVyeSB3aXRoIGV4cGxhaW4gYW5hbHl6ZSB0aGUgZXhjdXRpb24gdGltZSBqdW1wcyB0byAxMCBtaW51dGVzLiAKCkkgaGF2ZSB0cmllZCB0aGlzIGZvciBzZXZlcmFsIHF1ZXJpZXMsIHdoZXJlwqAgSSBuZWVkIHRvIG9wdGltaXplO8KgIGFuZCB1c2luZyBleHBsYWluIGFuYWx5emUgbGVhZHMgYWx3YXkgdG8gYSBodWcBMAEBAQE- X-Mailer: YahooMailWebService/0.8.169.609 Message-ID: <1386252540.32882.YahooMailNeo@web122206.mail.ne1.yahoo.com> Date: Thu, 5 Dec 2013 06:09:00 -0800 (PST) From: salah jubeh Reply-To: salah jubeh Subject: Explain analyze time overhead To: "pgsql-performance@postgresql.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-2079400718-172317042-1386252540=:32882" X-Pg-Spam-Score: 3.4 (+++) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org ---2079400718-172317042-1386252540=:32882 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable =0A=0AHello guys, =0A=0A=0AWhen I excute a query,=A0 the exection time is a= bout 1 minute; however, when I execute the query with explain analyze the e= xcution time jumps to 10 minutes. =0A=0AI have tried this for several queri= es, where=A0 I need to optimize;=A0 and using explain analyze leads alway t= o a huge time overhead in factor of 10.=0A=0A=0AThis is a little bit starng= e for me; did any one experience somthing like this? Can I trust the genera= ted plans?=0A=0A=0ARegards ---2079400718-172317042-1386252540=:32882 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable

Hel= lo guys,

When I excute a query,  the ex= ection time is about 1 minute; however, when I execute the query with expla= in analyze the excution time jumps to 10 minutes.
I have tried this for several querie= s, where  I need to optimize;  and using explain analyze leads al= way to a huge time overhead in factor of 10.

= This is a little bit starnge for me; did any one experience somthing like t= his? Can I trust the generated plans?

Regards
---2079400718-172317042-1386252540=:32882--