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
