Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YXpwA-0000yD-2E for pgsql-performance@arkaria.postgresql.org; Tue, 17 Mar 2015 11:45:30 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YXpw9-00079i-He for pgsql-performance@arkaria.postgresql.org; Tue, 17 Mar 2015 11:45:29 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YXpw8-00079c-LR for pgsql-performance@postgresql.org; Tue, 17 Mar 2015 11:45:28 +0000 Received: from mail-wg0-f46.google.com ([74.125.82.46]) by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YXpw5-0005Xm-Hn for pgsql-performance@postgresql.org; Tue, 17 Mar 2015 11:45:26 +0000 Received: by wgra20 with SMTP id a20so6124495wgr.3 for ; Tue, 17 Mar 2015 04:45:24 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:message-id:date:from:organization:user-agent :mime-version:to:cc:subject:references:in-reply-to:content-type :content-transfer-encoding; bh=u5inm8n/xipdP3hbFu6Xf72PQd0mxXKWD7q+HNzUzi0=; b=mIwRrHKnS6WYjgY0MahAFS9u+4ns0Thp9j++KDiaGTvOtJ19AwWqo8Qpe8eGnhFMu0 tsgL73NkWkdJ4z84um8SAGUXCJYxwordodhSvnpaUoCSx+1bY+kHJYu7xpNNgS6KwMR/ CA3qY3RB3pWPDxVz8TQGUrjeyArHJCMVYH5WEvs2DvVvs6CpyW6OQ7nwOZG+6qbDE7bT p+xGZj43Nt0d54ata4BfFTib6c3PJP1TybqfL9w/vHB+qkq/pSvq98evSPf1IlWhb74O 9uUHeXIPw8aph/SOX0g3wRAmekW+/p3G5Gn5zO72V6DowalETTLsrdpX9ZioLOomGSKQ vJgw== X-Gm-Message-State: ALoCoQmv+yEjxOSaI4O1HOR21bDTFyNxfiAO7niLBQS7vdw1mJVkrzUQDnlzhV+VpZp3T1lgL5LvdmiklbX+FGiInfKYnCGvLdG+3mMmiHmF8V89UbyOj6wbwe8D43Y00L2u17YtQr+mQa8VGvk/iEaiFg+o0Wfw097bQaCbJVoSnGONI2ho3XBNIk1Tbi0mQ+OmnhZbu7I7 X-Received: by 10.194.237.34 with SMTP id uz2mr129217537wjc.157.1426592724085; Tue, 17 Mar 2015 04:45:24 -0700 (PDT) Received: from [192.168.1.163] (ip-78-45-139-138.net.upcbroadband.cz. [78.45.139.138]) by mx.google.com with ESMTPSA id wc10sm156991wic.21.2015.03.17.04.45.22 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 17 Mar 2015 04:45:23 -0700 (PDT) Message-ID: <550813CD.7040605@2ndquadrant.com> Date: Tue, 17 Mar 2015 12:45:17 +0100 From: Tomas Vondra Organization: 2ndQuadrant User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.5.0 MIME-Version: 1.0 To: vjoshi@zetainteractive.com, Jim Nasby , Scott Marlowe , Varadharajan Mukundan CC: pgsql-performance@postgresql.org Subject: Re: Performance issues References: <84a6fe4be04c3ef0a714851977860ac8@mail.gmail.com> <160b8780d89add7f23c4eb9c3debb99d@mail.gmail.com> <55034A48.4040409@2ndquadrant.com> <849e75d9463938372dd4c516f5c5d89c@mail.gmail.com> <55037CEA.5050906@2ndquadrant.com> <55073272.20209@BlueTreble.com> <55074424.9050506@2ndquadrant.com> <55076FFB.9090105@BlueTreble.com> c5231342781287ff8cbc9ac1f20ff036@mail.gmail.com <61a7a27428e588411e8ac1817043205c@mail.gmail.com> In-Reply-To: <61a7a27428e588411e8ac1817043205c@mail.gmail.com> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) 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 On 17.3.2015 12:07, Vivekanand Joshi wrote: > EXPLAIN ANALYZE didn't give result even after three hours. In that case the only thing you can do is 'slice' the query into smaller parts (representing subtrees of the plan), and analyze those first. Look for misestimates (significant differences between estimated and actual row counts, and very expensive parts). We can't do that, because we don't have your data or queries, and without the explain analyze it's difficult to give advices. -- Tomas Vondra http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance