Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-performance-owner+M55371=pgsql-performance-ar@postgresql.org>)
	id 1djrWp-0003f0-Iv
	for pgsql-performance@arkaria.postgresql.org; Mon, 21 Aug 2017 18:34:23 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-performance-owner+M55371=pgsql-performance-ar@postgresql.org>)
	id 1djrWo-000289-Mm
	for pgsql-performance@arkaria.postgresql.org; Mon, 21 Aug 2017 18:34:22 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <pryzby@telsasoft.com>)
	id 1djrV4-0007Ti-HI
	for pgsql-performance@postgresql.org; Mon, 21 Aug 2017 18:32:34 +0000
Received: from mail-it0-x22d.google.com ([2607:f8b0:4001:c0b::22d])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.84_2)
	(envelope-from <pryzby@telsasoft.com>)
	id 1djrV0-0006fN-N2
	for pgsql-performance@postgresql.org; Mon, 21 Aug 2017 18:32:33 +0000
Received: by mail-it0-x22d.google.com with SMTP id 77so35258640itj.1
        for <pgsql-performance@postgresql.org>;
 Mon, 21 Aug 2017 11:32:29 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=telsasoft-com.20150623.gappssmtp.com; s=20150623;
        h=date:from:to:cc:subject:message-id:references:mime-version
         :content-disposition:in-reply-to:user-agent;
        bh=uhcwUSiFDvHXjGnAix6gWhdfuKjRrETgQEygVVW0iow=;
        b=W+1Z9aFbNjtZm/UtSKmxPkmP8h8/2e23LX7587VpNB5x8NZAV254J9Xn7zZkJT9WYa
         OFOpHpEHLZQG6boCB6PJzQRAChlslS/2z97SJ1XB7MiJyMJV1zaPrCUa4s+qGSmOQo3I
         rBG4x6tNdJcPxvlP+ncOmDOpy2SVUopTsuowaCZFPYRg5iUp35hTjZA9s14zOdt2MuV3
         itTKKU5ffnEqjlEkWbvpV6/oRydrIHlIBjH+zTO9FlHUa+9d4UvKHwiRAsYvX1VW3A19
         T82UX3ylre4HFT5S+l8lRUnr6bIMMGxD+qjcGVfOA9URYga2cvZzanRsWU1xDiQ66g8i
         4zxg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:date:from:to:cc:subject:message-id:references
         :mime-version:content-disposition:in-reply-to:user-agent;
        bh=uhcwUSiFDvHXjGnAix6gWhdfuKjRrETgQEygVVW0iow=;
        b=oCiLkPJKn2YbopqqIah83X1l8qxh3yRdtGYug+bq6XIg1GS9GcLR+GDho9xsDx2OnA
         EINupPHjR517RsYM2D1zarJg6CnMnX0AecTt/mEqvb95JzyHbI6ZsAIyBapkAIJLwicu
         0iFJt3Stunpz321hCW+guqZ8FoA/gj2mzwiEWsrMsN4puVDHO9O/L0WIgktXzdCxj786
         vZmBpQ9++tMY2KLUrKS/hJQuJTXRungI3XgA3DUhM8IG1lKoO4POsmvaTgApIMXB/XmH
         pEA4hOfA09Y5EhqqKiDL6LMCSJFumXjorTpWIHugZhlXJ5t5bAtX+18VsBfzBjxWYKyd
         h1yg==
X-Gm-Message-State: AHYfb5hQkHMmMCAUBFg3AfjAjqkRRhgsU5qGZledMper5CHGXlDJl/9R
	azET80TA9tzTQLYQ
X-Received: by 10.36.8.7 with SMTP id 7mr6777373itc.117.1503340348217;
        Mon, 21 Aug 2017 11:32:28 -0700 (PDT)
Received: from pryzbyj (charmander.telsasoft.com. [50.244.222.1])
        by smtp.gmail.com with ESMTPSA id
 z66sm6057335ioz.15.2017.08.21.11.32.27
        (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);
        Mon, 21 Aug 2017 11:32:27 -0700 (PDT)
Received: by pryzbyj (Postfix, from userid 1000)
	id 982BF80377F; Mon, 21 Aug 2017 13:32:26 -0500 (CDT)
Date: Mon, 21 Aug 2017 13:32:26 -0500
From: Justin Pryzby <pryzby@telsasoft.com>
To: anand086 <anand086@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance Issue -- "Materialize"
Message-ID: <20170821183226.GW24376@telsasoft.com>
References: <1503164276875-5979128.post@n3.nabble.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <1503164276875-5979128.post@n3.nabble.com>
User-Agent: Mutt/1.5.23 (2014-03-12)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

On Sat, Aug 19, 2017 at 10:37:56AM -0700, anand086 wrote:
> +-----------------------------------------------------------------------------------------------------------------------------------------------------------+|                                                                       
> QUERY PLAN                                                                        
> |+-----------------------------------------------------------------------------------------------------------------------------------------------------------+|
> Aggregate  (cost=351405.08..351405.09 rows=1 width=8)                                                                                                    

Would you send explain ANALYZE and not just explain ?

Justin


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance