RE: scans on table fail to be excluded by partition bounds
Steven Winfield <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <E9FA92C2921F31408041863B74EE4C2001BD7B6764@CCPMAILDAG03.cantab.local> |
> 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) in the 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.