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-07 00: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
