postgresql 10.1 wrong plan in when using partitions bug

Hi,

I configured range partitions on a date column of my main table(log_full). Each partition represents a day in the month. Every day partition has a list parition of 4 tables on a text column.

log_full

          log_full_01_11_2017  -->

                                          log_full _01_11_2017_x1

            log_full_02_11_2017

and so on....

      

The date column consist of date in the next format : YYYY-MM-DD HH:24:SS for example : 2017-11-01 00:01:40

I wanted to check the plan that I'm getting for a query that is using the date column and it seems that the planner choose to do seq scans on all tables.

-Each partition consist from 15M rows.

I have about 120 partitions.

The query : 

any idea what can be the problem? Is it connected to the date format ?

Thanks , Mariel.