Re: need explanation about an explain plan

2023-07-02 Thread Umut TEKİN
>do that. If we could find a cheap enough way to remove those during >planning, then we probably should. Then, we have to wait for that feature. Thanks! On Mon, Jul 3, 2023 at 12:06 AM David Rowley wrote: > On Fri, 30 Jun 2023 at 00:42, Umut TEKİN wrote: > > @Marc, I think t

Re: need explanation about an explain plan

2023-06-29 Thread Umut TEKİN
Hi, @Marc, I think there is no problem.Even though it says it is filtered by ladate, it is not. Because of the partition. As you can see for each index scan it uses a different partition and those partition boundaries are already specified logically. For example; "Parallel Index Scan using table1_