Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1guI7f-0001uJ-SK for pgsql-performance@arkaria.postgresql.org; Thu, 14 Feb 2019 14:36:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1guI7d-00042x-OJ for pgsql-performance@arkaria.postgresql.org; Thu, 14 Feb 2019 14:36:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1guI7d-00042q-9V for pgsql-performance@lists.postgresql.org; Thu, 14 Feb 2019 14:36:17 +0000 Received: from mail-it1-x142.google.com ([2607:f8b0:4864:20::142]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1guI7a-0000CT-0o for pgsql-performance@lists.postgresql.org; Thu, 14 Feb 2019 14:36:15 +0000 Received: by mail-it1-x142.google.com with SMTP id z7so15517464iti.0 for ; Thu, 14 Feb 2019 06:36:13 -0800 (PST) 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=0LYjAxzFzgaDJRkSIWWm1UycBIjBp6cPwL4IGfYpE/E=; b=RteHN5MwsEWbqC+7gopToElMAmjD6Zl9CiEhM1+ESy5qRVhakYaDoV4ZqF4M8QFaWr 5RXAQyitw7u4GDBJcyaX1Jb37QWIBgXTlwvPHx6S1AmLijjj6b0JdrHCm0DZCZ8ncdtG TuZUi0gIOo4UGqsoZ1ZvBjtVn3u8L09tR3ZwPTowhR1RRezHz1rBJwMJk22ccZMcYI1k 4ctrHQqpUu4qcmhLX5MqkoHaI3ueF3vHhIXjwew/0ummi7QyEBDu9oWVuKbyFgAvThBO NQZRSpVE/q1kKrlt5T4IUtsB7urqCxnr9z+nJsdKBSzGaC7mQccIqAQTGEP5oylRfh3c 2P7w== 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=0LYjAxzFzgaDJRkSIWWm1UycBIjBp6cPwL4IGfYpE/E=; b=Nxk/u9DAfYQjUgpSlDe29byJnoAHmKxsXAElPhqin8AtxRmlpYzzOuIigRSb9/+Sz/ T2vhiFoEUtUGqFFqKeGRvyL+XUzzZYJVKZH7ZPSMMPJ4m31NmLUgP6gJkx05aszcXOCq uQdp074NRoJuiPnJMqb74/uDXf306Jh255nLs+OuEGN4AO76YQ8SCPZ0MiN1Q2DtC60r /VVBf77NigFNq92fVVeIXD4m8cafyIFcOze0kGT/YIt8OYGU8x1wocWFZ7NMhmSe2Vaz dMeEDHtGYGAiX56QwrEZnN9iIoSrA39hoLFiGwRDTE7s9Vc0bu7sbdhY6wXGEltEj9D7 kwHA== X-Gm-Message-State: AHQUAuYZ1gfnJ/Vri2E+OjyWXao53TP7zinZ3fQ7uaunxGC3qr4oJS3h 1xJhZeO2BNSdHfzSryMBLM9Y8w== X-Google-Smtp-Source: AHgI3IaWWtNSSRE3NkhWJrkl1RHiAh60EA88I+TkQuP5ysVwcxrG3xwR3uzblWKobwqbFaG4hKy+sQ== X-Received: by 2002:a24:144a:: with SMTP id 71mr1971921itg.86.1550154973334; Thu, 14 Feb 2019 06:36:13 -0800 (PST) Received: from pryzbyj (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id w21sm939627iob.68.2019.02.14.06.36.12 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 14 Feb 2019 06:36:12 -0800 (PST) Received: by pryzbyj (Postfix, from userid 1000) id B0411800A28; Thu, 14 Feb 2019 08:36:11 -0600 (CST) Date: Thu, 14 Feb 2019 08:36:11 -0600 From: Justin Pryzby To: Laurenz Albe Cc: suganthi Sekar , "pgsql-performance@lists.postgresql.org" Subject: Re: partition pruning Message-ID: <20190214143611.GG30291@telsasoft.com> References: <0c1f84989f9a2416d95a46d475e0e79567ade38a.camel@cybertec.at> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <0c1f84989f9a2416d95a46d475e0e79567ade38a.camel@cybertec.at> User-Agent: Mutt/1.5.23 (2014-03-12) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Thu, Feb 14, 2019 at 01:37:49PM +0100, Laurenz Albe wrote: > There is no condition on the table "call_report2" in your query, > so it is not surprising that all partitions are scanned, right? Some people find it surprising, since: a.call_id=b.call_id suganthi Sekar wrote: > > explain analyze > > select * from call_report1 as a inner join call_report2 as b on a.call_id=b.call_id > > where a.call_created_date ='2017-11-01' and '2017-11-30' Justin