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
On Friday, April 28, 2023, Παρασκευη Πασσαρη
wrote:
> Dear all,
>
> We are facing a performance issue with the following query. Executing this
> query takes about 20 seconds.
> (the database version is 14.1)
>
Given the possibility of this working better in the supported 14.7 I
suggest starting
Dear all,
We are facing a performance issue with the following query. Executing this
query takes about 20 seconds.
(the database version is 14.1)
The query:
- SLOW QUERY -
SELECT lead_record.id AS id
FROM "lead_record" lead_record
LEFT JOIN