On Fri, 2023-04-28 at 15:19 +0300, Παρασκευη Πασσαρη wrote:
> We are facing a performance issue with the following query. Executing this
> query takes about 20 seconds.
> (the database version is 14.1)
The execution plan seems to be incomplete.
Yours,
Laurenz Albe
=?UTF-8?B?zqDOsc+BzrHPg866zrXPhc63IM6gzrHPg8+DzrHPgc63?=
writes:
> We are facing a performance issue with the following query. Executing this
> query takes about 20 seconds.
Raising join_collapse_limit (to more than the number of joins in
the query) might help. But I think really if performance