unfortunately that increased the query execution time by a factor of 8: https://explain.dalibo.com/plan/a6d2443d87fea1ee
On Tue, 1 Apr 2025 at 16:28, Tom Lane <t...@sss.pgh.pa.us> wrote: > Chris Joysn <joys...@gmail.com> writes: > > I have an issue when using CTEs. A query, which consists of multiple > CTEs, > > runs usually rather fast (~5s on my environment). But it turned out that > > using one CTE can lead to execution times of up to one minute. > > That CTE is used two times within the query. > > Try labeling that CTE as NOT MATERIALIZED. > > regards, tom lane >