Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 81E46632350 for ; Mon, 14 Jun 2010 10:50:54 -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 78860-10 for ; Mon, 14 Jun 2010 13:50:46 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from marajade.localdomain (vcs5.camavision.com [63.228.164.252]) by mail.postgresql.org (Postfix) with ESMTP id 762DD6302CB for ; Mon, 14 Jun 2010 10:50:46 -0300 (ADT) Received: from [192.168.1.103] (173-20-246-8.client.mchsi.com [173.20.246.8]) (Authenticated sender: andy) by marajade.localdomain (Postfix) with ESMTPA id 9E452502BA; Mon, 14 Jun 2010 08:50:42 -0500 (CDT) Message-ID: <4C1633B0.8090101@squeakycode.net> Date: Mon, 14 Jun 2010 08:50:40 -0500 From: Andy Colson User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.9) Gecko/20100317 Lightning/1.0b1 Thunderbird/3.0.4 MIME-Version: 1.0 To: AI Rumman , pgsql-performance@postgresql.org Subject: Re: query tuning help References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201006/244 X-Sequence-Number: 39100 On 06/14/2010 05:41 AM, AI Rumman wrote: > Can any one please help me in tuning the query? > > explain > select * > from (select * from crmentity where deleted = 0 and createdtime between > (now() - interval '6 month') and now() ) as crmentity > inner join (select * from activity where activitytype = 'Emails' and > date_start between (now() - interval '6 month') and now()) as activity > on crmentity.crmid=activity.activityid > inner join emaildetails on emaildetails.emailid = crmentity.crmid > inner join vantage_email_track on > vantage_email_track.mailid=emaildetails.emailid > left join seactivityrel on seactivityrel.activityid = emaildetails.emailid > Can you send us 'explain analyze' too? > -> Seq Scan on emaildetails (cost=0.00..1686.95 rows=44595 width=186) > -> Seq Scan on vantage_email_track (cost=0.00..1324.52 rows=88852 width=12) do you have indexes on emaildetails(emailid) and vantage_email_track(mailid)? -Andy