unfortunately that increased the query execution time by a factor of 8:
On Tue, 1 Apr 2025 at 16:28, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Chris Joysn <joysn71@xxxxxxxxx> 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
