On Wed, 21 Jun 2023 at 08:34, Marc Millas <marc.millas@mokadb.com> wrote: > > On Tue, Jun 20, 2023 at 10:14 PM David Rowley <dgrowleyml@gmail.com> wrote: >> >> On Wed, 21 Jun 2023 at 07:42, Marc Millas <marc.millas@mokadb.com> wrote: >> > But if I do the same with clause one OR clause 2, I have to kill the request after an hour, seeing the filesystem showing more than 140 Mb of increased usage. >> >> > link to the anonymized plan of the req with one clause : https://explain.depesz.com/s/TWp4
It's quite difficult to know what the problem is you want to fix here. Your initial post indicated it was the query with the OR condition that was causing you the problems, but the plan you've posted has no OR condition?!
You're more likely to get help here if you take time to properly explain the situation and post the information that's actually relevant to the problem you're having, or state the problem more clearly, as there's a mismatch somewhere.
It might also be worth having a look at https://wiki.postgresql.org/wiki/Slow_Query_Questions . EXPLAIN is not going to tell us what part of the query is slow. I'll let the wiki page guide you into what to do instead.
I know that page. obviously, as I have to kill the request, I cannot provide a explain analyze...