Although you don't have to do so, it's probably a good idea to set an index on the partition key on each of the individual partitions: postgres=# create index on issued_at_y2018m01(issued_at); CREATE ...