Re: Query with high planning time at version 11.1 compared versions10.5 and 11.0

On 2018-Dec-06, Amit Langote wrote:

Hi

> [ Parallel SeqScan on precio_126 to precio_998  ]
> 
> >                      ->  Parallel Seq Scan on precio_999 p_874  (cost=0.00..27.50 rows=1 width=16)
> >                            Filter: ((fecha >= '1990-05-06 00:00:00'::timestamp without time zone) AND (fecha <=
'1999-05-0700:00:00'::timestamp without time zone) AND (pluid = 2))
 
> 
> As you can see from the "Filter: " property above, the baserestrictinfo of
> this Append's parent relation is:
> 
> BETWEEN '1990-05-06' AND '1999-05-07'
> 
> which selects partitions for all days from '1990-05-06' (precio_125) up to
> '1992-09-26' (precio_999).

Looking at my .psql_history, you're right -- I typoed 1990 as 1999 in
one of the clauses.  Thanks, mystery solved :-)

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services