RE: scans on table fail to be excluded by partition bounds - Mailing list pgsql-performance

> ts=# explain SELECT * FROM eric_enodeb_cell_metrics WHERE start_time
> BETWEEN '2019-01-01 04:00' AND '2019-01-01 05:00' OR start_time BETWEEN
> '2019-01-02 04:00' AND '2019-01-02 05:00'

Maybe it's because of the implicit usage of the local timezone when the strings are cast to (timestamp with time zone)
inthe values you give for start_time here? 
What happens if you specify it using "TIMESTAMP WITH TIME ZONE '2019-01-01 04:00-05'", etc.?

Steve.