8.325 rows=5 loops=1)
Index Cond: ((id > 193208795) AND (id <= 575187488))
Planning Time: 0.166 ms
Execution Time: 402.376 ms
We have tried leading the planner to water with this view but it did not
change the slow query plan:
create view my_fast_large_table as
select *
from my_large_table
where id is not null;
Any other tricks to try here?
Thank you,
Ben Chrobot
Thank you all for your responses!
I will continue to put pressure on the vendor (Stitch Data, if anyone knows
folks there) to address the issue on their end with the query being issued.
Best,
Ben Chrobot
On Tue, Feb 14, 2023 at 11:11 PM Tom Lane wrote:
> David Rowley writes:
> > O
