Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VofYM-0006px-BM for pgsql-performance@arkaria.postgresql.org; Thu, 05 Dec 2013 20:29:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VofYL-0007j7-R9 for pgsql-performance@arkaria.postgresql.org; Thu, 05 Dec 2013 20:29:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VofYK-0007j0-Np for pgsql-performance@postgresql.org; Thu, 05 Dec 2013 20:29:40 +0000 Received: from nm22-vm1.bullet.mail.bf1.yahoo.com ([98.139.212.127]) by magus.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VofYG-0007KZ-Su for pgsql-performance@postgresql.org; Thu, 05 Dec 2013 20:29:40 +0000 Received: from [98.139.212.152] by nm22.bullet.mail.bf1.yahoo.com with NNFMP; 05 Dec 2013 20:29:35 -0000 Received: from [98.139.212.237] by tm9.bullet.mail.bf1.yahoo.com with NNFMP; 05 Dec 2013 20:29:35 -0000 Received: from [127.0.0.1] by omp1046.mail.bf1.yahoo.com with NNFMP; 05 Dec 2013 20:29:35 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 209846.47260.bm@omp1046.mail.bf1.yahoo.com Received: (qmail 1665 invoked by uid 60001); 5 Dec 2013 20:29:35 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s1024; t=1386275375; bh=M70kwv+2n/anWnRtA5n6qRMCVHpiJapRce5e0Rvwg4Q=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=1iYXOW/fvD6EZ99xuWKwsTs7YTogubLsV3W0GzoZe+OhJ+cjC578+Y9Zdf2zDXh7H6RVSllDXiyj1XSNDDUYK1kvG45IeOlNvMPKWSt0nU8fCR2XBQD1qwYVCqopzOjkGWBiTuchPFq+t/X50XDVNgHxZo4QUNWh18IRCXojQ6E= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=niUdmF+Qj2E1cDd33kdzsxJ2rGfGeMWxO3j8Dj8MaRU3WxJuejCHEdFj1ikta3sxCfzZv+lO2KIBeDikExDdr/ThNRiWwVgfby5IbWZwp4goE+CGC2RjyFKkT6/0SF/ghnBxIPoibla/msMxW6GJBRUm9igLWbM9RYnwlHt8mR8=; X-YMail-OSG: neS8d3MVM1mmxo.MQaXwtjacw0NPt6eRNjmKyQBKvh68f76 PZ4ma_ZIwoSFwRpcAF6b_w5fVBJrUmHpzoBRpNLXTHBr5n_JiGUgSO1UI9B0 opLgte40BF5b1.sbUYoT8rSG6XmlDNFE_XJHNGKsFIUi02KZ0tbjm4MCwfBe 0gsCmHvKKi6Tx_BjO_T6hECODEzrJjR_GvWLE9GiKaQSL5fqmcPW9EUt4w2P pZPsi5jM4ImO9i8y764yN2.ZLhfAAT4S7Eqg5giIdvhGoWPNrwWGOiQ3i.zL jDLhO92pz150hwWBE_yv0hHKhm_WSYqdIepajWEbNrznHuBvQ_IN.ya_lZ4q 3v8o3tig5GWX3iCPDh8k3615jqcruX5CeHKEdqVu9MiYxdHDXvrfoWzeBVRM MopjUVDeN7N1669OsxEIP2YeCQ4SdJPd2huN90xx3uM1.KVfcb3Vbk0SBEKT DrwX234Eppo7yrs7xQ9O0ePJbZRs3jT3njJNc7O071Z5aQs5SJKZgp8que9W wZsJHLSa4hFHEZdufS8MjzjPkJgxYKyT7WeaCsBhSHLIja2QWCrXpQWP5fJo f26yfINYi3_Jlql5JT1IEl5ngPZnxinBkbsnFHgA- Received: from [76.255.18.237] by web162906.mail.bf1.yahoo.com via HTTP; Thu, 05 Dec 2013 12:29:35 PST X-Rocket-MIMEInfo: 002.001, c2FsYWgganViZWggPHNfanViZWhAeWFob28uY29tPiB3cm90ZToKCj4gVGhlIGhhcmR3YXJlIGlzIHByZXR0eSBnb29kLCBJIGhhdmUgOCBjcHVzIG9mIEludGVsKFIpIENvcmUoVE0pCj4gaTcsIDIuNCBHSCAsIGFuZCAxNiBHaWIgb2YgUkFNLiBJcyB0aGVyZSBhbnkgY29uZmlndXJhdGlvbgo.IHBhcmFtZXRlciB0aGF0IGNhbiBsZWFkIHRvIHRoaXMgaXNzdWUuCgpXaGF0IE9TPwoKLS0KS2V2aW4gR3JpdHRuZXIKRURCOiBodHRwOi8vd3d3LmVudGVycHJpc2VkYi5jb20KVGhlIEVudGVycHJpc2UgUG9zdGcBMAEBAQE- X-Mailer: YahooMailWebService/0.8.169.609 References: <1386252540.32882.YahooMailNeo@web122206.mail.ne1.yahoo.com> <52A08BE0.9080504@xs4all.nl> <1386254627.81908.YahooMailNeo@web122205.mail.ne1.yahoo.com> Message-ID: <1386275375.20377.YahooMailNeo@web162906.mail.bf1.yahoo.com> Date: Thu, 5 Dec 2013 12:29:35 -0800 (PST) From: Kevin Grittner Reply-To: Kevin Grittner Subject: Re: Explain analyze time overhead To: salah jubeh , vincent elschot , "pgsql-performance@postgresql.org" In-Reply-To: <1386254627.81908.YahooMailNeo@web122205.mail.ne1.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Pg-Spam-Score: -2.0 (--) 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 salah jubeh wrote: > The hardware is pretty good, I have 8 cpus of Intel(R) Core(TM) > i7, 2.4 GH , and 16 Gib of RAM. Is there any configuration > parameter that can lead to this issue. What OS? -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance